Hi Everyone,
I run a small non-profit medical facility with high turnover. We track patients in a database program that can export a report of the current census of the unit in .csv format. Since we do not have medical staff on 24/7 I have to rely on orderlies to track the current census and update it in the system and on handwritten forms when clients leave. Since the turnover is so high reconciling the computer system and handwritten forms can be a confusing task.
To help prevent confusion, I spent the past week writing a comprehensive macro that formats the .csv reports into printed forms that the orderlies can use in place of the printed forms. Since the orderlies do not have very good computer skills i have written very specific instructions on how to run the reports in the database software (which automatically opens the .csv file in excel). Then they simply need to hit the command I have set up to run the macro and it automatically prints. This routine is simple enough that all of the orderlies can understand and run it and that part of it works great.
The problem I'm running into is that the reports need to be manually retitled in the database program each time it is run, because the default file name is "CLTLST." I tried using a macro that does a save as, and automatically retitles the resulting file, but I am still stuck with the original called "CLTLST". If there is a file called "CLTLST" existing in the folder I am saving the .csv file to, the program will not replace it, and it will not allow the file to be saved.
Is there an automatic way to rename or delete the original .csv file called CLTLST? I do not trust the orderlies to know to delete it or change the file name in the software program. If I was able to remove or change the original .csv file name each time the macro is run it would ensure that the orderlies do not need to manually enter a unique file name each time and substantially reduce the possibility of errors.
I hope this is clear enough to understand.
Thanks in advance for any help!
Bookmarks