Hi Everyone,
simple code to save file with tomorrows date however is there a way to save it with the letters in uppercase? e.g 08AUG13 instead of 08Aug13 i tried changing the format to ddMMMyy but had no effect
Please Login or Register to view this content.
I dimed your variable (good practice) and changed the name of your sub from a used term (another good practice). Give it a try.Please Login or Register to view this content.
e/ If you are trying to save the file in the same file path as the current file then you need to remove the "" from filepath
Thanks,
Solus
Please remember the following:
1. Use [code] code tags [/code]. It keeps posts clean, easy-to-read, and maintains VBA formatting.Highlight the code in your post and press the # button in the toolbar.2. Show appreciation to those who have helped you by clickingbelow their posts.
3. If you are happy with a solution to your problem, mark the thread as [SOLVED] using the tools at the top.
"Slow is smooth, smooth is fast."
You don't even need a variable, i.e.
HTHPlease Login or Register to view this content.
Robert
____________________________________________
Please ensure you mark your thread as Solved once it is. Click here to see how
If this post helps, please don't forget to say thanks by clicking the star icon in the bottom left-hand corner of my post
Trebor76 - Genius!
greatly appreciated
Thanks for the feedback and for marking the thread as closed (as well as adding to my reputation)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks