DoCmd.TransferSpreadsheet

  • Thread starter Thread starter Denise R.
  • Start date Start date
D

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...
 
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
 
Back
Top