Excel Programmatic (Existing) Workbook Access in .NET 2.0

J

JumpingMattFlash

Hi there,



I'm currently trying to create using .NET 2.0 a program which creates a .XML
file containing the results of a stored procedure. The .xml file is linked to
an excel spreadsheet which is then periodically emailed out. The sticking
point is between the XML file creation and emailing it out. How do I force
the .xls file to refresh the data found in the .XML file.



I'm trying to find a way in .NET to programatically access an existing
Workbook and then run the RefreshAll() method?



Many thanks for your help,

Matt
www.jumpingmattflash.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
vba code does not run 3
Change Ribbon in Excel 2007 3
Creating a line break (newline) in a cell with SpreadsheetML 0
Microsoft Excel 2007- XML maps in my workbook are not exportable 1
Connection/Refresh Control unavailable for imported XML data 0
Programmatic saving of an existing excel file 2
Write Worksheet to MemoryStream in .NET 2.0 0

Top