There's a possibility that I could get a freelance job doing some screen-scrapes of data on this company's MestaMed system and dumping the data into an existing Excel report.

My google-fu is weak, and I have not found any information on using VBA to automate Mestamed. I found one article that made it seem like Mestamed could be automated via OLE Automation, but there was no other data of value. Anyone have any information they'd be willing to share?

If not, then I'll do some research and see if there's a way to connect to the datbase that feeds Mestamed so I can query it directly.