Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Howdy everybody! I've got a question about having a workbook use an external data lookup to link intself to a web page and copy several lines of information. What I need to do is create a workbook that, when a command button is clicked, opens up a web page (which is just another excel document saved as a web page, so it will be in spreadsheet format), copies specific cells from that web page, and then pastes them in the original spreadsheet. Is the syntax similar to that which would be used to open another worksheet such as(Workbooks.Open Filename:= _ "F:\Mtbfile01\worksheethere.XLS"), or do I need to be doing something entirely different?? If someone could help me out with the code, or at least point me in the right direction to find some help, that would be grand. Thank you!! -- xFiruath ------------------------------------------------------------------------ xFiruath's Profile: http://www.excelforum.com/member.php...o&userid=26528 View this thread: http://www.excelforum.com/showthread...hreadid=397985 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
copying - linking - updating - | Excel Discussion (Misc queries) | |||
linking a value from another page or tab in a formula | Excel Worksheet Functions | |||
Copying/Linking Entire Workbook | Excel Discussion (Misc queries) | |||
linking to web page | Excel Programming | |||
Linking Or Copying Filter Arrow | Excel Programming |