SaveAs excel template (urgent)

HCL Domino Domino Forum
1

Happy new year!

I’ve got an urgent problem with LotusScript - cannot save a workbook as excel template:

xlApp.ActiveWorkbook.Save(fname)

  • works fine, but only save as a normal worksheet

xlApp.ActiveWorkbook.Save(fname, 17)

  • doesn’t work (17 means filefomrat as xltemplate.), returns illegal use of parentheses - script error, cannot save design

Any idea to bypass this problem?

Thanks.

John

2

Subject: SaveAs excel template (urgent)

Try putting a Call statement before:

Call xlApp.ActiveWorkbook.Save(fname, 17)

hth