Hi,
I'm trying to get a bit of code to name a file as the prior month. I searching this forum and many others, as well as excel help, and even asked our traning department in work, all to no avail.
Does anyone know how I can get this to work?
This is what I have:
Cheers
Please Login or Register to view this content.
Last edited by VBA Noob; 05-23-2008 at 11:00 AM.
Try
Please Login or Register to view this content.
genius!
Thank you very much
edit - I was probably looking in the wrong place, but couldn't find it anywhere, and no one I asked in work knew!
That's gonna make things a lot easier - thanks!
Is there any chance you could break that down for me please?
I'd like to know how it works if I can.
what part of the code does what?
Well DateSerial returns a date based on Year, Month and Day values.
The trick is a day of Zero will cause the function to return the day before the 1st of the month, which is the last day of the previous month.
cool, thanks very much. That's a good price of code to know
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks