asked on

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.
https://www.experts-exchange.com/questions/28690220/implement-the-routine-of-resetting-the-Patients-files.html
https://www.experts-exchange.com/questions/28689576/Monthend-Part2.html?anchorAnswerId=40831055#a40831055
https://www.experts-exchange.com/questions/28684810/Opening-a-macro-on-another-excel-spreedsheet.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

Jacques Geday

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

Jody Reid

ASKER

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.

ASKER CERTIFIED SOLUTION

Jacques Geday

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Jody Reid

ASKER

Thank you so much for all your help. It works great. Thank you.

Jacques Geday

Yoour welcome anytime.

I will keep this question monitored in case you have a new challenge please let me know.
gowflow