Hello,
I have CRM_Master.xls.
When I save the document, I want it to save as CRM_090914.
Hello,
I have CRM_Master.xls.
When I save the document, I want it to save as CRM_090914.
good for you
Hope this helps
Sometimes its best to start at the beginning and learn VBA & Excel.
Please dont ask me to do your work for you, I learnt from Reading books, Recording, F1 and Google and like having all of this knowledge in my head for the next time i wish to do it, or wish to tweak it.
Available for remote consultancy work PM me
Thanks for the snark! Good Morning.
Do you know how to do this via VBA?
Google it.
Nathan,
If that worked for me, I wouldn't be posting here.
untested
Please Login or Register to view this content.
Hello EnigmaMatter,
No everyone on the board is a Sasannach (Alba gu brath!).
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
I was able to use the Macro Recorder and a reference in a different problem to answer my question.
http://stackoverflow.com/questions/2...g-vba-in-excel
You sure there was nothing when you googled save as VBA or when you looked on the VBA help files?
There was, but I didn't quite get how it worked, or it was hidden in a larger solution. Usually I find more complex code than needed. This forum usually gives me 1-liners or better versions of my existing code.
Thank You,
EnigmaMatter
Leith, thank you! I used code that looked very similar to yours.
Alba gu brath - Scotland forever my friend
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks