Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using START, CALL etc commands in Shell gives me error "Run TimeError 53; File Not Found".
My Code is like
Sub test() FName = "D:\ARKQ.html" Shell "start " & FName End Sub But when I run this code, it gives me File Not Found Error. Please help me with this error. The same happens with "call" command also. even if I simply run the code: Shell "start" it shows the same error, so I assume I have to give the full path of the program "start" ?? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using START, CALL etc commands in Shell gives me error "Run Time Error 53; File Not Found".
Something like this should work:
Sub test() Dim strFile As String strFile = "D:\ARKQ.html" Shell "C:\Program Files\Internet Explorer\IEXPLORE.EXE " & """" & strFile & """", 1 End Sub RBS "Riyas Majeed" wrote in message ... My Code is like Sub test() FName = "D:\ARKQ.html" Shell "start " & FName End Sub But when I run this code, it gives me File Not Found Error. Please help me with this error. The same happens with "call" command also. even if I simply run the code: Shell "start" it shows the same error, so I assume I have to give the full path of the program "start" ?? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using START, CALL etc commands in Shell gives me error "Run TimeError 53; File Not Found".
Hi, thanks a lot for replying..
but doing as you suggested, opens a NEW browser window each time my code runs.. I want to open the html file in the same browser window, in a new tab may be.. can you help me with that? can your code be modified to fit the purpose.. In the cmd "start" command works perfectly..but i cant get it working in excel :-| |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using START, CALL etc commands in Shell gives me error "Run Time Error 53; File Not Found".
I am sure it is possible, but have no ready made code at
hand and will need to Google this. Normally you would use GetObject etc., but not sure that will work with IExplorer. You probably will need a Windows API. RBS "Riyas Majeed" wrote in message ... Hi, thanks a lot for replying.. but doing as you suggested, opens a NEW browser window each time my code runs.. I want to open the html file in the same browser window, in a new tab may be.. can you help me with that? can your code be modified to fit the purpose.. In the cmd "start" command works perfectly..but i cant get it working in excel :-| |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using START, CALL etc commands in Shell gives me error "Run Time Error 53; File Not Found".
This webpage seems to have the information to sort this out:
http://vba-corner.livejournal.com/4623.html RBS "Riyas Majeed" wrote in message ... Hi, thanks a lot for replying.. but doing as you suggested, opens a NEW browser window each time my code runs.. I want to open the html file in the same browser window, in a new tab may be.. can you help me with that? can your code be modified to fit the purpose.. In the cmd "start" command works perfectly..but i cant get it working in excel :-| |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VBA.Interaction.Shell ("msg.exe") = Run-time error '53': File Not found | Excel Programming | |||
Getting a "File Not Found" error when trying to show userform | Excel Programming | |||
Need Help with Call Shell("cmd /K netstat") Function!!! | Excel Programming | |||
Getting "compile error" "method or data member not found" on reinstall | Excel Programming | |||
"file not found" error message when launching source file | Excel Programming |