Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
Default Importing XML to Excel

Hi,

I want to import an xml document into my excel datasheet. What
References do I need to included and what classes can I then use to do
this? XmlTextReader?

Thanks for your help,

Barry.

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default Importing XML to Excel

Barry,
If XL2002 or higher, it has native support; you can just open it in XL.

NickHK

wrote in message
oups.com...
Hi,

I want to import an xml document into my excel datasheet. What
References do I need to included and what classes can I then use to do
this? XmlTextReader?

Thanks for your help,

Barry.



  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
Default Importing XML to Excel

On 8 Juni, 11:28, "NickHK" wrote:
Barry,
If XL2002 or higher, it has native support; you can just open it in XL.

NickHK

wrote in message

oups.com...



Hi,


I want to import an xml document into my excel datasheet. What
References do I need to included and what classes can I then use to do
this? XmlTextReader?


Thanks for your help,


Barry.- Dölj citerad text -


- Visa citerad text -


Cool, but I need to format things in a specific way. Any idea what
Reference I need?

Thanks,

Barry.

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default Importing XML to Excel

I have MS XML v2, v3, v4 on my system.
Depends what you/your user have/need.

NickHK

wrote in message
ups.com...
On 8 Juni, 11:28, "NickHK" wrote:
Barry,
If XL2002 or higher, it has native support; you can just open it in XL.

NickHK

wrote in message

oups.com...



Hi,


I want to import an xml document into my excel datasheet. What
References do I need to included and what classes can I then use to do
this? XmlTextReader?


Thanks for your help,


Barry.- Dölj citerad text -


- Visa citerad text -


Cool, but I need to format things in a specific way. Any idea what
Reference I need?

Thanks,

Barry.


  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
Default Importing XML to Excel

On 8 Juni, 11:48, "NickHK" wrote:
I have MS XML v2, v3, v4 on my system.
Depends what you/your user have/need.

NickHK

wrote in message

ups.com...
On 8 Juni, 11:28, "NickHK" wrote:





Barry,
If XL2002 or higher, it has native support; you can just open it in XL.


NickHK


wrote in message


roups.com...


Hi,


I want to import an xml document into my excel datasheet. What
References do I need to included and what classes can I then use to do
this? XmlTextReader?


Thanks for your help,


Barry.- Dölj citerad text -


- Visa citerad text -


Cool, but I need to format things in a specific way. Any idea what
Reference I need?

Thanks,

Barry.- Dölj citerad text -

- Visa citerad text -


Well, I guess I would prefer if they could use my excel file without
having to install anything on their machine. They will then onpen
their xml doc via a dialog and VB will format the xml data onto the
datasheet as required.

They do have .net 2.0 installed though...

Thanks,

Barry.
Barry.



  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 21
Default Importing XML to Excel

On 8 Juni, 12:34, wrote:
On 8 Juni, 11:48, "NickHK" wrote:





I have MS XML v2, v3, v4 on my system.
Depends what you/your user have/need.


NickHK


wrote in message


oups.com...
On 8 Juni, 11:28, "NickHK" wrote:


Barry,
If XL2002 or higher, it has native support; you can just open it in XL.


NickHK


wrote in message


roups.com...


Hi,


I want to import an xml document into my excel datasheet. What
References do I need to included and what classes can I then use to do
this? XmlTextReader?


Thanks for your help,


Barry.- Dölj citerad text -


- Visa citerad text -


Cool, but I need to format things in a specific way. Any idea what
Reference I need?


Thanks,


Barry.- Dölj citerad text -


- Visa citerad text -


Well, I guess I would prefer if they could use my excel file without
having to install anything on their machine. They will then onpen
their xml doc via a dialog and VB will format the xml data onto the
datasheet as required.

They do have .net 2.0 installed though...

Thanks,

Barry.
Barry.- Dölj citerad text -

- Visa citerad text -


Hello again,

I have "Microsoft XML, v6.0" so I have added a referrence to that. Can
anyone tell me where to find the online documentation associated with
this?

Thanks,

Barry.

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
Importing Alan Beban's code on Arrays; Importing a module or a project Steve G Excel Worksheet Functions 4 August 27th 07 04:18 PM
Importing from Excel Amy Excel Discussion (Misc queries) 1 March 31st 06 03:09 PM
importing into excel jason2444 Excel Discussion (Misc queries) 1 March 29th 06 10:05 PM
importing into excel Tim V Excel Programming 0 July 13th 05 09:39 PM
Excel importing of .csv and .xml Bernie Yaeger Excel Programming 2 July 28th 04 04:00 PM


All times are GMT +1. The time now is 04:19 PM.

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"