Adding a worksheet fails - only on .XLSM file

Question

I am trying to add a worksheet to a workbook and it works fine for a .XLSX file. But for a .XLSM file - I get the dreaded COMException 0x800A03EC.

I have tried all of the following and all fail:

wrkbk.Worksheets.Add(Type.Missing, Type.Missing, Type.Missing, Type.Missing);
wrkbk.Worksheets.Add(wrkbk.Worksheets[wrkbk.NativeWorkbook.Worksheets.Count], Type.Missing, Type.Missing, Type.Missing);
wrkbk.Worksheets.Add(Type.Missing, wrkbk.Worksheets[wrkbk.NativeWorkbook.Worksheets.Count], Type.Missing, Type.Missing);

Questions 1, 2, & 3 suggest the above, but it doesn't work, for me at least, with a .XLSM file.

can you do *anything* in that xlsm (thinking about modal security prompts or the dreaded "Enable content" bar)? which version and instantiation method of PIA do you use? — Cee McSharpface, Jun 03 '18 at 13:34
@dlatikay - I can read from and write to a cell from my AddIn. Is there something else I should check? — David Thielen, Jun 03 '18 at 23:47
All xlsm files, or just individual one(s)? Have you tried on more than one system (computer)? Does it work via VBA in your environment, or does that also have problems with the Worksheets.Add method? — Cindy Meister, Jun 04 '18 at 13:59
@CindyMeister Hi Cindy!!! Long time since we talked. It's just 1 .XLSM file. We're asking our customer if we can share it. — David Thielen, Jun 05 '18 at 19:57
@CindyMeister - Your question led me to it - the workbook is locked. Therefore, no adding worksheets. — David Thielen, Jun 06 '18 at 15:58

score 0 · Accepted Answer · answered Jun 06 '18 at 15:58

0

This is failing because the workbook is locked. A locked workbook cannot have worksheets added to it.

answered Jun 06 '18 at 15:58

David Thielen

28,723
34
119
193

Adding a worksheet fails - only on .XLSM file

1 Answers1