Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
insert a web page in excelworkbook
I am unable to download a web page(which is in excel format) into my workbook
as as worksheet. Whenever I am downloading it is being saved as seperate excel file in D:/MyDocuments.Wheras My workbook also in D:/MyDocuments.Please guide me |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
insert a web page in excelworkbook
Here are two things you could try:
1. Copy and Paste the table from the website directly to your table. 2. In Excel, go to Data -Import external data - New web query This will open a web browser with your homepage on it. Go to the website with the table. There should be a little yellow box beside the table you want. click that to highlight the table, then click Import. This should send the data directly to your worksheet, although the formatting and data placement might be wierd. The cool thing about this method is, the worksheet will continually update itself from the linked web table. -- Anne Murray "TUNGANA KURMA RAJU" wrote: I am unable to download a web page(which is in excel format) into my workbook as as worksheet. Whenever I am downloading it is being saved as seperate excel file in D:/MyDocuments.Wheras My workbook also in D:/MyDocuments.Please guide me |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem with Page Numbering | Excel Discussion (Misc queries) | |||
Page Numbers | Excel Discussion (Misc queries) | |||
Automatically insert page break every 6 rows in excel doc | Excel Discussion (Misc queries) | |||
Challenging Charting | Charts and Charting in Excel | |||
insert a page number into a cell? | Excel Worksheet Functions |