I am trying to get a workbook to create a new workbook with the name week-(year)-(month)-(day) and then show that workbook.
Example
When I open the book " msl workbook" I want it to create a new book with the name "week-(year)-(month)-(day)" and make the new book active.
I am using excell 2003. The year, month and day would be the current date of use.
Is this possible.
Thanks for any help.
Lloyd
Last edited by 6StringJazzer; 09-16-2018 at 09:43 AM. Reason: Moved from Excel - New Users/Basics, requires VBA
This requires macros. Put the following code in the ThisWorkbook module of "msl workbook.xlsx" and save it as a .xlsm file.
I could interpret your file name description in more than one way. Give an example of what you want your file name to look like. Do you mean this:
week-2018-09-16.xlsx
The code will look like this:
Please Login or Register to view this content.
You can use your macro recorder to add a workbook and save it, once you have a code to work with, you can ask how to save it as a date format.
I have a button the the form to create the new form, the problem is when someone else uses the program they forget to create the new form.
So I am trying to eliminate the need for them to press the button.
Hope I have explained this correctly.
I could not get StringJazzers answer to work.
Lloyd
I would be happy to help, but I tested it before I gave it to you and it worked fine for me. I'll test it with your file if you attach it.Originally Posted by lloyd frank
Also note that I requested an example of what file name you want.
Please explain what "doesn't work" means.
- Does the code run?
- Does it run but do nothing?
- Does it produce error messages? If so, what do the messages say?
- Does it produce unexpected/wrong results? If so, how do the results differ from what you expect?
- Does it hang?
I think I have attached the file. It has been many years since I have been on the forum.
The file name should be "week-2018-09-17" or the day the file is opened. this is only used once a week.
You have the code in the wrong place. You put it in Module6.
Thanks everyone. That did it. (Don't see where to mark it solved)
Last edited by lloyd frank; 09-17-2018 at 04:55 PM.
Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."
If a member helped you solve your problem, consider adding to their reputation by clicking on the star icon below their name.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks