Docmd.RunCommand acCmdImport

[glnbnz]

I have this code

Docmd.RunCommand acCmdImport

I was wondering if I can code the path to the directory so when the 'Import'
box opens it is already at the folder of the file that needs importing?

thanks in advance
glnbnz

 

[Klatuu]

Not using that kind of code.
Since you don't say what kind of file you are importing, I can't be
specific, but to import Excel files, see VBA Help for the TransferSpreadsheet
method, for text files, see TransferText.