Add a month

[cmoughan]

Thanks for all the help so far guys...it's excellent!!
I have one more question

I'm creating a new folder at the end of a macro for the next month. How do I get it to add the next month??

I can get JulReviews, but I need to get AugReviews and so on.

Thanks guys!!!

Chris

 

[SkipVought]

Hi,

What application are we in Omega?

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[cmoughan]

Sorry....VBA, for Excel.

 

[SkipVought]

Omega,

Please tell me that you are NOT going to chop up your data and file it by month, PLEASE!

If this is Excel, there are ways of REPORTING data that is consolidated, by some subset criteria. But you loose soooo much by choping data up. Its harder to find and maintain AND at some time in the future, some savy boss will ask you a question that can ONLY be answered by looking at ALL the data for ALL the months, and YOUR DATA will be scattered in multiple files in multiple folders.

WHAT A MESS!!!

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[xlbo]

Thisworkbook.saveas("FullPath\" & format(date+28,"mmm&quot & "Reviews.xls&quot

or something similar should o it

Rgds, Geoff
Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?
Want the best answers to your questions ? faq222-2244

 

[DrBowes]

Use the above with:

Format(DateSerial(Year(Now), Month(Now) + 1, Day(Now)), "mmm&quot

(If you are worried about the first two or three days of the month. I am sure there are several other ways to do this too.)

 

[xlbo]

Just to add my voice to Skip's - I totally agree. Saving seperate monthly data in seperate places is the beginning of a nightmare

Rgds, Geoff
Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?
Want the best answers to your questions ? faq222-2244

 

[cmoughan]

I realize that data in multiple forms and areas is a PITA. (Pain In The A$$), BUT I am merely a slave to the man. My boss tells me to row the boat, and I row. If he wants data in seperate areas, then data in seperate areas it is. Just trying to get a paycheck.

VBA isn't even my job. I never did it until Monday. I'm a network guy. (Hardware is my deal).


Chris

 

[xlbo]

You should save the data in seperate places but keep a master copy of all of it together so when the Bossman asks what the YTD total is, you can give it to them in 30 seconds rather then 30 mins ;-)

Rgds, Geoff
Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?
Want the best answers to your questions ? faq222-2244

 

[SkipVought]

DITTO!

Skip,
Skip@TheOfficeExperts.com

http://www.TheOfficeExperts.com

 

[cmoughan]

Would a mergeworksheets take care of that?

 

[xlbo]

IMHO, all data should be collated into a single place - whether that "place" is an access table or ONE excel workSHEET. Please note that I'm talking workSHEET not workBOOK. Using that single storage place, it would be very easy to take monthly "cuts" of the data, using a pivot table / autofilter / advanced filter / formulae / code - whatever - and dump it into a seperate monthly file but KEEP THE MASTER DATA TOGETHER - that is the crux of the issue.

As to the mergeworksheets - never heard of it. I would suggest that to pull data together again, you should just copy and paste it under the previous month and add a month and year (and week if necessary) qualifier so that when you com eto make a cut of the data, you have an identifier to aggregate with / filter on

Rgds, Geoff
Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?
Want the best answers to your questions ? faq222-2244

 

[djburnheim]

I have to admit that I am collecting data and saving it into monthly workbooks then in seperate folders just as Skip has advised not to do but I've just been looking at what I have and can't see another easy way to do it...I'd love to hear some suggestions because I don't really like having 12 different folders with one file in each.

I generate about 20 rows of data on a daily basis and save it in columns to a sheet in a workbook, I then have 3 other sheets in the workbook that chart the data, I save the sheet as "mmmm Stats.xls" in a folder called "mmmyy".

 

[xlbo]

There's no problem saving data in different folders....as long as there is a master copy.
As part of your process, maybe you should have a macro that takes the daily 20 lines and copies them to a "Master" workbook with a day / week / month / year qualifier. That way, you get the seperate workbooks as mr bossman wants AND you get a consolidated set of data which you can query against

Rgds, Geoff
Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?
Want the best answers to your questions ? faq222-2244