How can I format Excel Spreadsheet in OutpuTo Macro?

[rashar via AccessMonster.com]

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.

 

[Jeanette Cunningham]

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

 

[Pete D.]

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
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