I think you need to show your complete code.

Tim

--
Tim Williams
Palo Alto, CA


"1tsols" wrote in message
...

NickHK Wrote:
This works fine, so spaces in the file path is not your problem:

Dim strTemp As String
strTemp = "C:\Documents and Settings\Nick\Desktop\Book5.xls"
Workbooks.Open (strTemp)

Is this on an English language OS ?

NickHK


Can you please quantifty your statement that the spaces is not my
problem?

If I open a Excel spreadsheet in any other folder that doesn't contain
spaces in the path it works fine, soon as I try and open a Excel
spreadsheet in a folder which does have spaces in the folder name /
path then it errors!

The system this is used on is Windows XP Pro ENGLISH with Office 2000
installed.

You code example is basically what I have already so there is no
difference in that aspect.


--
1tsols
------------------------------------------------------------------------
1tsols's Profile: http://www.excelforum.com/member.php...o&userid=36430
View this thread: http://www.excelforum.com/showthread...hreadid=561976