Opening XLS book with spaces in the title

[paulquinlan100]

Hi

I'm tring to open various xl books using

Attach = "" & cboAttachments.Value & ""

stAppName = "C:\Program Files\Microsoft Office\Office\EXCEL.EXE " +
Attach
Call Shell(stAppName, 1)

However, some of the sheets have spaces in the title eg "High Level
Assessment.xls"

So instead of trying to open this, it attempts to find 3 xl books
called:

"High.xls"
"Level.xls"
"Assessment.xls"

Any ideas how to get round this?
Thanks for any suggestions
Paul

[Cyberwolf]

Have you tried something like this?

Dim xlApp As New Excel.Application
Dim xlWkb As Excel.Workbook

Set xlApp = New Excel.Application
Set xlWkb = xlApp.Workbooks.Open("High Level Assessment.xls", 0)
xlApp.Visible = True
xlWkb.Windows(1).Visible = True

This opens a new instance of Excel with the file named and sets the
excel application to visible.

HTH
Cyberwolf

pa************@hotmail.com wrote:

Hi

I'm tring to open various xl books using

Attach = "" & cboAttachments.Value & ""

stAppName = "C:\Program Files\Microsoft Office\Office\EXCEL.EXE " +
Attach
Call Shell(stAppName, 1)

However, some of the sheets have spaces in the title eg "High Level
Assessment.xls"

So instead of trying to open this, it attempts to find 3 xl books
called:

"High.xls"
"Level.xls"
"Assessment.xls"

Any ideas how to get round this?
Thanks for any suggestions
Paul

[Gord]

>Any ideas how to get round this?

The statement

Attach = "" & cboAttachments.Value & ""

simply encloses cboAttachments.Value in empty strings, and therefore is
the same as

Attach = cboAttachments.Value

I think you were trying to enclose cboAttachments.Value in
double-quotes, which would be

Attach = """" & cboAttachments.Value & """"

pa************@hotmail.com wrote:

Hi

I'm tring to open various xl books using

Attach = "" & cboAttachments.Value & ""

stAppName = "C:\Program Files\Microsoft Office\Office\EXCEL.EXE " +
Attach
Call Shell(stAppName, 1)

However, some of the sheets have spaces in the title eg "High Level
Assessment.xls"

So instead of trying to open this, it attempts to find 3 xl books
called:

"High.xls"
"Level.xls"
"Assessment.xls"

Any ideas how to get round this?
Thanks for any suggestions
Paul