
April 6th, 2005, 07:25 PM
|
|
Registered User
|
|
Join Date: Apr 2005
Location: O'Fallon, MO
Posts: 1
Time spent in forums: 17 m 4 sec
Reputation Power: 0
|
|
|
Need help desparately vb in Access
I am trying to write a macro to import an *xml file into Access.
After I select the file, I have no problem. I need to write a macro that will allow me to view a selected directory and then choose the file from among many.
I need to lookk ar the dir select a file, put that filename into a variable and then put that variable name into this
example:
Application.ImportXML "c:\a_b\xml_ab\2004\{filename}, acAppendData"
Anyone, PLEASE HELP!!!! :-(
|