Click here to Skip to main content
Rate this: bad
good
Please Sign up or sign in to vote.
See more: VBA
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 8-Feb-13 4:27am
Comments
ryanb31 at 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)

  Print Answers RSS
0 CPallini 420
1 Sergey Alexandrovich Kryukov 310
2 George Jonsson 269
3 Gihan Liyanage 255
4 OriginalGriff 245
0 OriginalGriff 4,903
1 CPallini 3,960
2 Sergey Alexandrovich Kryukov 3,474
3 George Jonsson 2,786
4 Gihan Liyanage 2,386


Advertise | Privacy | Mobile
Web04 | 2.8.140905.1 | Last Updated 8 Feb 2013
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100