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.

Constants Exported by Type Library EXCEL9.OLB

Bookmark:

Mainsoft’s SharePoint^® Integrator for Lotus^® Notes^® is an easy to deploy, client-side plug-in for Lotus Notes 8 that delivers instant access to SharePoint document libraries from within the Lotus Notes user interface. Users can work more productively by dragging-and-dropping SharePoint content such as Microsoft^® Word^® documents, Excel^® spreadsheets, and PowerPoint^® presentations into Notes emails or calendar appointments.

Take a look at the website of Mainsoft

Bookmark:

[youtube]http://www.youtube.com/watch?v=H72yHHdFCIA[/youtube]

Bookmark: