ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   SasAs Issue: Automation Error (https://www.excelbanter.com/excel-programming/436320-sasas-issue-automation-error.html)

vinuthan

SasAs Issue: Automation Error
 
When i use the xlWorkBook.SaveAs(fileName,
Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue,
Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue,
misValue); it was giving me an error.


The issue got resolved when i changed the code to following
xlWorkBook.SaveCopyAs(fileName);


All times are GMT +1. The time now is 12:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com