Showing posts with label MS Office. Show all posts
Showing posts with label MS Office. Show all posts
Wednesday, October 9, 2013
Thursday, August 8, 2013
Friday, July 27, 2012
Exception from HRESULT: Excel automation issues
I was getting bizarre Exception from HRESULT: on vista where it worked fine on xp
I tried setting security to allow vba projects - nyet
I tried dcom - it wasnt there
I finally tried savecopyas lo and behold - it worked
I tried setting security to allow vba projects - nyet
I tried dcom - it wasnt there
I finally tried savecopyas lo and behold - it worked
Friday, June 29, 2012
Interop excel
I went through hell getting the right saveas format
until I started using
XlFileFormat.xlXMLSpreadsheet
thus:
until I started using
XlFileFormat.xlXMLSpreadsheet
thus:
workBook.SaveAs(path,
XlFileFormat.xlXMLSpreadsheet,
Type.Missing,
Type.Missing,
false,
false, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange,
Type.Missing,
Type.Missing, Type.Missing,
Type.Missing, Type.Missing);
Subscribe to:
Comments (Atom)