implement the routine of resetting the Patients files

I need to  implement the routine of resetting the Patients files. This is the 3rd part of a question I started last week. I need to reset all patients files so we can use them for the next month. I would also like to move a copy of all files from the last month in to a finished folder with the year and month as the name of that folder. We need to records of all files that we worked on. Is this possible.
Thank you.

This is the link to Part 2 of the question

This is the link to part 1 of the question
jodyreidIT ManagerAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.


I would also like to move a copy of all files from the last month in to a finished folder with the year and month as the name of that folder.

What files you need a copy of ? the main patient files prior to resetting or the ones that we created in the Export folder ?
jodyreidIT ManagerAuthor Commented:
Yes the main patient files before resetting them.
Together with the file MonthEnd ? or no need ?
OWASP: Avoiding Hacker Tricks

Learn to build secure applications from the mindset of the hacker and avoid being exploited.

jodyreidIT ManagerAuthor Commented:
Yes if possible. Thanks
btw did u proceeded in converting your xlsm to xlsx and removing code and buttons from patients files ?
ok here is your solution

This version of the workbook will do the following:

Upon Activating the red button it will prompt you to select the last day of the month you wish to archive. Simply put the last day of that month you can exit anytime by selecting cancel or no depending on the question.

Once the day selected it will show a message box saying that it will archive all the patients files in a specific folder (it is in the Main folder a subfolder with yyyymm of the day you selected if you select 5/31/2015 then it will be 201505 for Aril it will be 201504 etc. ..

Once you say ok then the routine will save all the files in the Main folder to this new folder then proceed to reset the patients files only. (It will not save the Main macro file that you are running but any other older version will be archived)

PLs check it and let me know
jodyreidIT ManagerAuthor Commented:
This works great. Just what I wanted. Can we open a 4th part to this question or am I asking too much. I would like to have the final part process the end of month file. It clears out the "0" in the sheet and then exports the remaining data to a text file. I can start this question if you have the time to help with it. Thank you. It will save me so much time at end of moth. Thank you again
Your welcome and glad I could help. For sure you can ask as many questions as you wish it is my pleasure to be able to help. Please feel free to go as wide as you want it is always a challenge for me. I have some project with members here that went as far as 60 questions.

Pls don't forget to have the question clear as to what you need to achieve and post a link in here if you need my help.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jodyreidIT ManagerAuthor Commented:
Thank you for all your help. Here is the link to the final part of this question. Hope you can help with it.
Thank you again.
jodyreidIT ManagerAuthor Commented:
Thank you so much for all your help with this. It works great.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.