DoCmd.TransferSpreadsheet

[Denise R.]

I want to save a xls.-file to a path on our server.

This is the coding:
DoCmd.TransferSpreadsheet acExport, 8, "demo123", "\\server\route 1\MA bei
Töchtern VW AG_Kreuztabelle.xls", True, ""

As you can see the node "route 1" has a space...
.... and so the program can't find my folder...

Is there a possibility to make this path readable ??

Thanks for your help...

 

[ND Pard]

Try this:
Dim strFolder As String
strFolder = "Route 1"

DoCmd.TransferSpreadsheet acExport, 8, "demo123", _
"\\server\" & strFolder & _
"\MA bei Töchtern VW AG_Kreuztabelle.xls", True, ""

Good Luck