transfer spreadsheet assign filename

[ali32j]

Hi All

I am looking to transfer a query from access to Excel file using VB code. I have the following code

Dim FileName
FileName = [Forms]![aform1]![User]

DoCmd.TransferSpreadsheet acExport, , _
"CustomerDetails", _
FileName, True

but i need to add location information to this, can anyone tell me how to specify the folder to save the file in??

thanks

Ali

 

[HarleyQuinn]

Something like:

Dim FileName
FileName = "C:\MyFolder\" & [Forms]![aform1]![User]

DoCmd.TransferSpreadsheet acExport, , _
"CustomerDetails", _
FileName, True

?

Hope this helps

HarleyQuinn
---------------------------------
You can hang outside in the sun all day tossing a ball around, or you can sit at your computer and do something that matters. - Eric Cartman

Get the most out of Tek-Tips, read FAQ222-2244: How to get the best answers before posting.

http://lessthandot.com

 

[ali32j]

Hi

Appreciate your help but this has saved a file in my documents titled "0.XLS" ...??

Could it be my system causing the problem??

Ali

 

[HarleyQuinn]

What is in [Forms]![aform1]![User]?

HarleyQuinn
---------------------------------
You can hang outside in the sun all day tossing a ball around, or you can sit at your computer and do something that matters. - Eric Cartman

Get the most out of Tek-Tips, read FAQ222-2244: How to get the best answers before posting.

http://lessthandot.com

 

[ali32j]

user name "Andrew harper

 

[ali32j]

ah ok i needed to put extra \ in, and had slight error, working perfectly now thankyou!

Ali

 

[ali32j]

if i wanted to export multiple tables to the same file, do i need repeat the code? or is there an easier way to do this?

Ali