jrfarmer2010
New Member
- Joined
- Jan 18, 2018
- Messages
- 8
Hello there,
I am trying to repurpose coding that is used in another workbook to make it effective for the one I'm trying to create now. Essentially, it combines all the data from dozens of files into a single file where I can extract the data and/or utilize in pivot tables. There's a line in it that determines the file names that it will pickup though, and I must be really off my game today because I can't figure out how to change it to make it pickup the file names that I'll be using.
Here is the line of coding, let me know if you need to see more to answer the questions.
Thanks!
Jessica
I am trying to repurpose coding that is used in another workbook to make it effective for the one I'm trying to create now. Essentially, it combines all the data from dozens of files into a single file where I can extract the data and/or utilize in pivot tables. There's a line in it that determines the file names that it will pickup though, and I must be really off my game today because I can't figure out how to change it to make it pickup the file names that I'll be using.
Here is the line of coding, let me know if you need to see more to answer the questions.
Code:
With mybook.Worksheets(Mid(MyFiles(FNum), 21, Len(MyFiles(FNum)) - 25))
Thanks!
Jessica
Last edited: