Hi Bert!
It has been busy- I've had to mold my office to conform to the changes of today's medical environment. Now I have less Medicare, less hospitalizations (I'm using hospitalists more), and see more private pay patients. This has left me with more time on my hands, which is something that I've been looking forward to for a long time.
This week I'll be going to my annual cruise vacation with my family. In 2008 we went to the
eastern mediterranean; this time we're going to the Western Mediterranean, including ports of call in Spain, France, Italy, and Capri. Nice!
The one thing that Excel is great for is to link Access with Office Ally. In fact, I'm doing it successfully now. The steps, through VBA are:
1) Use the transferspreadsheet method to export the billing data to an Excel spreadsheet.
2) Bring up the spreadsheet and manipulate it while in Access- you have to delete the top line which has the field headers:
"xlWB.Worksheets(1).Cells(1, 1).EntireRow.Delete"
3) You have to then save it as an Excel txt file using the Exporttotextfile method (handled by Access, but done within Excel).
After that, you log into Office Ally, upload that final file and presto- electronic billing without any clearinghouse charges. Ever since I started this 2 months ago its gone very well. The whole process is based on
the spreadsheet that Office Ally initially sent me back in March. I'll most likely go through the process more in depth on my website so that others can benefit from it.
Cheers,
Al
