Hi all
Publication1.jpg
It possible to control other workbook same in picture
1.Open BFile
1.1 Get (A1.txt Location) from Sheet1 to String
1.2 Run Marco to Open A File
1.3 Control A File to Run Marco
Loop 1.1
2.A FILE
- Run Marco from 1.3
- Get Location from string 1.2
- Save as new File And close
Macro, not marco
All of that should be possible with VBA. I have ran many macros to open a file, do work in it, save it off as another file then loop through 10,000 other files to do the same thing.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks