Format Excel from Access

[Joker via AccessMonster.com]

Hello,

What I need is to be able to format an Excel file from with Access VBA code.
I recorded a macro is excel and tried using the code in Access and obviously
it had different sytax. Does anyone know a good resource or website that can
help me with this? I have searched to no avail. Thanks.

 

[Douglas J. Steele]

See whether what I've got in my July, 2005 "Access Answers" column in
Pinnacle Publication's "Smart Access" is enough to get you going.

You can download the column (and sample database) for free at
http://www.accessmvp.com/djsteele/SmartAccess.html

 

[Joker via AccessMonster.com]

Douglas,

That is working well for now. I may have to revisit this in the near future.
Thanks a lot for your help. Your knowledge is amazing. Do you have any
favorite references (books, websites, etc) you can recommend for very
advanced VBA?

 

[Douglas J. Steele]

The Access Developer's Handbook. http://www.developershandbook.com/