Click here to Skip to main content
15,891,674 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
Hi,

We have one site which has export link on our webpage. When we click on the export it gives us an excel file with all the data on the page.
Can you please let me know if its possible to get the excel link in vba?
I tried to get the link from "View source" of my webpage. But i found that it holds some
Now i need to check how this id, i can use in my vba code to directly export my excel file when i run my vba code.

Currently i have just written the vba code to navigate through the website url.

Thanks!
Posted
Comments
ZurdoDev 8-Feb-13 10:32am    
There may not be a link. When I generate Excel files I write them directly to the Response object so there is no link. You may need to check with whoever built the site.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900