If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
TransferSpreadsheet to colored fields
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 |
Thread Tools | |
Display Modes | |
|
|