How to keep a path unbroken in VBA?
I have the Code:
Dim stAppName As String
stAppName = ("C:\Program Files\Microsoft Office\Office12\EXCEL") & " " & "\\Directory\Finance\filename\Database" & " " & "Tools\Drop" & " " & "Ship\Dropship_Payments_Import.xls'"
Call Shell(stAppName, 1)
Cmd on a button in an Access Form. It brings you to the excel program just fine, but it can't find the file, due to the path being broken at the spaces. The company is large and the folder names can not be changed. What's the best way to ignore spaces in a path. The error says it can't find the file, which is split by the spaces in folder names.