open xml in excel without saving to file (via dom or text)

[CubeE101]

I wasn't sure where to post this...
It deals with VBA in a sense that you are working with excel...
Though I am using VB6
But the base of it revolves around XML, so I posted here.


Does anyone know if it is possible to open an XML document in Excel with a method similar to OpenXML, but using text or a dom object instead of a File...?

I am create a DOM on the fly, and want to view it as a table in Excel...

I already have it to where you can view it in an IE window... But you can't edit it... However, you can right click and export to excel...

I DO NOT want to save it to a temporary file...
I know that is an option, but I hate doing that, I think it is a sloppy method...

Currenently, I am looping through the Elements, and writing the Cells, cell by cell... This Method is VERY slow... I prefer to click and have instant results as opposed to having to wait...

If anyone has any ideas, please share...

Such as...
Is there a way to automate IE to export to excel?

Visit My Site
PROGRAMMER: Red-eyed, mumbling mammal capable of conversing with inanimate objects.

 

[CubeE101]

OK... (duh)
I figured out a way...

You can create a string using either For loops, or XSL containing tab delimited values, with cariage return delimited lines, the insert that into the first cell, and excel will handle the rest...

I might post an example later...

Visit My Site
PROGRAMMER: Red-eyed, mumbling mammal capable of conversing with inanimate objects.