in reply to Creating desired number of worksheets in excel

thank you! one more question, is there a command that i can check if "Sheet3" for example is open? by sheet number or name?
  • Comment on Re: Creating desired number of worksheets in excel

Replies are listed 'Best First'.
Re^2: Creating desired number of worksheets in excel
by Corion (Patriarch) on Sep 11, 2013 at 11:04 UTC

    Have you read Using Win32::OLE and Excel - Tips and Tricks? It contains many helpful tips, and also how to find the Excel methods within the Excel documentation.

    If you think you've seen this response before, maybe now is the time to follow its advice.