Results 1 to 3 of 3
  1. #1

    Set name on Excel tab?


    I'm trying to set the name of the tab of the worksheet that I create in my code.

    I've tried this but it's giving me an error:

    SetExcelApp = CreateObject("Excel Application")
    Set ExcelSheet = ExcelApp.Workbooks.Add
    ExcelSheet(1).Name = "SomeName"

    QTP is giving me an error that says that "Object doesn't support this property or method"

    I know that the 1st two lines work, it's the 3rd line that I have wrong. I've tried a few variations on a theme but I can't seem to get it to work.

    Any suggestions?


  2. #2

  3. #3

    Re: Set name on Excel tab?

    Wow. That totally works. You really know your Excel. Thank you, Tarun.




Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
BetaSoft Inc.
All times are GMT -8. The time now is 04:13 PM.

Copyright BetaSoft Inc.