Opening an Excel File that has spaces in Filename

[rrenis]

Hi all, I guess this is easy but I can't get it to work

I have the following code which I need to open a speadsheet but it assumes each word of the spreadsheet name is a seperate spreadsheet and therefore tries to open 'example.xls', 'spreadsheet.xls', 'with.xls' etc...

Does anyone know what to alter in order for this to work?

$file_location = "example spreasheet with username attached - " & @username
Run("C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" & " " & $file_location & "")

Cheers,

rrenis

[sigil]

Search the forums for the ExcelCOM UDF. It has functions, such as _ExcelBookOpen, for opening Excel spreadsheets; these functions accept strings with spaces in them.

[rrenis]

Search the forums for the ExcelCOM UDF. It has functions, such as _ExcelBookOpen, for opening Excel spreadsheets; these functions accept strings with spaces in them.

Thanks for the quick response sigil

[picaxe]

Try

$file_location = "example spreasheet with username attached - " & @username
Run("f:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" & ' "' & $file_location & '"')

[rrenis]

Try

$file_location = "example spreasheet with username attached - " & @username
Run("f:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" & ' "' & $file_location & '"')

That work's great - many thanks!!!

Cheers,

rrenis