Code to Open internet link

[samshut]

This shouldn't be hard but I can't figure it out. How can I open a file from a link so that I can manipulate and copy data to another workbook. I also need the code to close it again automatically. Please include code. Thanks for the help in advance.

Sam

This shouldn't be hard but I can't figure it out. How can I open a file (internet link) so that I can manipulate and copy data to another workbook from a drop down menu. I also need the code to close it again automatically. Please include code. Thanks for the help in advance.

Sam

[MSP77079]

If the URL refers to an Excel workbook, then this should do what you need:

Please Login or Register  to view this content.