excel macros in access

[susie]

I have a database that automatically exports data to excel. I want to format
this data in excel automatically through a macro in access. How do I get
access to allow me to do this?

I don't want to do anything complicated, just things like increase the row
height and column width and turn some things bold.

Hope you can help

 

[Ken Snell [MVP]]

You can't do this in an ACCESS macro, but you can do it via Automation in
VBA code (ACCESS opens EXCEL file and manipulates the data).

If you know EXCEL VBA, it's fairly easy to do from ACCESS...the primary
trick is that you must fully qualify the references via EXCEL application
object that you must set in the VBA code.