Excel and MS 8.3 filename format

Verald

New Member
Joined
Oct 16, 2009
Messages
28
Hello, I'm not sure if this the right place to ask, so if it's not, please move it accordingls, but here goes:

I am in a multi computer environment trying to run a script that will open Excel (In a WRQ enviroment, but that's not really relevant) The script opens an excel file; however language forces us to write file names in 8.3 format (shell C:\progra~1\micros~2\office11\excel.exe C:\file.xls)

The script works fine for most; however, we have a couple people where Office11 is installed under micros~3, not micros~2.

The script fails to open if I change it to shell "C:\program files\microsoft office\office11\excel.exe" C:\file.xls

Does anyone know of a way to change the 8.3 filename? Or any other fix?

Thanks for any help.
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
I would probably try to first verify the existence of the file, then open it ...
For example (Pseudocode):

Does C:\progra~1\micros~2\office11\excel.exe exist?
Yes ...
Go

No ...
Does C:\progra~1\micros~3\office11\excel.exe exist?
Yes ...
Go

No ... Stop (we can't find excel).

I wouldn't change the file names as these are possibly important for other programs in the office application environment.
 
Upvote 0

Forum statistics

Threads
1,224,508
Messages
6,179,189
Members
452,893
Latest member
denay

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
Back
Top