Recently, I had to change the appearance of an excel export.
I did not find a table containing the integer values of the excel contant names you get when you record a macro. So I called in the help of Theo.
The simplest way is to use the ‘immediate window’ in VB. Press CTRL-G to make it appear in your vb-window.
You can then simply type: “print xlUnderlineStyleSingle” which will show you “2″.
For your reference, I’ll attach the entire table.
