I have been trying to follow the videos and extract data from an HTML file and I was able to do so on my system. BUT when I try to use the same code/module to extract data from the html file from my Friend's system it shows me an "error 91: object variable or with block not set" at line 2 and sometime even at line 1. Basically it is not reading the html document on a different system. The HTMLButton1  when tried in debug.print show nothing

Dim file As String
Dim IE As New SHDocVw.InternetExplorerMedium
Dim HTMLDoc As MSHTML.HTMLDocument
Dim HTMLButton1


file = "C:\temp\HTML\page1.html"

IE.Visible = False
IE.navigate file 'line 1
Do While IE.Busy = True
Loop

Set HTMLDoc = IE.Document
Set HTMLButton1 = HTMLDoc.elementFromPoint(338, 462)


array_objects(index).date = HTMLButton1.innerText 'line2


IE.Quit
Set IE = Nothing

Select all Open in new window

CURRENT SCENARIO:
I am able to print both colour and B&W, but when I choose a print option
For Email, it automatically prints colour, unless I do a few more clicks to set to B&W.

For PPT, there is a drop-down option to choose colour or B&W, unfortunately if I dun click on it to choose B&W, it defaults to colour.


WORD Doc print, as a user I need to click on Printer Properties, in order to get to colour options to choose B&W.

IE, ctrl + Print as a user need to click on Printer Properties, in order to get to colour options to choose B&W.

May I suggest that for those staff who have been given rights to print both colour and B&W…
1.      can IOE set their print default to B&W AND
2.      if they need to print colour, these staff can by themselves choose the colour print via the option.

20,000 Users and can configure using GPO

Customer is saying that she has to keep entering in user password for her word press site every time ...

Hello everybody.

I'm dealing with a process of grasping datas from the web and copying them in an Excel sheet: it is a loop that inserts a code in a field for thousands of times, and then it imports the results.
It works quite well, processing without errors for hours.

for each cell in range xxx

IE.document.getElementById("Code").Value = cell
IE.document.getElementById("Search").Click

                With IE
                    Do While .Busy: DoEvents: Loop    'Attesa not busy
                    Do While .readystate <> 4: DoEvents: Loop 'Attesa documento
                End With

                myStart = Timer
                Do  
                    DoEvents
                    If Timer > myStart + 1 Or Timer < myStart Then Exit Do
                Loop

                Application.Wait (Now + TimeValue("0:00:20")) 

Dim tables, table, trs, tr, tds, td, R, c
Set tables = IE.document.getElementsByTagName("table")
For R = 0 To tables.Length - 1
Next R
    
Set table = IE.document.getElementsByTagName("table")(3)
Set trs = table.getElementsByTagName("tr")

For R = 0 To trs.Length - 1
Set tds = trs(R).getElementsByTagName("td")
If tds.Length = 0 Then Set tds = trs(R).getElementsByTagName("th")
For c = 0 To tds.Length - 1
ThisWorkbook.Worksheets("Output").Range("A1").Offset(R, c).Value = tds(c).innerText
Next c
Next R

'.....

IE.document.getElementById("reset").Click   'reset search field

next cell

Select all Open in new window

Unfortunately, sometimes an error occours:

"Runtime Error 91: Object variable or with block variable not set"
   
in the line

ThisWorkbook.Worksheets("Output").Range("A1").Offset(R, c).Value = tds(c).innerText

Select all Open in new window

Now, I think it could be a timing problem (maybe sometimes the page is not fully loaded).
Actually, at the beginning of the project I have fixed the wait, maybe in a messy way, but it is quite efficient.

I don't know if it is better to fix again the wait (touching a part of the code the works quite well), or to insert an instruction that could allow the cycle going on despite the error (perhaps On Error Resume Next ?).

I use IE9 and XLS 2007.

Thank you in advance for your support.

On Windows 10 computers I'm able to map network drives to user's Box.com accounts by mapping the network drives to the "https://dav.box.com/dav" location and then having the users type in their Box.com usernames (which are their corporate email addresses) and their Box.com passwords.

However, when I try to do this within Server 2016 using the exact same method within File Explorer I get the error message shown in the screenshot.

What setting(s) do I need to change so that I will be able to access and map Box.com accounts as mapped network drives within File Explorer? I believe that there are things that need to be changed within Internet Explorer and possibly the group policy settings but I'm not sure of exactly which settings need to be changed.

Hello experts,
 I have created a browser in visual c#, the simplest following the examples over the internet.
but I keep getting this message: " An error has occurred in the script of this page...
object does not support property or method 'aDDEventListener' "

but on main browsers like IE and chrome, this error message does not appear.

NOw I have already tried the following three methods to no effect:

Method 1:
1.      Click Start, and then click Run.
2.      In the Open box, type Regsvr32 urlmon.dll, and then click OK.
3.      When prompted with the DllRegisterServer in the urlmon.dll succeeded message, click OK.

Method 2:
1.      Open the Java Virtual Machine. To do so, visit the following Java Website: http://www.java.com/en
Please Note: Since the website is not hosted by Microsoft, the link may change without notice. Microsoft does not guarantee the accuracy of this information.
2.      Close all instances of Internet Explorer.
3.      Click Start, click Control Panel, and then double-click Internet Options.
4.      Click the Advanced tab.
5.      Under Browsing, click to clear the Enable third-party browser extensions (requires a restart) check box.
6.      Restart Internet Explorer.

Method 3:
1.      Open Internet Explorer.
2.      Click Tools, and click Internet Options.
3.      Click the Advanced tab.
4.      Under Browsing, click to select the Disable Script Debugging checkbox.
5.      Click OK to close all windows, and then restart …

We are having a problem getting IE Proxy settings to apply to Win 7 boxes.
We configured the GPO per https://blogs.msdn.microsoft.com/askie/2015/10/12/how-to-configure-proxy-settings-for-ie10-and-ie11-as-iem-is-not-available/
But when you go into RSOP on the Win 7 box, it's not there. Does this setting not exist on Win 7, if that is the case, what policy can we set on our 2012 DC's that will apply to the win 7 boxes?

We have several users who have reported that when attempting to connect to our VPN using Palo Alto's GlobalProtect, they get a white screen that only says "PageoK" in their browser when they try to browse to one of our internal-only web applications.   This application runs on an internal Apache server on SLES - nothing in the cloud.    The index page is a basically just a meta refresh to the main application page.    If the user who receives "Pageok" clears their browser cache, the web app works fine.    What strikes me odd is that users have seen this exact error in both IE and Firefox.    We haven't yet been able to reproduce it, but the only guess I have is that possibly users are launching their browser to the website before GlobalProtect has finished connecting, but I can't say for sure.

The thing I really need to understand is, where does the "Pageok" come from?   What would it likely be receiving from a web server in order to send that message to the client?    I figure the client MUST be getting some sort of response from a web server for it to provide that message above others.  

As far as I know, DNS is good here (certainly at least for that website) and this only became a problem recently.   I could just use more insight on exactly what "Pageok" really means in technical terms in order to understand and possibly report the problem.  

EDIT:  From reading things online, I'm wondering if "Pageok" is a Wordpress error specifically.   Does anyone know if …

I am maintaining an old, old classic ASP site - there is a form which includes the following tag around the "submit" image:

<a href="javascript:ValidateMakeForm();" onMouseOver="msover(1); return true" onMouseOut="msout(1)">

The function is defined on the page like below - basically sets the form action and submits the form.

<script language="javascript">
function ValidateMakeForm()
{
	if (document.forms['searchmake'].category_id.selectedIndex == 0)
	{	
		alert("You must select a make.");
		document.forms['searchmake'].category_id.focus();
		return;
	}
	document.forms['searchmake'].action = document.forms['searchmake'].category_id.value;
	document.forms['searchmake'].submit();
}
</script>

Select all Open in new window

IE 11 is throwing an error 'ValidateMakeForm' is undefined.   Everything works in Chrome, Firefox and Edge and even in IE 11 when viewed in Compatibility Mode.

I have a lightning component on the click of that at UI level, which my user  operates in chrome.Can I redirect from  Chrome to IE(explorer) -instead of a new tab in chrome to New tab in IE- on a click in UI?

I'm having an issue when users print an email from OWA in Citrix (using IE11), they are getting an APPCRASH error.  The job will still print, but then it closes their OWA window and reloads.  It's more of an annoyance, but it's happening to multiple users.