Final Part of a four part question

I have the end of month file that I need to add to the TherapyEngine-V02.xlsm. The MonthEnd.xlsm has all the patient date collect in one place. I have a macro that removes all the lines with "0"s. Next I have a macro that copies each column and paste it to a text file in a certain order. This text file is then saved as PCC-OC-Import201410061257.txt with the date and time stamped at the end of the name files. This is then ready to up load to the billing program. Can we add another button to the TherapyEngine-V02.xlsm that would do this for us. Thank you.

Here is the link to all other parts of this question.
http://www.experts-exchange.com/questions/28690220/implement-the-routine-of-resetting-the-Patients-files.html
http://www.experts-exchange.com/questions/28689576/Monthend-Part2.html#a40831055
http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_28684810.html?anchor=a40830535
Allen--Florence-06-30-1915.xlsx
Davis--Muriel-02-25-1927.xlsx
Jones--Raphael-08-14-1936.xlsx
Smith--Neil-05-27-1930-Second-Admit.xlsx
TherapyEngine-V02.xlsm
MonthEnd.xlsm
jodyreidIT ManagerAsked:
Who is Participating?
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.

gowflowCommented:
Hello
I have a question

In monthend you have 3 buttons
Clear out 0
Export Files to PCC
Delete Data

You mention to add an other button in TherapyEngine which one of those 3 you want the button to be ?
gowflow
0
jodyreidIT ManagerAuthor Commented:
I was hoping for all 3 in one button. If not then we need the Clear out 0 and Export files to PCC. Let me know if this is possible. Thank you.
0
gowflowCommented:
Yes it is possible and have been incorporated in this version.

I also removed all code from MonthEnd.xlsm and also the buttons and the sheet Settings that has no use in that file. I moved the sheet Settings in the TherapyEngine-V03.xlsm as you can see in the attached file.

For sure as done previously you will find all your previous code (including all code in file MonthEnd) in the module OriginalMacroes.

I am also attaching the new MonthEnd.xlsm that you will need to add in replacement of your existing one.

Please check the third button Export to PCC and let me know your comments.

Rgds/gowflow
TherapyEngine-V03.xlsm
MonthEnd.xlsm
0

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 so much for all your help. It works great. Thank you.
0
gowflowCommented:
Yoour welcome anytime.

I will keep this question monitored in case you have a new challenge please let me know.
gowflow
0
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.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.