Neetika said:
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.....