Results 1 to 2 of 2

Thread: fetch sheet names of different excel

  1. #1

    fetch sheet names of different excel



    Register for a FREE account, and/
    or Log in to avoid these ads!

    HI, can you please help me in fetching sheet names of another excel into current excel? For example, one file sample1.xls with 3 sheet names "a","b","c". i wanto get those 3 names into sample2.xls
    I need this entire process to be automated. i .e whenever file sample1.xls arrives into the folder,sample2.xls should fetch the sheet names of the
    sample1.xls
    FYI, I am able to fetch the sheetnames of current excel file by creating the formula =REPLACE(GET.WORKBOOK(1),1,FIND("]",GET.WORKBOOK(1))," ") and with the help of index(sheetlist,row())

    Please help me ASAP.

  2. #2

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •