noreendeasy
New Member
- Joined
- Jul 16, 2014
- Messages
- 32
Hi there,
I was wondering how to go about downloading an excel file from an IE Link (it's an inside lan link which only works on site so won't be able to share that with you).
I have pasted the link into the file so all the macro has to do is click the link and it will take you there.
I have tried recording a macro but it doesn't work, here is the macro:
I was wondering how to go about downloading an excel file from an IE Link (it's an inside lan link which only works on site so won't be able to share that with you).
I have pasted the link into the file so all the macro has to do is click the link and it will take you there.
I have tried recording a macro but it doesn't work, here is the macro:
<CODE> Sub FA_Download_Funds()
'
' FA_Download_Funds Macro
'
'
Range("A1").Select
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
Windows("Download Funds.xlsx").Activate
End Sub
</CODE>
When I run this code, nothing happens it just takes me to the link.
I would like the macro to download the data (I click a link on the Internet Link) to 'Export to Excel', it then downloads a 'Read Only' Copy. I would then like the macro to copy this downloaded data to my current spreadsheet where the macro is.
Is this possible?
Thanks in advance of any help
'
' FA_Download_Funds Macro
'
'
Range("A1").Select
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
Windows("Download Funds.xlsx").Activate
End Sub
</CODE>
When I run this code, nothing happens it just takes me to the link.
I would like the macro to download the data (I click a link on the Internet Link) to 'Export to Excel', it then downloads a 'Read Only' Copy. I would then like the macro to copy this downloaded data to my current spreadsheet where the macro is.
Is this possible?
Thanks in advance of any help