Combine Saved Exports

[sathsaj]

I have been exporting data from Access onto Excel.
Now have six separate "Saved Exports"
Trying to create a single macro that executes all these data tasks with one button/click. DO not see an option in the macro building lists.
Help? Advice? Examples?
Thanks. Namaste.

 

[Gasman]

You could create a macro/vba snippet that would run each in turn?
I do that for my 'batch' operations.

 

[sathsaj]

How would I do this ? can you help me

 

[Gasman]

Use RunSavedImportExport option each time
You need to select 'Show All Actions' to see that and other macro options.

 

[sathsaj]

Use RunSavedImportExport option each time
You need to select 'Show All Actions' to see that and other macro options.

Sorry - How do I see 'Show All Actions' ? Iam not much familiar with this. Sorry If am troubling you

 

[Gasman]

I am only on 2007, but in that I would

Select Create
Select Macro/Macro
Select 'Show All Action's

then add a line for each macro in the order you want them to run.

 

[sathsaj]

I am only on 2007, but in that I would

Select Create
Select Macro/Macro
Select 'Show All Action's

then add a line for each macro in the order you want them to run.

Cool, I have used Macro before, but I never noticed this Show All Actions button. It worked and am Glad I could close this out. Thanks Gasman for the Help