Budinski
New Member
- Joined
- Mar 2, 2009
- Messages
- 17
Someone was nice enough to write some code that works well by looking at a list of file paths and copying data from those books to a new workbook. Now I would like to copy data from the same list but from another sheet. Is there a way to specify a sheet name/number in a path so that when it runs it will look at the next sheet instead of just the first sheet in each book?
Currently I have a sheet with:
c:\example\book1.xls
c:\example\book2.xls
c:\example\book3.xls etc
This always takes data from sheet1
Can I specify:
c:\example\book1.xls[sheet2]
c:\example\book2.xls[sheet2]
c:\example\book3.xls[sheet2]
I know there are far better ways of doing this but it will save me asking someone to write a whole new macro.
Currently I have a sheet with:
c:\example\book1.xls
c:\example\book2.xls
c:\example\book3.xls etc
This always takes data from sheet1
Can I specify:
c:\example\book1.xls[sheet2]
c:\example\book2.xls[sheet2]
c:\example\book3.xls[sheet2]
I know there are far better ways of doing this but it will save me asking someone to write a whole new macro.