Hi there, I need help on the below code: the way this should work is I will list shipment #'s on the excel sheet1 and by running the macro it open the web browser go to the website that I list, then it goes to a particular field and add 5%, this macro is currently working but it only works on...
I'm having trouble to Submit a form via VBA.
The problem is that the data I enter is correct but once I click the button I get an error. It says:
"No data found" and it errased the ID number which now says "Required".
When I do this manually everything works fine. Any clues why this is? I...
I have VBA that pulls datas from cell, inputs into field on website and submits. I then extract data back from website to excel sheet. Right now I'm using a specific cell.
Set HTMLInput = HTMLDoc.getElementById("ssn")
HTMLInput.Value = Sheets(1).Cells(2, 6)
Set HTMLInput =...
trying to learn something new, am follow some stuff on your tube but getting a run time error 13, not sure what.
Sub BrowseToSite()
Dim IE As New SHDocVw.InternetExplorer
Dim HTMLDoc As MSHTML.HTMLDocument
Dim HTMLInput As MSHTML.IHTMLElement
Dim HTMLAs As...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.