Tue Jan 27, 2015 11:00 am
Thanks for your testing! It is not easy possible to send a sample console application, the
datas will with a monstrous construct filled in.
I have take out the button on the first sheet, because this can work later.
It exists only the macro without usage.
The same file without macro works fine.
Can it be, there is a problem when i generate a new Workbook and fill in it the datas?!
WorkBook = new Spire.Xls.Workbook();
WorkBook.Version = ExcelVersion.Version2007;
// fileName is the file with macro
WorkBook.LoadFromFile(fileName);
// add datas
WorkBook.SaveToFile("test.xlsm", ExcelVersion.Version2007);
// try to open in Excel with error - file has the wrong type or file extension.
Thanks for your help!