Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() "Stefani" wrote in message ... Hello, I am using the code below to programmatically create an .xls file: Excel.Workbook newWorkbook = excelApp.Workbooks.Add(XlWBATemplate.xlWBATWorkshe et); I have an XML string of data that I'd like to just "shove" into the .xls then open Excel. The XML string is a result of an SQL query. The User will then use Excel view and manipulate the data. I've found no API documentation to do this en masse and not cell by cell. Thanks in advance, Stefani Save the xml string to a file with an xml extension. Excel can open xml files. I think you need at least Excel 2002. /Fredrik |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
string assistance to open workbook via macro | Excel Discussion (Misc queries) | |||
EXCEL wont open from Explorer, must open EXCEL then find file | Excel Discussion (Misc queries) | |||
Open Books with VBA based on certain string | Excel Discussion (Misc queries) | |||
Macro to open most recent file with a particular filename string | Excel Discussion (Misc queries) | |||
Excel 2003 Workbooks.Open with CorruptLoad=xlRepairFile fails on Excel 5.0/95 file due to Chart, with Error 1004 Method 'Open' of object 'Workbooks' failed | Excel Programming |