Hi,

Thanks for the reply. Yes, that is what I would mostly likely do if it was just me using the database. unfortunately, I am developing solutions for people in my company who steadfastly refuse to abandon excel as a database, and the data held in the spreadsheets they create is often information other people in the company need. I am hoping to find a way to extract data to share to other people as an ends to better internal communication. We currently rely on people remembering to tell other people they've updated their spreadsheets.

---

Reply from Alex Hedley:

Have a look into the CreateObject Function.
You can open up an Excel File in VBA and retrieve values from a Sheet referencing the Cells in the Workbook.
I'll see about making a Tip as it's a bit much to go into here or you could submit a TechHelp request.