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.

Creating a default file name when saving excel files

  • Post reply
1 reply [Last post]
Fri, 10/24/2008 - 9:17am
Guest's picture
Guest

Hello!
i've created a excel template that i use for my work.
since i use it practically everyday of work, i decided to save the files including the dates, i.e. DSS 102408.xls

is there a way to automate this so i dont have to type them everytime i save my work.
PS. i know DSS 102408 is relatively easy to type beforehand but i make 8 different reports all with different file names (date exempted) so if its possible to make a vba script to that effect, i will be very very grateful.
thanks!

Bookmark/Search this post with
  • Buzz Up!
  • del.icio.us
  • Digg
  • Facebook
  • Google Buzz
  • Reddit
  • StumbleUpon
  • Technorati
  • Twitter
  • Yahoo
Top
Sun, 10/26/2008 - 6:43pm
#1
Lepa's picture
Lepa
User offline. Last seen 5 days 11 hours ago. Offline
Joined: 06/23/2008
Posts: 570
Re: Creating a default file name when saving excel files

Hi there, did you take a look at the following post? http://www.compshack.com/visual-basic/save-file-using-visual-basic-excel...

With slight modification, it will do what you want.

Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog

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.