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

1 reply [Last post]
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!

Lepa's picture
User offline. Last seen 1 year 38 weeks ago. Offline
Joined: 06/23/2008
Posts: 591
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