ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Opening files... (https://www.excelbanter.com/excel-programming/305934-opening-files.html)

jd

Opening files...
 
I need to open an hta file using visual basic. Can't figure it out.

Please help!

Tom Ogilvy

Opening files...
 
I don't know what an hta file is, but it isn't listed as a supported file.

--
Regards,
Tom Ogilvy

"JD" wrote in message
...
I need to open an hta file using visual basic. Can't figure it out.

Please help!




Steve Yandl[_3_]

Opening files...
 
From the VBE window, go to Tools References and set a reference to the
"Windows Script Host Object Model" Something like the following should
launch your hta file:

Sub RunHTAfile()
Dim wsh As Object
Set wsh = CreateObject("WScript.Shell")
wsh.Run "C:\test\Page1.hta"
End Sub


Steve


"JD" wrote in message
...
I need to open an hta file using visual basic. Can't figure it out.

Please help!




Steve Yandl[_3_]

Opening files...
 
Tom,

An hta file is essentially an html file that gets run by mshta.exe rather
than Internet Explorer or other browser. There are a few extra features of
hta files not found in standard html but a major advantage (or risk) is that
the page can run scripts and controls without the security restrictions
imposed by the browser based on the user's security settings.

Steve


"Tom Ogilvy" wrote in message
...
I don't know what an hta file is, but it isn't listed as a supported file.

--
Regards,
Tom Ogilvy

"JD" wrote in message
...
I need to open an hta file using visual basic. Can't figure it out.

Please help!







All times are GMT +1. The time now is 02:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com