Saved Exports at runtime

[Neetika]

Is it possible to make saved exports available at runtime to enable users to
export to WORD/EXCEL?

 

[Piet Linden]

Is it possible to make saved exports available at runtime to enable usersto
export to WORD/EXCEL?

you could use a query and then pass the result sets the query
generates to Word or Excel. What do you mean by saved exports?

 

[Neetika]

In ACCESS 2007, when I export a report, it allows me to save the export. I
can later go to the Saved Export and perform the export quickly.

In runtime, export to WORD/EXCEL and all related exports are disabled. I was
trying to figure out if there was a way of making them available at run-time.

 

[Albert D. Kallal]

Is it possible to make saved exports available at runtime to enable users
to
export to WORD/EXCEL?

If you already make the export, then it WILL work in the runtime. You just
have to provide the interface part....

if you place a button on a form with:

DoCmd.RunSavedImportExport "MyWordExport"


The above will work.

Keep in mind if you used "my documents", or the desktop for a destination,
your path name is likely hard coded with your existing user name....

So, I not looked into how you control the output location, but the SAME
output location as to when you saved the export steps will remain in effect
on that target machine. So, you might have to set the output to your c:\
since that don't change from user to user...

You likely better to setup a few buttons using transfertext (for word), or
transferspreedsheet for excel.

However, the saved exports can be run as above, but I think you better off
using the transfer text/spreadsheet which the export system is based on
anway....

However, if you provide the button (user interface), the you can use the
RunSavedImportExport command.....