• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Downlaod URL Data on disk based on criteria

parth007

parth007

Member
Need VBA to do following task... Bit Urgent
One Excel sheet have URL data as attached
Need to create a button which will do below activty
1) Open URL specified which is written in cell ("B1")
2) Enter UserID, UserName & password written in cells ("B2"), ("B3"), ("B4") in the URL which is in ("A1")
3) Select certain parameters & then run the report on URL & download the data in PDF format on disk..
Note - The URL given in B1 is test.. i dont know if there is any other such testing url from where we can download data on conditions

Is it possible that above will be done on CommandButton1.click??
 

Attachments


Hi,

to save Excel data in pdf, just read VBA inner help …

To read web data, differents ways (depends on each website or webpage) :

• see QueryTable in VBA inner help.

• Automate Internet Explorer (slowest but easier than below, both need HTML knowledge).

• MSXML Object Library Routines (if you know how to use a webbrowser inspector tool) …

Many samples all over the Web !
​
 
As this is the first time i am working on Vba to Internet explorer...
Just want to know how do we know what are the exact name of the captions..
I can now open a home page of the customer through VBA code.

Below are the steps we do through mouse & keyboard
1) Click on Login or Register
2) Enter User Name
3) Enter Password
After this there are many tabs..
4) I have to Select Reports Tab then
5) Select To & From Date
6) Run Report
7) Report opens & then i save it as .pdf file
So from Step1 to Step 7 how do i do with VBA???
How do i know what is the Usrename Textbox name?
What should i consider Caption or what?? fully confused.. i am new to this:confused:
 

As it depends on the webpage itself …
A working code for a webpage should not work on another one !
Just look at webpage source code …

See tutorials and samples on the web.
​
 
:( I was able to login in to the customer URL home page through code..
But next how to proceed i am blank... seems deadend for me
 

If you know how to use a webbrowser,
you can see the needed HTML elements …

Learn with tutorials and samples from this forum and all over the Web !

Maybe it's easier for webbrowser noobs to use a tool like selenium-vba …
​
 
Unfortunatley we are not allowed to install any tool or addins.. :(
:(:(Will try looking to learn HTML elements
 
You must log in or register to reply here.
Back
Top