Saving Macro with date in front

[Jiptastic]

I've taken this code from someone smarter than me on this forum, and have been using it at work. It saves a file with the current date and time. Something like this "My Awesome Report 11-30 0854". My boss just recently said she wants the reports to look like this: "11.30.12 My Awesome Report". I can't seem to tweak this to do what I want. Any ideas?

Please Login or Register  to view this content.

[Norie]

Try this.

Please Login or Register  to view this content.

[Jiptastic]

Norie,

I've specified it a bit, but it still doesn't work. I don't really understand what p does or the necessity of it if I save it by the same file name every time. What do you think?

Please Login or Register  to view this content.

[Norie]

How doesn't it work?