View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Gordon Cashmore[_3_] Gordon Cashmore[_3_] is offline
external usenet poster
 
Posts: 1
Default Office 2003 not able to run wscript??

Thanks for the help. The create object worked for me
instead of the shell command. Guess that's what happens
when a newbie tries to program.

Thanks again
-----Original Message-----
I found the same problem runnning your script from a

VBS. After some
hacking I went into the registry he

HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\comman d

and renamed the Command key to Commandx so that

the "default" command was
used. After that the file opened from the script. Not

much of a solution I
know.

An alternative from a VBS is using automation:

Dim XL
Set XL = CreateObject("Excel.Application")
XL.Workbooks.Open "c:\Book1.xls", 3
XL.Visible = True

Whether this is a viable alternative for your purposes I

don't know.

--
Jim Rech
Excel MVP


.