0 Replies Latest reply: Feb 6, 2013 2:20 AM by Jyothish KC RSS

    Importing .xlsm files in different folder with same format

    Jyothish KC


      I want to imports .xlsm files from different folders with in an directory. iam using followig code... still its not working..HELP



      SUB DoDir (Root)


      FOR each File in filelist(Root& '\*.xlsm')






      (ooxml, embedded labels, table is Sheet1$);


      NEXT File

              FOR each Dir in dirlist (Root&'\*')

              CALL DoDir(Dir)

          NEXT Dir


      END SUB

      CALL DoDir('Path of Directory');