>
>MYFILE = "C:\MY FILE\TEST.XLS"
>lcFileName = ["] + MYFILE + ["]
>oShell = CREATEOBJECT('WScript.Shell')
>oShell.Run(lcFileName)
>
Hi Sergey,
I don't understand why he needs these extra pair of quotes ?
lcFileName = "C:\test.xls"
oShell = CREATEOBJECT('WScript.Shell')
oShell.Run(lcFileName)
Will work just fine. It could be that OP created problem at first place by
doing typo like
MYFILE = "C:\MY FILE\TEST.XLS"
lcFileName = [MFILE]
BTW Thank you very much for this answers because it answered for me
few long unanswered questions; How to open TIF file with MSOV and also how to open XPS file with XPS viewer.
Well this WScript.Shell call answers them both :)
And was so simple.
lcFileName = 'C:\test.tif'
oShell = CREATEOBJECT('WScript.Shell')
oShell.Run(lcFileName)
Works for both :)
I am guessing that running this shell call is the same as doing dbl-click
on any file which consecutively opens file with app associated with file extension.
Or I am wrong ?
>
>>
>>
>>Thank for you help, i have try your code. It is work :)
>>
>>
>>*lcFileName = ["C:\TEST.XLS"]
>>lcFileName = ["C:\MY FILE\TEST.XLS"]
>>oShell = CREATEOBJECT('WScript.Shell')
>>oShell.Run(lcFileName)
>>
>>
>>But it can't work when i put a variable as below:-
>>
>>MYFILE = "C:\MY FILE\TEST.XLS"
>>lcFileName = [MFILE]
>>oShell = CREATEOBJECT('WScript.Shell')
>>oShell.Run(lcFileName)
>>
>>I have try to use:
>>lcFileName = [&MFILE]
>>lcFileName = [(MFILE)]
>>But still can not work !!!
>>
>>Many thanks for you help