Hello,
With below VBA I export data to a xml-file. I have not choosen any path so it saves the file to MyDocuments. Preferably I want the user to choose a location where to save the file before the file is saved; so a dialog window should open, location is choosen by the user and then click "Save" or "Export". I have looked for a solution in this forum but have nothing suitable found so far.
Question is: how to do this?
Code:
Application.ExportXML ObjectType:=acExportTable, DataSource:="tblImEx", _
DataTarget:=Me!VoyageRef & " - " & Me!ShipsName & " - " & Me!DateOfDeparture & ".xml"