Avatar of Lennon Gary
Lennon Gary
Flag for United States of America

asked on 

Macro To Open And Copy A Workbook Into Another Workbook

I need assistance in a VBA that will open the most recent file in folder (saved on a shared network path).

The main workbook that will have macro will have a dropdown with folder names. When I run the macro I want it to (1) look for the folder name then (2) open the most recent file (3) save/copy the "master" tab into the main workbook as a new tab. The new tab can be named "previous file".

 Please open the attached file.
VBAMicrosoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Sam Jacobs

8/22/2022 - Mon