Spaces in path to .xls file affecting ability to open the fi

SteveC777

New Member
Joined
Oct 27, 2002
Messages
3
Can somebody please tell me what would cause the following:

A sample path to my .xls file is
C:abc 123my file.xls

When I double click this file in windows explorer, the following happens:

1. It cannot find the file named "C:abc.xls"
2. then it cannot find the file named "123my.xls"
3. then it cannot find the file named "file.xls".

It seems to be stopping on each of the spaces, both in the filename and in the path.

Any advice would be appreciated.

Thank you
Steve
 

Some videos you may like

Excel Facts

Why does 9 mean SUM in SUBTOTAL?
It is because Sum is the 9th alphabetically in Average, Count, CountA, Max, Min, Product, StDev.S, StDev.P, Sum, VAR.S, VAR.P.

Yogi Anand

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
Hi SteveC777:

Welcome to the Board!

How about trying with
C:abc 123[my file.xls] ... see if this helps.

Regards!
Yogi Anand
 

SteveC777

New Member
Joined
Oct 27, 2002
Messages
3

ADVERTISEMENT

Hi zacemmel and Yogi Anand.

Thanks Yogi Anand for your answer, but I wont get to be able to try it, because zacemmel's answer worked for me before I saw your post.

Thank you again
Steve
 

Yogi Anand

MrExcel MVP
Joined
Mar 12, 2002
Messages
11,454
Hi Steve:

Let us just thank zaccemel -- he helped solve your problem -- and that is the main thing.

Regards!
Yogi Anand
 

Watch MrExcel Video

Forum statistics

Threads
1,123,384
Messages
5,601,326
Members
414,443
Latest member
lionking15

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top