Integrating VBA with IE

[Prabhu9teen]

Hi All,

i'm looking out for some web reference which explains, how to control IE page with Vba excel.

> In my project, there will a button in IE webpage which will download the data in xls format, i need a VBA code to click or access that button from excel vba to download and save in a specified path.

Thanks for your help in advance.

Regards,
Prabhuraj

 

[Somendra Misra]

Hi Prabhuraj,

Here are some links which can give you a start with this:

http://www.excely.com/excel-vba/ie-automation.shtml

http://www.jpsoftwaretech.com/excel-vba/automate-internet-explorer/

Regards,

 

[Marc L]

Hi,

better than automating IE is downloading data by a request
like webbrowsers use …
​

 

[Prabhu9teen]

Hi All,

Great thanks for the responses! Actually my requirement is to access the below dropdown box and choose excel and then Click on the export button.

This will be a great help for me to finish my current project!

thanks for your help in advance

 

[Deepak]

hi Prabhu9teen,

Pls share me the complete url with login details if any.

 

[Marc L]

Prabhu9teen,

if you know how to use a webbrowser, find the request used by webpage,
faster and more efficient than piloting IE !

For example, if the project purpose is to load data in a worksheet,
by using a request no need to download a file !

Anyway with above references, you can start your code to pilot IE
and share with us your progress before asking for an accurate technical point …

_______________________________________________________________
Je suis Charlie
​

 

[Prabhu9teen]

Hi Deepak,

This URL is owned and maintained by the company and it impossible to share the link, also separate host details to be updated in your network to connect home network with office network if i share this URL with you, (URL will not work in home network) . Please let me know if you require any back-end script which will do for your to help me to finish this project successfully.

 

[Prabhu9teen]

Prabhu9teen,

if you know how to use a webbrowser, find the request used by webpage,
faster and more efficient than piloting IE !

For example, if the project purpose is to load data in a worksheet,
by using a request no need to download a file !

Anyway with above references, you can start your code to pilot IE
and share with us your progress before asking for an accurate technical point …

_______________________________________________________________
Je suis Charlie
​

Thanks Marc, Regarding Piloting IE.... I'm not sure how to perform this activity in IE to get the desired action using VBA. Could you please help me to have a glimpse about that?

 

[Marc L]

Without URL, no better than web tutorials like those from post #2 …​