Hi
I am trying to create a macro to open an instance of IE and browse to a URL
Then need to search for a hypertext link named "Download in csv" within the page i've navigated to.
This hypertext link URL is dynamic (changes) hence I cant link directly to it.
The hypertext link function is to download a CSV spreadsheet.
Clicking on the hypertext link brings up the SaveAS dialog box. I to save the CSV file with a certain format in the specified location.
Can someone please help me with code to open the web page, click on the specific hypertext link and download the file.
The web page am looking for is "https://www.nseindia.com/live_market/dynaContent/live_watch/equities_stock_watch.htm"
Cheers
I am trying to create a macro to open an instance of IE and browse to a URL
Then need to search for a hypertext link named "Download in csv" within the page i've navigated to.
This hypertext link URL is dynamic (changes) hence I cant link directly to it.
The hypertext link function is to download a CSV spreadsheet.
Clicking on the hypertext link brings up the SaveAS dialog box. I to save the CSV file with a certain format in the specified location.
Can someone please help me with code to open the web page, click on the specific hypertext link and download the file.
The web page am looking for is "https://www.nseindia.com/live_market/dynaContent/live_watch/equities_stock_watch.htm"
Cheers
