VBA Importing files in Access from the db location

B

BrianS6460

How do I get VBA to look for an txt file in the same location (path) a
the mdb without having to specify or using the import dialog. man
thanks
 
D

DL

By writing a procedure to locate the path of the mdb, assingning that to a
variable then using that info to get the specific file?
 
B

BrianS6460

Thanks DL. My VBA is not that robust. can you start me off with a very
simple example to locate the path and assigning it to a variable?

Much appreciated!
 
Top