Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Initialize “Choose/Save export file” dialog box to a specific dir

Status
Not open for further replies.

agersh

Programmer
May 8, 2003
12
US
I would like to use the Report object Export method to provide a simple mechanism for exporting reports.
My only problem is that I would like to initialize the “Choose/Save export file” dialog box to a specific directory before it is displayed. Somewhat like setting the visual basic CommonDialog.InitDir property.

Is this possible?
 
I'm not aware of a way of controlling where the default directory will be.

However, you could control the process yourself, with a bit of coding. You could capture the export button click event in the viewer and use it to launch your own form that would prompt the user for whatever info you want them to select, including or not including the directory to send the report to. The ExportOptions object allows you to set things like the filename, which includes the full path.

Then when you call the Export method, you'd choose False for the "prompt user" argument.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top