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!

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