Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Manipulating a spreadsheet opened in IE using VBA
Any clues how to do programmatically copy data from an Excel file that
is being viewed in IE? Background: I'm using Excel VBA and the internetexplorer.application object to programmatically retrieve a URL that is actually an Excel file, e.g.: Set ie = CreateObject("internetexplorer.application") ie.navigate "http://whatever.com/?format=EXCEL" My goal is to copy this data into another Excel file. The problem is that even though this Excel file opens in IE, I can't copy the data using ie.document.execCommand "SelectAll" and .execCommand "copy". I also tried copying the data using the ActiveWorkbook object, but this doesn't work either--ActiveWorkbook apparently only picks up workbooks that are not open in IE. Thanks, David |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Increment Value By 1 Each Time Spreadsheet is Opened | Excel Discussion (Misc queries) | |||
how do i count everytime a spreadsheet is opened | Excel Discussion (Misc queries) | |||
EDate Unrecognized When Spreadsheet Opened Again | Excel Worksheet Functions | |||
Shared spreadsheet changes color when opened ny another user. Why | Excel Worksheet Functions | |||
Link not updated everytime spreadsheet opened | Excel Worksheet Functions |