Des mort
New Member
Members
Forum Posts: 1
Member Since:
February 16, 2022
February 16, 2022
Offline
Hi guys
I am looking to select a previous month excel file based on the file name which contains the month name from two folders.
First folder contains the file name as "File (HFS) Dec-2021" with month in the form mmm- year
Second folder contains the file name as "2021 12 rpt final" with year and month in the form of integer..
Can someone please help me in figuring out how to select the previous month file based on above two examples through vba and select the values from column A and save as new file??
Alan Sidman
Steamboat Springs, CO
Member
Members
Trusted Members
Trusted Members
Forum Posts: 193
Member Since:
October 18, 2018
October 18, 2018
Offline
crossposted: https://www.excelforum.com/exc.....ost5636171
Forum Timezone: Australia/Brisbane
Most Users Ever Online: 245
Currently Online: Wendy Rankin, Amanda Zibell
Guest(s) 10
Currently Browsing this Page:
1 Guest(s)
1 Guest(s)
Top Posters:
Catalin Bombea: 1917
SunnyKow: 1432
Anders Sehlstedt: 900
Purfleet: 414
Frans Visser: 346
David_Ng: 306
Hans Hallebeek: 290
lea cohen: 246
Jessica Stewart: 219
A.Maurizio: 216
Newest Members:
Cassandra McGuire
Leo Bonaparte
Excel Learner
david gavi
Rick KISA
Jan Elenbaas
Ranjeet Wankhade
Sugata Maity
Karen McCarron
Amanda Zibell
Forum Stats:
Groups: 3
Forums: 24
Topics: 6881
Posts: 30160
Member Stats:
Guest Posters: 49
Members: 33702
Moderators: 2
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Jessica
Moderators: Velouria, Riny van Eekelen
© Simple:Press —