Help with path containing spaces

[Shawn12]

I am trying to open a workbook with a command button 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.

Heres the actual path: N:\OPS\COMMON\OpsResearch\Contact Center\DI CCL Reporting dB\Apps by Agent.xls

Heres the mess I made out of it:
stAppName = "Excel.exe N:\OPS\COMMON\OpsResearch\Contact" & Chr(34) & "Center\DI" & Chr(34) & "CCL" & Chr(34) & "Reporting" & Chr(34) & "dB\Apps" & Chr(34) & "by" & Chr(34) & "Agent.xls

 

[Shawn12]

OOPS! That is supposed to look like this:

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

 

[SkipVought]

Hi,

Why won't this work?

sFile = "N:\OPS\COMMON\OpsResearch\Contact Center\DI CCL Reporting dB\Apps by Agent.xls"
'...
workbooks.open sFile

Skip,
[sub]
[red][/red]
[/sub]

 

[phish20002003]

Or this,

ChDir "N:\OPS"
    Workbooks.Open Filename:="N:\OPS\COMMON\OpsResearch\Contact Center\DI CCL Reporting dB\Apps by Agent.xls"

-Phish
"Why do you need to think? Can't we just sit and go budumbudumbudum with our lips for a bit?" - Mostly Harmless

 

[Shawn12]

Like this?

Private Sub Command2_Click()
On Error GoTo Err_Command2_Click

Dim stAppName As String
Dim sFile as String

stAppName = "Excel.exe"
Call Shell(stAppName, 1)

sFile = "N:\OPS\COMMON\OpsResearch\Contact Center\DI CCL Reporting dB\Apps by Agent.xls"

Workbooks.Open sFile



Exit_Command2_Click:
Exit Sub

Err_Command2_Click:
MsgBox Err.Description
Resume Exit_Command2_Click

End Sub

This just seems to error.

 

[SkipVought]

What application are you running this code in?

Skip,
[sub]
[red][/red]
[/sub]

 

[SkipVought]

Also, what's the ERROR message?

Manually open the workbook.

Activate the WEB toolbar

COPY the Path & Filename and COMPARE to the string that you posted.

Chances are they are NOT the same.

Skip,
[sub]
[red][/red]
[/sub]

 

[SkipVought]

Phish,

directory commands do not affect the Open method as posted.

Skip,
[sub]
[red][/red]
[/sub]

 

[Shawn12]

I am using a Command Button on an Access Form to try and open this file. Try being the key word..Excel opens fine then it tells me "Object Required".

 

[PHV]

And what about this ?
stAppName = "Excel.exe ""N:\OPS\COMMON\OpsResearch\Contact Center\DI CCL Reporting dB\Apps by Agent.xls"""

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Shawn12]

Thx PHV...see I always try to do stuff the hard way. I hate quotations..