Automating the naming of an excel file that has been exported from access

  • Thread starter Thread starter grantschneider
  • Start date Start date
G

grantschneider

I use a form to run queries and I have created a macro to send those
queries to excel. I have tried to care it so that it will pick up the
name for the file from the form. The specific part of the form is
Forms!SVP!SVP. I have tried to put this in the filename box on the
macro but it always just gives me what I put in instead of the correct
SVP.

I hope this is clear
 
Back
Top