I am trying to have VBA open an instance of IE and browse to a specific
Private Sub DrawingIn_Click()
Set browser = CreateObject("InternetExpl
browser.StatusBar = False
browser.Toolbar = False
browser.Visible = True
browser.Resizable = False
browser.AddressBar = False
I got that portion to work
Now I need to search for a hypertext link named "spreadsheet" within
the page i've navigated to. The hyperlink is to download a spreadsheet.
Clicking on it brings up the SaveAS dialog box. I then need to save
the spreadsheet to a specific location.
Can someone please help me complete the code to
1) Find the Spreadsheet hyperlink
2) Click it
3) Save the target into a specified directory.