Prev: how do I convert date format yyyymmdd to mm/dd/yyyy
Next: How do I multiply ALL CELL in spreadsheet at once by .5 ?
From: alex on 10 Feb 2010 10:34
TransferSpreadsheet to colored fields

Hello,

I have an MS Access file that transfers data to Excel using the
TransferSpreadsheet method…

It works fine, but I’d like to programmatically color the fields based
on the header values—or, even simpler, color the first 4 fields in red
(e.g.), the next 3 blue, etc, all in VBA from Access!

I’m thinking it’s possible to transfer a spreadsheet to a template
(which would hold the colors above) and name it based on the code
contained in the method.

Can anyone point me in the right direction…provided there is one?

Thanks,
alex
 | 
Pages: 1
Prev: how do I convert date format yyyymmdd to mm/dd/yyyy
Next: How do I multiply ALL CELL in spreadsheet at once by .5 ?