If I can help by rolling up my question. Is: Is it possible to build a macro that can complete the following objectives:
1) Match two files (from two different directories x,y on a network) from a list made in excel (vlookup?). 2) Rename the new workbook i.e. Richard CR006 V2.xls and worksheet tab i.e. CR001 V2 as is used below). 3) Save new workbook in different directory z I really appreciate the expertise of your team at Google - nothing less than outstanding. Please let me know if any of this makes sense. Happy Holidays to those of you get them! Sincerely, Kent On Dec 22, 4:13 pm, HarryP Knuckles <kent.bouc...@tbs-sct.gc.ca> wrote: > Good afternoon Folks, > I have two directories of excel > files (Part 1 and Part 2) that contain the same information except the > second directory (part 2’s) contains newer information than the first > directory (part 1’s). > > I have a list embedded into a worksheet of my macro workbook that > shows the relationship (one for one) between the titles of the first > directory (part 1's) with the titles of the second directory (part > 2's) As illustrated below. > > Here is an example: > > Part 1 FileName Part 2 > FileName RESULTING FileName > > Richard CR004 V2.xls Richard4.xls Richard CR004 V3.xls > Richard CR005 V2.xls Richard5.xls Richard CR005 V3.xls > Richard CR006 V2.xls Richard6.xls Richard CR006 V3.xls > Richard CR007 V2.xls Richard7.xls Richard CR007 V3.xls > etc. > > My challenge is to complete the following tasks for each of the > workbooks found within the (Part 2) directory: > > 1) Automatically open the first workbook from the (part 2) directory > (process needs to loop till all files in folder have been opened and > saved). > > 2) To then vlookup (or VB equivalent) the title (part 2) of the > workbook with the list that will be embedded in the macro workbook to > get the orginal name (from Part 1). I.e. Richard4.xls is (Part 2) of > Richard CR004 V2.xls (part 1). > > Once there is a match; if there is a match. > > 3) Rename and save the workbook into a new third directory (resulting > fileName) with the matched name that is consistent with the first > directory. > > Any help that you can provide would be greatly appreciated!! > > Regards, > Kent -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. ------------------------------------------------------------------------------------------------------ To post to this group, send email to excel-macros@googlegroups.com
