Skip to main content

All Questions

38 questions with no upvoted or accepted answers
2 votes
0 answers
196 views

How to add elements revealed by click action to elements list in Excel VBA for an html web form

I'm trying to set up an Excel form that auto-fills an HTML web form. I've figured out how to use VBA to get the elements and cycle through them to add values. My issue is with a text field that is ...
gramzad's user avatar
  • 21
2 votes
1 answer
2k views

IE Automation - Excel VBA ... Running Into Errors After Loading Website

I have programmed VBA to interact with IE rather extensively and have started to do so again, but am coming across a weird phenomenon that I cannot seem to solve with all the research I've done. As ...
Scott Holtzman's user avatar
2 votes
0 answers
157 views

form submitting with onLoad input values instead of user inputted values when automated with VBA

Main Issue: When I submit a form using vba, the form's inputs' values change unexpectedly. I'm looking to see if there's an issue I don't know of with document.forms().submit in vba that might be ...
Kevin Dolan's user avatar
1 vote
1 answer
161 views

Fill in the website form with drop-down menu with VBA

Writing the following VBA macro in Excel: Sub compile() Dim IE As Object Set IE = CreateObject("InternetExplorer.Application") IE.Navigate "www.google.it" IE.Visible = True Do While IE.Busy ...
Markus's user avatar
  • 11
1 vote
0 answers
133 views

How to enter data into an Internet Explorer website?

I am trying to enter info into an Internet Explorer 11 website form. The website/form was designed a long time ago (around 15-20 years). The website can only be accessed through Internet Explorer. I ...
learningvbahurts's user avatar
1 vote
2 answers
328 views

Error code 91 Object variable or With block variable not set

I'm trying to perform a web automation, which involves logging in and search for a particular text on my spreadsheet on to particular box on the webpage. I'm Encountering an error in the 2nd step to ...
James D Con's user avatar
1 vote
1 answer
451 views

Webpage search filter inputs not detected when apply button is pressed via Excel VBA

I'm trying to write a VBA program which will find the person holding a specific position at a specific company via LinkedIn. I've already figured out how to open the LinkedIn search window, open all ...
dav278's user avatar
  • 41
1 vote
0 answers
290 views

Excel Macro (VBA) Image upload to Internet Explorer with Open Twebst

I've successfully automatized a process with Open Twebst. (Go through some links, fill the forms and upload images..) So, it helped me to upload images to a HTML page in Internet Explorer 10. I've ...
Báthori Zoltán's user avatar
1 vote
1 answer
261 views

VBA IE11 locking in a change to a dropdown value

I'm using VBA to open a website, login, and navigate to a certain page. There is a dropdown with 8 options. I used this code to change the dropdown to the value I want, but it always reverts back ...
acvbasql's user avatar
  • 109
1 vote
1 answer
296 views

Excel VBA to change dropdown menu within a form

I tried some alternatives, but with no success, to change the combobox you can find the website code below (It looks that the problem is that the combobox is inside a form - I can't change an input ...
Skydriver's user avatar
1 vote
0 answers
423 views

Date does not display properly while export from IE

Please find below code: var sReportDate = new Date(); var sReportFormattedDate = sReportDate.toDateString() + " " + sReportDate.toLocaleTimeString() + " " + sReportDate.toString()....
Valay's user avatar
  • 1,991
0 votes
1 answer
173 views

Excel VBA IE querySelector button click

Trying to click button using IE. Due to the firm policy Selenium Basic, is banned. So using that route is not possible. getting error Object variable not set (Error 91) code till now. Global driver ...
jan benes's user avatar
0 votes
0 answers
551 views

EXCEL VBA (URLDownloadToFile) Not working Due to Site not allowing IE11

I was wondering if anyone had an idea about how to get URLtoDownloadfile to work but get it to use Microsoft Edge as opposed to IE11. The websites trying to pull PDF's from now doesn't support IE11 so ...
S123C22's user avatar
  • 11
0 votes
0 answers
255 views

Microsoft IE open dialog Box and Microsoft Edge Open Dialog Box Different in behaviour

We have ASP.Net application - User clicks on a link and system show and an open dialog box with FROM (URL) as a label - User then clicks OPEN. Excel file open in EXCEL as READ-only- Excel File Path ...
Malik's user avatar
  • 9
0 votes
0 answers
72 views

Run-time error '91': Object variable or With block variable not set (ie.Document.getElementById)

I get the error in the title above when trying to execute a VBA command to click a button on Internet Explorer 11: Const sURL As String = "MY_URL" Set ie = New InternetExplorerMedium ...
Lucas Contreras's user avatar

15 30 50 per page