Save a text file using a variable as the file name

[KiwiDave]

Hi. Total newbie. I can extract some data from my database, but I need to save it as a .csv file using a variable to make the filename unique (based on some of the content). I can do everything except insert the variable as teh file name. Can anyone assist please?

Here's the code in question: As you can see, the code always saves the file as "\AllData Test.CSV. I need the file name to be the variable called "NameFileAllData" & .csv

Application.DefaultFilePath = "C:\Users\owner\blah\blah\blah"

myFile = Application.DefaultFilePath & "\AllData Test.CSV"


Any help would be appreciated.

Many thanks

 

[Joe4]

Welcome to the Board!

Note that in VBA, everything between double-quotes is treated as literal text. So you want all variables to be outside of double-quotes/
So if your variable is named "NameFileAllData", then the your code should look something like this:

myFile = Application.DefaultFilePath & "\" & NameFileAllData & ".CSV"

 

[KiwiDave]

Welcome to the Board!

Note that in VBA, everything between double-quotes is treated as literal text. So you want all variables to be outside of double-quotes/
So if your variable is named "NameFileAllData", then the your code should look something like this:

myFile = Application.DefaultFilePath & "\" & NameFileAllData & ".CSV"

Thanks Joe. Now it just returns a file named .CSV
It didnt pick up the named range. ?

 

[Joe4]

It didnt pick up the named range. ?

That is new information. No where in your original post did you say that NameFileAllData was a named range. You said it was a variable.
Named ranges and variables are two totally different things altogether!

So, is NameFillAllData really a named range on your Excel sheet?
If so, is it EXACTLY a single cell named range (and not covering multiple cells)?

If it is, then the code should look like:

myFile = Application.DefaultFilePath & "\" & Range("NameFileAllData").Value & ".CSV"

 

[KiwiDave]

Thank you very much Joe. That works perfectly. Sorry about not understanding the difference between named ranges and variables. I suspect it will be a long learning curve. I appreciate the help.
Regards
David

 

[Joe4]

No worries.
Glad I was able to help!