Clive_B_DXB
New Member
- Joined
- Jun 8, 2016
- Messages
- 1
Hi all, Please could someone assist with a project that I am starting?
What I would like to do is create a program that will open (one at a time) all workbooks in a specific directory. Once open I need it to open and then close a number of other workbooks from another directory. The purpose of this is to allow the first workbook to update to the information in the second and then it will save and close the first workbook. This process is to be repeated for all files in the first directory.
I am quite new to VBA, having only written one working program previously and about 2 years ago.
All assistance is greatly received
Thanks in advance
What I would like to do is create a program that will open (one at a time) all workbooks in a specific directory. Once open I need it to open and then close a number of other workbooks from another directory. The purpose of this is to allow the first workbook to update to the information in the second and then it will save and close the first workbook. This process is to be repeated for all files in the first directory.
I am quite new to VBA, having only written one working program previously and about 2 years ago.
All assistance is greatly received
Thanks in advance
