Can VBA be used to identify filename in-use by another application?
Posted on 2011-02-28
I'm using Access 2007 to import an .XML file into Excel, modifing the format, then saving the file as input to a table in Access. Currently, this has to be done due to .XML attributes do not automatically import into Access tables. (ie. <Employee ID="John"> : ID="John" is not imported into Access.) I will attempt this after I solve the question below.
The file being imported is generated by the user in a non-Microsoft program and saved using standard windows FileDialog. The file may not have been opened by this program, but instead created through it's use. The file must be saved in a specific location prior to use by Access.
Can VBA be use to identify the filename in use, Opened or Saved, by this executable with the user's input through FileDialog?
The method I currently have only identifies the filename if opened (not saved) via Windows Explorer.