Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7
Default Importing Data Into Excel From LONG Web Page With URL Ending With .cfm

Hello,

I'm trying to import data into Excel from a very long web page whose URL
ends with .cfm.

When I printed the contents in Notepad using Tahoma 8, it ran almost 500
pages. To say the least, I prefer not to print almost 500 pages.

There are 4 columns on the web page, in addition to a menu of hyperlinks to
the extreme left.

When I right-clicked the contents to export them into Microsoft Excel, a box
appeared with the following: The Web query returned no data. To modify the
query, click OK, click the name of the external data range in the name box
on the formula bar, and then click Edit Query on the External Data toolbar.

Being very new to Excel and having a project which involves re-ordering
data, I have no idea whatsoever what the message means or how to accomplish
the importation of data from the web page in question.

If there is anyone who can assist me in understanding the message and
"walking me" through the necessary steps in being able to re-order the data,
I would most certainly appreciate your efforts.

Additionally, there are other web pages whose URLs end with .asp where I
need to achieve the same objective; that is, importing the data into Excel
in order to re-order it.

To say the least, thanks in advance!

Regards,

Martin


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Print a long 2 page column list, on one page Stella Excel Discussion (Misc queries) 6 May 2nd 07 05:09 AM
Importing long numbers from CSV file Harry Excel Discussion (Misc queries) 4 January 14th 07 02:02 AM
Importing checkbox data from web page Linda Ellison Excel Discussion (Misc queries) 0 April 18th 06 06:46 PM
worksheet has 1 page of data but is 84 pages long Donna 12589 Excel Discussion (Misc queries) 4 January 17th 06 08:41 PM
print 1 long row(20 columns) in excel to one single page Calvin Excel Worksheet Functions 1 November 10th 04 06:51 PM


All times are GMT +1. The time now is 08:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"