Pulling off Data from website into excel

**Lisa4legin** · 04-28-2012, 02:19 PM

I am trying to resolve this issue with Pulling data of a website . I can get into the site with VBA code
however I need to access a tab called "Client" which needs to be selected and then on the page add the value from excel sheet I am searching for into an input box named "referenceNo" and then download the result back into Excel whatever the Option value is either "completed or other"

I am adding the script from the soource page.

HTML Code:

**venkat1926** · 04-29-2012, 02:56 AM

what is the web page address then you have to use data-import data(something like this depending upon the version) -new web query

if you give the webplage address a macro can be attempted.

**Lisa4legin** · 04-29-2012, 07:34 AM

Hi,
its just that this is a Secure (private)Web site and will require a user name and Pass to enter .So I am not sure if that can help--however I have provided the page address for the start page. Let me know if there is something else that can be done? https://tec.cleardmanager.com/Login....2fDefault.aspx

**Lisa4legin** · 04-30-2012, 05:06 PM

Like I mentioned I have been able to get through the Site Login screen with the help of the code from JP . but I am still searching for a way to pull a value from the excel sheet and look it up on the website automatically.

HTML Code:

Works good upto here, but cant get the code to work below

Please Login or Register  to view this content.

**abousetta** · 04-30-2012, 05:30 PM

Could you save the page you want to automate as an mhtm page and upload. Also let us know which field you want to input and where in the Excel workbook this information can be found.

**Lisa4legin** · 05-01-2012, 03:07 PM

Hi

I have attached the Excel file and the .MHT(update.zip file attached) of the webpage, The excel file will list the REFERENCE # and that needs to be inputted into the reference input on the webpage. once the display button is clicked the information is provided (if the order is completed or not along with the delivery date) that needs to be put back to spreadsheet into the columns provided.