Combine Saved Exports (1 Viewer)

sathsaj · Jun 28, 2018

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 · Jun 28, 2018

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

sathsaj · Jun 28, 2018

How would I do this ? can you help me

Gasman · Jun 28, 2018

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

sathsaj · Jun 28, 2018

Gasman said:
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 · Jun 28, 2018

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 · Jun 28, 2018

Gasman said:
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

Combine Saved Exports (1 Viewer)

sathsaj

Registered User.

Gasman

Enthusiastic Amateur

sathsaj

Registered User.

Gasman

Enthusiastic Amateur

sathsaj

Registered User.

Gasman

Enthusiastic Amateur

sathsaj

Registered User.

Similar threads

Users who are viewing this thread