DoCmd.RunSavedImportExport file name

[svcghost]

Hey guys,



I am using DoCmd.RunSavedImportExport "ExportXML"

to automatically export a file. But I want to be able to choose the name of this file.

Any ideas?

I don't really care how it's done, just need to do it. For example, a textbox on a form to specify the name of the file, or preferably a dialog box that pops up asking for the name.

[maximus]

Try this:
Code attached to a command Button. when Clicked shoots up a input box which collects the file name:

Dim strTypeFileName As String
strFilename = InputBox("Please type file Name")
DoCmd.RunSavedImportExport strFileName

To use a text box say text1:

Dim strTypeFileName As String
strFilename = Me.text1
DoCmd.RunSavedImportExport strFileName

[svcghost]

This won't work because the argument thrown to RunSavedImportExport must be the Saved Export name, which is a fixed name for the saved export action, not a filename.

[svcghost]

This won't work because the argument thrown to RunSavedImportExport must be the Saved Export name, which is a fixed name for the saved export action, not a filename.

anyone else have an idea?

[jasonbarnes]

Did you ever figure this out? I am going to have the problem very shortly. Hopefully the books I just ordered will give me the answer.

I'm thinking we'll have to ditch the DoCmd.RunSavedImportExport
and do the whole export from vba

If I figure it out I'll let you know.

[svcghost]

Nope. I decided to go a different route, which worked for me. But I never implemented a dialog box or other method of choosing a name for the file on the spot.. but I can't imagine it's too much more work given that you know this:

Private Sub ExportXMLData()
Application.ExportXML _
ObjectType:=acExportTable, _
DataSource:="TableNameHere", _
DataTarget:="FilePathHere"
 
End Sub

For the TableNameHere, use the table name (e.g. Customers)
For the FilePathHere, use a file path INCLUDING the file name (e.g. C:\Exports\customer_export.xml) (or, C:\Exports\" & vFileName & ") vFileName would be your variable holding the file name.

Now since you wanna choose the name of the file, I suggest using the variable approach in place of the customer_export.xml like above.. then use that variable to be received from what you type in a dialog box.

Doest this help? Hope so.

[thhui]

In order to use the file dialog,
you have to insert code for windows api class to open the file dialog.

See the following link for reference:-
http://www.mvps.org/access/api/api0001.htm