Hi,
I want add come code to the end of a macro that will allow a user to select a date and then the macro will take that date and add it to the end of a filename and then save the file in a certain location.
E.g. save the file as "Report for X" where X is the date the user has selected once prompt.
What is the best way to do this?
TLP
Maybe,
Please Login or Register to view this content.
Be fore warned, I regularly post drunk. So don't take offence (too much) to what I say.
I am the real 'Napster'
The Grid. A digital frontier. I tried to picture clusters of information as they moved through the computer. What did they look like? Ships? motorcycles? Were the circuits like freeways? I kept dreaming of a world I thought I'd never see. And then, one day...
If you receive help please give thanks. Click the * in the bottom left hand corner.
snb's VBA Help Files
Hi JapanDave,
Is there anyway to use a calendar date picker rather than have them enter a free format date?
TLP
You will have to create a custom userform if you want a calendar.
It is likely you will encounter issues with Date Pickers if users have different versions of Excel.
However, here is one version that does not use Active-X controls - it is an add-in.
Date Picker Calendar
Another non-Active-X Date Picker
There are tons of resources available on Excel Date Pickers - do a web search and you'll get lots of links.
Palmetto
Do you know . . . ?
You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks