Saving to Specific folder - Dependent on month

**shiser** · 01-30-2014, 11:33 AM

Hi,

I'm very new to macro so please bare with me

Basically, i want my file to be saved in the directory dependent on the month we are currently in.

Currently i have the macro as follow:

Please Login or Register  to view this content.

So instead of "D:\P&L\2014\" it'll be "D:\P&L\2014\Jan"

Thanks

**shiser** · 01-30-2014, 11:43 AM

So many rules.

Done

**shiser** · 01-30-2014, 12:11 PM

I figure it may require me to define the month somehow:

Please Login or Register  to view this content.

The month is a variable, hence the odd code but I guess i need to somehow make the macro select the correct month. So need to add "monthtarget" with in this code?

Please Login or Register  to view this content.

Complete guess work by the way

**shiser** · 02-04-2014, 12:07 PM

nope? Is it the lack of detail or it isn't possible?

Saving to Specific folder - Dependent on month

LinkBack

Thread Tools

Rate This Thread

Display

Saving to Specific folder - Dependent on month

Re: Saving to Specific folder - Dependent on month

Re: Saving to Specific folder - Dependent on month

Re: Saving to Specific folder - Dependent on month

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Saving file to a specific folder

Problem Saving to a specific folder

Saving a sheet to a specific folder

saving file to a specific folder

Saving to a certain month folder

Bookmarks

Bookmarks

Posting Permissions