vba - Create subfolder as per monthwise and one Masterworkbook

[malleshg24]

Hi Team.


Need your in :help creating subfolders and inside that one Masterworkbook.
Create a Folder with Current month and one Masterworkbook in it.
In Masterworkbook we maintain sheet name with previous working biz day.


Task is , User receives input files daily for previous day's work,
we add a new sheet with previous date in "mmm dd" format" paste the data in that sheet.
We apply a vlookup formula in current sheet and data range will be in previous day.


But Challenges is that when months changes, vlookup data will be in different folder.
and also I need to Create New Folder with Current month and one Masterworkbook in that.


Here I need to add loop through all the subfolder, find previous months folder and
in that open previous masterworkbook. otherwise, we can give browse option for user when months changes
for selecting previous Masterworkbook for vlookup purpose.


Plz assist I will modify the code as per my requirement . Thanks in Advance.



Regards,
mg

[Artik]

I think, that when creating a new MasterWorkbook, the solution to the problem would be to copy the spreadsheet from the last day of the previous month to the new MasterWorkbook.

Artik