Formatting Header in VBA select statement

[corkster]

Hi all,

I have MS access 2003. I am wondering if this is possible.

I am using VBA in a form to export data to Excel Using transfer
spreadsheet. Within the VBA is a select statement using querydefs. Is
there anyway to place background color in the Header of the fields in
the select statement or somewhere in the vb code. There are 4 fields I
would like to color. I am not looking at doing conditional formatting.
Just placing a color within the header when it exports to excel.

Is this possible?

Thanks
Corky

 

[Douglas J. Steele]

It's not possible using TransferSpreadsheet, but once you've got the data
into the workbook, you could use Automation (for that matter, you could use
Automation to get the data into the workbook, but that's more work...)

Take a look at my July, 2005 "Access Answers" column in Pinnacle
Publication's "Smart Access". You can download the column (and sample
database) for free at http://www.accessmvp.com/djsteele/SmartAccess.html

 

[corkster]

Doug,

I didn't think it was possible, but had to ask to be sure.

Wow very nice, excellent reference. I really appreciate the link.

Thanks for you help.