Importing with a variable name

  • Thread starter Thread starter OEB
  • Start date Start date
O

OEB

How do I specify in a macro the name of a file if I want it to take a
variable name? I have a form that I am getting a variable name from and I
want to run a query and export it to a spreadsheet.

I am putting in c:\planning\ & =[Forms].[My Projects].[PlnrName] &
_projects.xls but the name is exactly that and not the expression.

Thanks.
 
I don't use macros, but try

"c:\planning\" & [Forms].[My Projects].[PlnrName] & "_projects.xls"
 
Back
Top