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

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Naming files automatically 1
Querying multple criteria but allowing them to not be blank 3
Problem with forms/parameter query 2
export several forms to the same excel file 1
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Macro using problem. 1
Exporting Multiple Queries to the same Excel File 4
User input to continue running the macro 4

Top