Calling Export Wizard from VBA

[Blueskies]

Hi

Can the Export Wizard be called from a VBA module? (I imagine it could be done by sendkeys, but I don't want to go there.....)

It would be great if I could pass it the name of a query I want to export as Excel, and then have the wizard take over from there.

Thanks for reading.

 

[Blueskies]

No worries - found it:

DoCmd.RunCommand acCmdExportExcel

 

[theDBguy]

Hi. You could try using either the RunCommand method, which could start the Wizard or the OutputTo method, which could prompt the user for the format and filename.

 

[theDBguy]

No worries - found it:

DoCmd.RunCommand acCmdExportExcel

Oops, too slow. Glad to hear you got it. Good luck with your project.

 

[Blueskies]

Thanks for reply - great to know you can get help on these forums!

 

[theDBguy]

Thanks for reply - great to know you can get help on these forums!

Of course. We’re happy to assist. Cheers!

 

[NauticalGent]

PMFJI, but if the export is the same filename and format, etc, you might what to look into saved exports...