Can Excel open IE and copy the contents of a page?
Posted by Chris Rock on June 25, 2001 2:35 PM
I have data that is in a table on a webpage on our intranet. I've written a simple macro that takes the data (once copied to the clipboard) and sorts and formats it appropriately.
Can I have excel get the data from Internet Explorer so the user doesn't have to copy it to the clipboard first? All I'd need is to have the macro go to a specific URL and do a select all + copy.
Is this possible using VBA?
I am using Excel 97 and IE 5.5. I have access to Excel 2000, also if it's not possible with '97.