 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Macros / May 2008How can I format Excel Spreadsheet in OutpuTo Macro?
Hello, I've created a macro that takes the contents of a table, and dumps the data into an excel spreadsheet. What I would like to do is somehow format that data as it arrives in the excel spreadsheet so that I can tell at a glance which data is new. So is there a way to possibly bold the data that is being transferred to an excel sheet using the OutputTo Macro? Thanks in advance. rashar, macros are a bit limited in what they can accomplish compared with using vba code instead. If you search these discussion groups, you will find many examples using vba code to format an excel spreadsheet. Unfortunately, a macro is just not the correct tool to use for this. Jeanette Cunningham -- Melbourne Victoria Australia > Hello, > [quoted text clipped - 9 lines] > > Thanks in advance. There is one trick I have used to get there. Use a query to create your table/records to export and add a date or some kind of identifier to another field. Then just use condtional formating in excel to format those rows/cells that match your date/identifier. ' > rashar, > macros are a bit limited in what they can accomplish compared with using [quoted text clipped - 19 lines] >> >> Thanks in advance.
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.