Running excel macro as part of my Access 2007 macro. (1 Viewer)

[pete6256]

Greetings everyone,

I am a bit of a newbie, so I'm not sure how obvious this is. But I am creating an Access 2007 macro at the moment and need some help with it.

One of the actions in my access macro is to export a file to excel and save it. When the excel file is exported, it automatically opens - at this stage I want to run an excel macro that would modify this exported file.

Is there a macro 'action' I could select that would enable me to run an excel macro once this file is exported?

If not, is it possible to open the access macro in VBA and insert some code that would enable me to run an excel macro?

Thanks very much in advance for any help,

Kind Regards,

Pete

 

[r.harrison]

Could you not modify the report before the export process?

 

[pete6256]

Hi there,

I don't think so,

The export from Access process involves saving it in a specific location and then part of the excel macro I want to run involves resaving it in a different location.

Regards,

Pete