insert a web page in excelworkbook

  • Thread starter TUNGANA KURMA RAJU
  • Start date
T

TUNGANA KURMA RAJU

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
 
F

FinRazel

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.
 
Top