VBA to open the Folder that contains the previous month folder

HI all ,

I am trying to build a macro that does the following:

1. Look for the folder named after the current year
2. In that folder look for the Folder that contains the previous month number and name ("4. April")
3. Create a folder in there called "Stakeholder files" and save another macro manipulated Excel file in there.

This is what I have so far. I know is not much, still some work to do.

Please Login or Register  to view this content.

Your help would be greatly appreciated.

Hi there,

See if the following code does what you need:

Please Login or Register  to view this content.

The highlighted values can be altered to suit your own requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M