We write to a XML file format then command Excel to load it in that way.
3 steps in 3 callable functions:
Prep file using stored data cell formats on local machine.
Export and Write file to users computer
Open excel and import XML file.
Totally transparent to user. They get Excel popped up in their screen WITH the data in in.
Thanks for the quick reply. What do you mean by "prep file using stored data cell formats on local machine"? I'm assuming you have an Excel template setup on the user's machine and you load the XML document into Excel using that template. Is that correct?