none
Need VBA code for opening excel workbooks and collating the same in one workbook with reference to cells values RRS feed

  • Question

  • Hi There,

    I am loooking for the VBA codes for opening excel workbooks from a specific folder and collating all the sheets from the open workbook in one single workbook. but only for the ones stated in cells listed in excel file

    For e.g.

    My cell A1 value is "wasim". Macro should open this "wasim" excel workbook from the folder stated.

    My cell A2 value is "ali". Macro should open this "ali" excel workbook from the folder stated.

    and finally collate all the sheets in one workbook.


    Pleaes help me in this. I'll be very thankful to you guys.

    Thanks,

    Wasimali Bori

    Tuesday, February 10, 2015 11:08 AM

Answers

All replies

  • This forum is for vb.net, for VBA you have a better chance here

    http://social.msdn.microsoft.com/Forums/en-US/isvvba/threads

    • Marked as answer by Wasimali Bori Tuesday, February 10, 2015 1:47 PM
    Tuesday, February 10, 2015 11:19 AM
  • Hello,

    I am moving your question to a better forum for this question


    Please remember to mark the replies as answers if they help and unmark them if they provide no help, this will help others who are looking for solutions to the same or similar problem.

    Tuesday, February 10, 2015 1:08 PM
  • i have asked it on 

    https://social.msdn.microsoft.com/Forums/vstudio/en-US/2646838f-ddad-4b95-b98c-21ce092ac149/need-vba-code-for-opening-excel-workbooks-and-collating-the-same-in-one-workbook-with-reference-to?forum=isvvba

    I am not how to close this thread. Can anyone do this for me please

    Tuesday, February 10, 2015 1:47 PM