Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
fields names do not show in excel 2007 pivot table fields list | New Users to Excel | |||
Access 2003: transferspreadsheet writes over existing spreadsheet | Excel Discussion (Misc queries) | |||
how can I convert data with fields in rows to fields as columns | Excel Discussion (Misc queries) | |||
Excel SHOULD NOT AUTO-CHANGE formated text fields to DATE FIELDS! | Excel Worksheet Functions | |||
Need pie chart with number of fields instead of info in fields | Charts and Charting in Excel |