ExportXML help - how to allow user to specify target??

[jjh]

Hi:
I have a control on my Access application switchboard that will export certain tables in my DB using the ExportXML method. It works fine. However, according to MS, the SchemaTarget, Datatarget, and DataSource have to be strings. I want to popup a typical MS file save window, let the user specify filename and location (tried to use CommonDialog.ShowSave but didnt work), and then pass the file name and location to ExportXML. Can anybody show me the code to do this?
Thanks
J
The example of Exportxml that works, is below.
---------------------------


Application.ExportXML ObjectType:=acExportTable, DataSource:="system_INSTANCE", _
SchemaTarget:="c:\SystemInstanceExportTest.xsd", _
DataTarget:="c:\SystemInstanceExportTest.xml", AdditionalData:=objSystemInfo

 

[RoyVidar]

To allow them to specify filename and location, check out http://www.mvps.org/access/api/api0001.htm

 

[jjh]

To allow them to specify filename and location, check out http://www.mvps.org/access/api/api0001.htm

Will this work within Access 2003, in VBA code associated with a control? Also, I am using xp-sp2.

Thanks for the pointer!
J

 

[jjh]

That worked...

To allow them to specify filename and location, check out http://www.mvps.org/access/api/api0001.htm

THank you...This worked fine in my environment.

-John