Manipulating previous month file

[saechaoc]

My issue is that I need to access the last months file titled "blah purchase forecast whatever was last Month current Year"

Is there a way to access the files with only knowing the current month?

It's stored in something like this

P:\Supply Chain\SCP\nomnom\blah\blahza\ABC Forecasts 2015\

[jaslake]

Hi saechaoc

What does the actual File Name look like?

Is it in the same Folder as the Workbook (ThisWorkbook) running the Code?

What do you want to do with "blah purchase forecast whatever was last Month current Year"...open it?

[saechaoc]

Jaslake,

I will be grabbing data from the workbook. I do not have a problem with that but I don't know how to refer to the last month and current year of the given file. Yes it will be in the same folder ie. P:\Supply Chain\SCP\nomnom\blah\blahza\ABC Forecasts 2015\

The file name would look like this:

P:\Supply Chain\SCP\nomnom\blah\blahza\ABC Forecasts 2015\blah purchase forecast whatever was last Month current Year.xlsx

To be more explicit consider:

P:\Supply Chain\SCP\nomnom\blah\blahza\ABC Forecasts 2015\blah purchase forecast June 2015.xlsx

[jaslake]

Hi saechaoc

I know this as you've mentioned it before

blah purchase forecast whatever was last Month current Year.xlsx

What does an ACTUAL FILE NAME look like?

Edit:
I see your edited response...Thanks...

[jaslake]

Hi saechaoc

This Code will open the prior Months Workbook...

Please Login or Register  to view this content.

[jaslake]

Hi saechaoc

What do you wish to do when the current month is January?

[saechaoc]

Hello, thank you for the help.

I would like to activate the previous month of the last year if that's possible.

[jaslake]

Hi saechaoc

Not tested...try this...

Please Login or Register  to view this content.

[jaslake]

Sorry...that should have been

Please Login or Register  to view this content.

[saechaoc]

Thanks I think this should work! But I've got a general outline and syntax for everything I need.

[jaslake]

It may work but I think this Line of Code should read

Please Login or Register  to view this content.

instead of

Please Login or Register  to view this content.

[saechaoc]

yeah I already fixed it thank you!

[jaslake]

You're welcome...glad I could help. Thanks for the Rep.