JP-2
10-12-2011, 08:47 PM
Hello Good Folks At VBAX!
Thanks for all the wonderful posts! Actually I have a couple of questions for anyone that can help. They are both similar. I am new to VBA and just started learning so I am currently clueless.
My question is how do I copy spreadsheets with a specific name string from multiple workbooks into a master workbook?
For example, if I had a spreadsheet with a similar name string in 20 different workbooks
parks-mvp
baseball-mvp
dugout-mvp
How can I take all the worksheets that has the "mvp" in the naming string in those different workbooks and dump it into a new workbook named let's say "mvp". So there will be 20 spreadsheets with "mvp" in its name in this one master workbook.
The second question is identical to the first, except, how would I take those same spreadsheets (originally mentioned from the 20 different workbooks) with the "mvp" in the name string and create a new workbook from each individual spreadsheet?
So "parks-mvp" will become its own workbook, "baseball-mvp" will become its own workbook and "dugout-mvp" will become its own workbook.
All the files are sitting in the same folder.
Again, I am totally clueless and was wondering if any of you good folks could assist with either one of these items. if possible.
Thanks a million!
JP-2 (James Pinny)
Thanks for all the wonderful posts! Actually I have a couple of questions for anyone that can help. They are both similar. I am new to VBA and just started learning so I am currently clueless.
My question is how do I copy spreadsheets with a specific name string from multiple workbooks into a master workbook?
For example, if I had a spreadsheet with a similar name string in 20 different workbooks
parks-mvp
baseball-mvp
dugout-mvp
How can I take all the worksheets that has the "mvp" in the naming string in those different workbooks and dump it into a new workbook named let's say "mvp". So there will be 20 spreadsheets with "mvp" in its name in this one master workbook.
The second question is identical to the first, except, how would I take those same spreadsheets (originally mentioned from the 20 different workbooks) with the "mvp" in the name string and create a new workbook from each individual spreadsheet?
So "parks-mvp" will become its own workbook, "baseball-mvp" will become its own workbook and "dugout-mvp" will become its own workbook.
All the files are sitting in the same folder.
Again, I am totally clueless and was wondering if any of you good folks could assist with either one of these items. if possible.
Thanks a million!
JP-2 (James Pinny)