Ask Question
Help Others
Home › Forums › Programming › Programming

You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.

Macro to save a file with last Friday's date (yyyymmdd)

  • Post reply
1 reply [Last post]
Mon, 08/10/2009 - 10:26am
Guest's picture
Guest

I'm new to VBA and am trying to save an .xls file I received today with last Friday's date in the file name (i.e. TGO_20090807). I receive many files all week and would like to use a macro to save them all as they arrive in this save folder. Once I receive all of the weekly files I want to create a macro that will zip all the text files and save them to a new zip file using the same file name (i.e. TGO_20090807.zip). I'll need to do this every week so I need the macro to be able to change the dates each week to last Friday's date. This is pretty complicated to a beginner, and I've been searching the web trying to find an example I can use. Can anyone help me?

Bookmark/Search this post with
  • Buzz Up!
  • del.icio.us
  • Digg
  • Facebook
  • Google Buzz
  • Reddit
  • StumbleUpon
  • Technorati
  • Twitter
  • Yahoo
Top
Wed, 10/07/2009 - 11:44pm
#1
SOLOMON's picture
SOLOMON (not verified)
Re: Macro to save a file with week name eg:filemon.bak

Hi Friends!!

I want to save file with name of the week to my backup file. for eg :bkupmon.dmp,bkuptue.dmp so on. In winxp DOS mode batch file. Please help me in this regard.

thanking you
solomon

Top
  • reply

Post new comment

The content of this field is kept private and will not be shown publicly.
CAPTCHA
The question below is to prevent automated spam submissions.
Image CAPTCHA
Enter the characters shown in the image.