Hello. I'm trying to write VBA code (in Excel) to browse web pages and save them to files.

I already have VBA code to automate Internet Explorer, navigate to web pages, and extract the text of the pages. But now I want to save the entire page, including images. In other words, I'd like to do the equivalent of manually printing the web page to PDF, saving it as an MHTML file, saving it as "Web page, Complete" (with the images in a separate folder), or possibly saving the whole web page as one image file.

I've tried...

1. Initiating a print job in IE, having made "Print to PDF" the default. I've tried various variations on this statement:

 IE.ExecWB OLECMDID_PRINT, OLECMDEXECOPT_DONTPROMPTUSER

The problem is that it opens a Print dialog box followed by a Save File dialog box, and the only way I can find to interact with these boxes is to use SendKeys. But that's unrelaible. I don't know how long to wait for the dialog box to appear before sending the keys.

2. Creating an MHTML file using CDO, with this statement:

cdoMsg.CreateMHTMLBody url, cdoSuppressNone

This works, but it produces a very poorly rendered version of the web page.

Can you suggest any other options, please? I'd be open to using method #1 above, if I could detect when the dialog boxes are ready to receive keys with SendKeys. Alternatively, perhaps I should use a different technology. I'm only really familiar with VBA, but I understand that there are VBA wrappers available for WebKit and…

Please only respond to this question if you have decent experience with internet explorer automation. If you lack that expertise, please wait a few days before chiming in.

I am using vba internetexplorer object to download several sets of data from a website.'

I using Wayt which is an old and well tested subroutine that waits while oie.Busy Or oie.ReadyState <> 4 .

This website seem weird: After pulling the first set, ie.readystate gets stuck at 3 (READYSTATE_INTERACTIVE) which messes up Wayt. As a result Wayt always wait for 20 seconds before exiting
Also, I have often noticed that many of my old programs seem slower that I expected. I think they all might suffer similar problems.

So, I am thinking of changing Wayt to wait while oie.busy or oie.document.readystate <> "complete" or oie.readystate < 3

Or I could add another optional parameter like this, but I am not crazy about that idea.
Has any expert seen similar problems? Do you have any opinions?

Sub wayt(oie, Optional waitseconds As Long = 20, Optional allow3 As Boolean)
 '  Debug.Print "1" & TypeName(oie)       WebBrowser2
  ' Debug.Print "1" & TypeName(oie.Busy)  Boolean
   'Debug.Print "1" & TypeName(oie.ReadyState)  Long
   Dim i As Long
If allow3 Then
    Do While i < waitseconds * 10 And (oie.Busy Or (oie.ReadyState < 3) Or (oie.Document.readysate <> "complete"))
        Sleep 200:
        i = i + 1
    Loop
Else
    Do While i < waitseconds * 10 And (oie.Busy Or 

Select all Open in new window

…

I have a client who is trying to use the merchant center in quickbooks premier 2018. Quickbooks uses the I.E. browser within it's program so if there are issues with I.E. then there will be issues inside of quickbooks where it is accessing the Internet. There are a few issues with Internet Explorer that I believe are keeping it from working correctly. I think once we resolve the I.E. issues, the rest will take care of itself. The system was just upgraded from windows 7 pro to windows 10 pro version 1903. Internet explorer is exhibiting some strange issues. On a simple page like msn.com,  graphics do not show. A black box (w/o a red x) shows in place of the correct graphic. Accessing the merchant center via I.E. will initially display page info but once you click on one of the options, it moves to the next screen and generates a black box that would be where the detailed information would be. I have attached a copy of how it looks on a working version of I.E. (my computer, windows 10 pro 1803, i.E. 11 vs the non working verson on windows 10 pro 1903, i.E. 11.

I have removed I.E. on that computer via the windows features and reinstalled it. I have done a reset on I.E. and the advanced option on the advanced tab on I.E. settings. I have checked the media settings and it is set to show images. During the uninstall, I also deleted any I.E. info from the appdata folder for any users.

I have tried it both clean (to check websites like msn) and with the program requirements …

IE 11 , why is the left Nav button active even when opening a PDF in the browser.

Installed
VMWare Client Integration Plugin v6.2 (For Internet Explorer 11 and Firefox Ver. 66)
and
VMWare Client Integration Pluginv6.0 (For Google Chrome Version 73.0.3683.103 (Official Build) (64-bit))
on a
Windows 7 Enterprise SP1 (64-bit) PC.

What Works
- ISO upload to VMWare vCloud Director Catalog works using Internet Explorer 11 only (does not work with Chrome and Firefox) on the PC.

Workaround in place - Console Content Access works for all the same VMs via a Windows Server 2008 R2 Standard Server from within the same environment (setup by someone else not contactable)
(This Server will be decommissioned soon - so need the console working on the PC before the server gets decommissioned)

What Does not work
– VMWare vCloud Director WebMKSConsole Content Access – for any VMs – using any Web Browser (IE, Firefox or Chrome)

Get the following screen – doesn’t matter whether the URL is DNS Name or via IP Address.

Troubleshooting done
-      Added DNS Name to local host file on PC (which made the ISO upload work)
-      Reinstalled VMWare Client Integration Plugin v6.2 , v6.0 and v5.6 after uninstalling, reinstalling and rebooting a number of times.
-      Added Firewall Exclusions on Local PC for all profiles (Domain, Private and Public)
-      Installed the Valid Certificate for FQDN in Automatically Selected Store and the Trusted Root Certificate Store.
-      Tried Troubleshooting described on various VMWare Website and Forums – some were unclear.
-      VMWare …

Throughout the day a good portion of my users experiences internet dropouts and waiting on proxy tunnel when they are on a browser. I have inherited just recently our proxy server. I don't know how it was built or for that matter how it works. The user who did know has left the company and I'm not sure where to start. Any help would be brilliant?

Thanks

I'm trying to use Access VBA to download files from the internet using a url. I need to send a click to the Save AS link on "What Do You Want To Do" dialog popup (see attached) . The file needs to be saved to a folder. I'm using IE 11. Thanks
Capture.JPG

var nestedtablesettings = {
    "iDisplayLength": 20,
    "bLengthChange": false,
    "bFilter": true,
    "bSort": true,
    "bInfo": false,
    "drawCallback" : function() {
        var appendDownloadLink = $("table table td .dataTables_filter");
        appendDownloadLink.each(function(i, e) {
            var label = $('label', e);
            $(e).html('<a class="export-circuits" href >Export circuits</a>').append(label);

            $(".export-circuits").on("click", function(e){
                circuit = $(this).closest('tr').prev('tr').children('td').eq(1).text();
                hpath = "exportCircuits?organisationID="+getbusinessID+"&interfaceName="+circuit;
                $(this).attr("href", hpath);
            });
        });
    }
};

Select all Open in new window

I am trying to add an export link on the nested datatable.  When I try to see my result on Chrome and Firefox, it is working perfectly.

The result on chrome and Firefox

<div id="nested-datatable-covertab_0_row_0_tab_0_row_0_tab_0_filter" class="dataTables_filter"><a class="export-circuits" href="">Export circuits</a><label>Search:<input type="search" class="" placeholder="" aria-controls="nested-datatable-covertab_0_row_0_tab_0_row_0_tab_0"></label></div>

Select all Open in new window

On the IE, it removed the data from label elements.

<div id="nested-datatable-covertab_0_row_0_tab_0_row_0_tab_0_filter" class="dataTables_filter"><a class="export-circuits" href="">Export circuits</a>
<label></label>
</div>

Select all Open in new window

From my research, IE has got some issue with jquery append method.

Any helps would be highly appreciated.

Hi All,

I tried to update the Windows 2008r2 (SP1) IE 8 to IE11. I have installed all the pre-requisite, but it kept on failing.


Is there any solution for this? I attach the IE11 install log.


Thank you,


Iwan
IE11_main.log

Hello Team

I am currently facing an issue with the site to zone assignmet list in combination with a security warning when executing a shortcut that resides on a dfs share.


path: \\domain.local\...\Applikation.lnk

The site to zone assignment list has been configured through gpo (user settings) and is applied correctly to its client


file://domain.local
\\domain.local
*://*.domain.local




 

After a little bit investigation it looks like the dfs path domain.local will still be recognized as a internet zone. Maybe somone has a clue why the dfs path will be recognized as an internet zone and not as a intranet zone because of the site to zone assignment list

The issue only occurs with server 2016 (same gpo applied to windows 7 clients works fine).
ADMX Files are still 2008R2 / Win7

Unfortunately the issue still persists even after applying \\domain.local with option 1 to the site assignment list (https://www.experts-exchange.com/questions/29063519/DFS-Namespace-creates-error-massage-for-users-file-outside-of-your-local-network.html or https://myworldofit.net/?p=980)

Regards

My client about to roll out a new cloud based Event Reporting system.
Unfortunately due to compatibility issues they are unable to access this via Internet Explorer, which is there default browser. Instead, users will be required to use either Chrome, Firefox or Edge.

We would like to investigate the below option of formatting a link in IE so that it opens up a Chrome browser. This would enable users to continue using our default browser whilst still being able to access this new system.

Any advise on how achive this?

https://social.msdn.microsoft.com/Forums/office/en-US/295f6ba0-82c8-4350-bb55-50ffed40530b/how-to-format-a-link-to-open-in-chrome-instead-of-ie?forum=sharepointdevelopmentprevious

We have user's who are currently experiencing issues with their browser specifically in Internet Explorer 11 with yahoo.com that display's another country other than the USA. It's currently display a Canadian URL link (Example: https://ca.yahoo.com/?p=us). Some steps that I have taken so far includes:

(1). Tried the 'https://us.yahoo.com/' link on the users workstation.

(2). Enabled the Location Settings on the workstation:
1.Press Windows + R, type “control.exe” (without quotes), push Enter.
2.Control Panel will open.
3.Change the view by (from windows explorer) to large icons or small icons.
4.Click on “Location Settings”.
5.Uncheck, “Turn on Windows Location Platform”.
6.Check on, “Help improve Microsoft Location Services”.
7.Click on Apply.

(3). Turn Off Location Sharing in Internet Explorer
1.Open Modern Internet Explorer 11 (IE11) from Start Screen.
2.While in modern IE11, Open Charms bar and click on Settings.
3.Click on Privacy.
4.Ensure that, “Location Option” is on.

Any suggestions or recommendations on how to prevent this settings from occurring on users workstations is great appreciated.

Many Thanks,

Dear all,

One of my colleagues says that he used to see the recent open pages once he open the Internet explorer as below, but suddenly stopped.

He wants to see the pages in squares as below. I went through all options in the view and tools with no success.

Thank you in advance.