ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Prevent Excel from going online when opening html file (https://www.excelbanter.com/excel-programming/359675-prevent-excel-going-online-when-opening-html-file.html)

G.Mueller

Prevent Excel from going online when opening html file
 
Hi,

I' m opening several html files using excel.
After downloading them using Wget, I do:

....
objExcelApp.DisplayAlerts = False
Set objExcelSheet = GetObject(strPath)
....

Problem is, that the html files contain references to images and flash which
are then downloaded at line: Set objExcelSheet = GetObject(strPath). This
takes too long if I do it several times programmically.

I want to tell Excel before the Set objExcelSheet = GetObject(strPath) line
to stay offline and not to connect to the internet.
How?

Thanks!




All times are GMT +1. The time now is 04:15 PM.

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