Macro to download excel file from the URL

[Abhishekghorpade]

Hi,

I want to download the data in excel from the below link (inside the link it has 2 more steps) and save it in Birt folder “C:\Users\E5554593\Desktop\A5554593\Birt report”

Url: http://147.249.55.189/birt-viewer/
1^st step :- Click on “RealTime SLA - Role/Business Unit”
2^nd step :- Click on “BPO_DVW”

Thank you

 

[Abhishekghorpade]

Hi,

I want to download the data in excel from the below link and save it in Birt folder“C:\Users\E5554593\Desktop\A5554593\Birt report”

Url: http://147.249.55.189/birt-viewer/frameset?__report=BPO/realtime_sla_role.rptdesign
Above URL give multiple options in that it should Click on “BPO_DVW”

Thank you

 

[Abhishekghorpade]

Please someone help me on this ...

 

[Worf]

I cannot load either of the two pages you posted, can you check that?

I may try to help without actually seen the web page, but it will be far more difficult.

 

[Abhishekghorpade]

I am sorry the link wont open for you. It has restriction.. Is there anything i can help you with like screen shot or anything like that

 

[Joe4]

There are tools available that you can use to post screen images. They are listed in Section B of this link here: http://www.mrexcel.com/forum/board-a...forum-use.html.
Also, there is a Test Here forum on this board that you can use to test out these tools to make sure they are working correctly before using them in your question.

 

[Worf]

I need two screenshots:

1. From the page element you are talking about. Is it a button, a table or something else? Does the Excel file downloads when you click it? The VBA macro will automate an action that can be done manually.
2. The code associated to it. Open the page with internet explorer, right click the object and choose the inspect element option. It will look similar to the image below. I need a few rows above and below the highlighted line.

 

[Abhishekghorpade]

I am no able to attach any screen shot. All the links i section are not working for me. Is there any mail ID so that i can forward the images to mail

 

[Worf]

To add a screen shot,upload it to a hosting site and paste the link here. The image at post 7 was uploaded to Imgur.
Anyway, I am sending you a PM with my email address.

 

[Abhishekghorpade]

I am sorry i cant even see the image in post #7 . email will be only left out option. Thank you in advance for all your effort in taking this ahead