Removing a sheet in Spread COM

Posted by: abrahampetit on 29 April 2021, 1:54 am EST

  • Posted 29 April 2021, 1:54 am EST

    Hi,

    I want to remove the first sheet of a COM Spread. I have found this code on your forums:

    fprspread1.sheets.remove(fpspread1.sheets(1)),

    However seems that it does not apply to the Active X version, because the ".Sheets" property does not exist.

    I only see:

    .Sheet, .SheetCount, .SheetName, .SheetVisible, and .ActiveSheet

    But nothing about ".Sheets"

    How can I remove a sheet on a 8.029 com spread???

    Thanks!





Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels