internet automation

hi all, I’m trying to figure out how to have a macro bring up a website (an internal document website) locate the correct frame uncheck a box, fill in a field with a cell value (from A2) click submit, jump to the next frame within the same website and click a link. my main problem is it looks...

The code below works for selecting the checkbox when I am already logged in (in this scenario the log in screen never shows up when a new ie is created), but when I am not logged in the code works for logging me in, but then will not select the checkbox once logged in. In both scenarios I am...

hi i am trying to copy particular content from the url. The urls are posted in the "a" column of my excel sheet. i want to open these links one by one and then from each open page copy a particular text back into the excel sheet eg. have below form:- A B 1...

I am trying to get property tax values for about 200 properties. The info is publicly available on this site: http://www.hawaiipropertytax.com/Searc/GenericSearch.aspx?mode=PARID I have a list of Parcel IDs (also known as TMK Value) that identify properties in a spreadsheet. Here are just two...

Hello all, I am currently trying to write a VBA program that would download excel files from a password protected website. The first issue that I have is that the function URLDownloadToFile doesn't work as the files are protected. The second issue that I have, is that when I navigate the...

Const strURI As String = "http://www.google.com/#sclient=psy&hl=en&safe=active&source=hp&q=site:+squidoo.com+%22space saver treadmill%22&aq=f&aqi=&aql=&oq=&pbx=1&bav=on.2,or.r_gc.r_pw.&fp=d69918eb06677aa8" This code snippet deals with one single hard-coded http, but I need the code to reference...

I have to pull several Web Queries in a workbook, all come from a website that requires login before I can access the urls. Here is my code I made to login to the website through Internet Explorer: Sub connectToScantron() Dim objIE As Object Dim objCollection As Object Dim objElement...