#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Excel 2000

Does Excel 2000 support Importing XML Data? If yes, how do I activate the
function the function?
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 8,856
Default Excel 2000

No, I think this was introduced in Excel 2003.

What I did when receiving some files in this format was to rename the
extension to .hml and then open within Internet Explorer by double-
clicking. From there I could use File | Save As to save the file
as .TXT, which I could then put into Notepad to tidy it up further.
Saving the file as .txt again enabled me to import it into Excel in
the format I required. Is .XML meant to be an improvement?

Hope this helps.

Pete

On Jul 24, 4:22*pm, Jay Singh <Jay
wrote:
Does Excel 2000 support Importing XML Data? If yes, how do I activate the
function the function?


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
Open 2000 file attachments in Excel 2000 Judy[_2_] Excel Discussion (Misc queries) 2 September 20th 07 10:20 PM
I cannot edit cell format in Excel 2000 (Part of office 2000)! Brett Excel Discussion (Misc queries) 1 April 12th 06 05:58 PM
Using Excel 2000 as Data source for Word 2000 document Malcolm Agingwell Excel Discussion (Misc queries) 2 June 21st 05 09:28 AM
Hyperlink in Excel 2000 can't open bookmarked Word 2000 file DCheslock Excel Discussion (Misc queries) 1 May 5th 05 10:46 PM
Excel Programs developed in Office 2000 on Windows 2000 Trooper Excel Discussion (Misc queries) 4 March 12th 05 11:09 PM


All times are GMT +1. The time now is 05:49 PM.

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

About Us

"It's about Microsoft Excel"