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.

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.

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.

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.

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.

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.