string as file name/path in macro

[datacontrol]

I have a variety of modules set up that allow the user to browse for a file and import it. The name of my string is Me.FileName.

I have a macro that I use to import a specific excel spread sheet. How would I define the string in the file name field in Access' macro design view?

Thanks in advance!

 

[spacepro]

Why don't you convert the macro to VBA so that you have greater control of the arguments and you could also use error trapping for the import?

Just a thought

Andy