The renaming trick doesn't work, because it imports it as HTML code then. There's some other formatting in the web page (like ad banners and such) which turns the spreadsheet to garbage if I use IE to Save As .txt and then import that .txt file. I can only get it to look decent if I save it as a .htm file and then import the .htm file, but then of course Excel applies all the formatting.
The web query tool looks interesting but also confusing, and seems to be quite a heavy handed approach for something I'd think would be pretty simple. There's got to be another way. All I want to do is tell Excel to turn off all calculations and autoformatting when I open a file! I didn't imagine it'd be so difficult to disable all this "helpful" junk..
I mean heaven forbid I was opening up and importing a giant series of tables of scientific calculations with many decimal places. Excel would just round them up to the nearest 4 or 5 and I can't find any way to turn that off.
Any other ideas?
Main Topics
Browse All Topics
by: bruintjePosted on 2003-08-29 at 12:29:16ID: 9250652
then rename a copy to myfile.txt and open it from the file menu it will ask for the format or non at all | next if it's there in plain text you can copy and paste it around
BUT
why not use a webquery to get only that table from the web it even does things like leaving formatting and garbage out
title : Managing Excel Web Queries
source : http://www.microsoft.com/o
----------
Description
With Microsoft Excel 97 -> 2003, you can reach out to the Web and include data you find there in your spreadsheets, without having to understand how the page was created, or how to create a query file. You select only the data you want, and once imported the data can be refreshed with a single click of a button, automatically whenever the workbook opens, or at a specific time interval. For example, you can use a Web query to select data from a financial Web site to track stock market values or an internal Web site that lists sales statistics.
----------
hope this helps a bit