I am trying to open a workbook with a command button on a form however the path to the file is giving me a fit. The path for the file location contains spaces and I am going blind trying to figure out how to rectify the path. Heres the line. I am sure someone here will see this problem quick! Thanks.
Private Sub Command0_Click()
On Error GoTo Err_Command0_Click
Dim stAppName As String
stAppName = "Excel.exe N:\OPS\COMMON\OpsResearch\Contact Center\DI CCL Reporting dB\Apps by Agent.xls"
Call Shell(stAppName, 1)
Exit_Command0_Click:
Exit Sub
Err_Command0_Click:
MsgBox Err.Description
Resume Exit_Command0_Click
End Sub
Heres the mess I made out of it:
stAppName = "Excel.exe N:\OPS\COMMON\OpsResearch\Contact" & Chr(32) & "Center\DI" & Chr(32) & "CCL" & Chr(32) & "Reporting" & Chr(32) & "dB\Apps" & Chr(32) & "by" & Chr(32) & "Agent.xls"""

Private Sub Command0_Click()
On Error GoTo Err_Command0_Click
Dim stAppName As String
stAppName = "Excel.exe N:\OPS\COMMON\OpsResearch\Contact Center\DI CCL Reporting dB\Apps by Agent.xls"
Call Shell(stAppName, 1)
Exit_Command0_Click:
Exit Sub
Err_Command0_Click:
MsgBox Err.Description
Resume Exit_Command0_Click
End Sub
Heres the mess I made out of it:
stAppName = "Excel.exe N:\OPS\COMMON\OpsResearch\Contact" & Chr(32) & "Center\DI" & Chr(32) & "CCL" & Chr(32) & "Reporting" & Chr(32) & "dB\Apps" & Chr(32) & "by" & Chr(32) & "Agent.xls"""
