Hiya, can anyone tell me if it is possible to have a master excel workbook that can be updated via vba with ado/sql? I know I can read from the master workbook using another workbook and the ado connection but I can’t remember if the updating records was still available. Basically I will have a master workbook acting like a database, then user workbooks will query the master db, update fields etc then move on to the next record. I would rather that approach compared to a shared workbook as with ado I don’t need to open the master db workbook and if I remember correctly it is also a lot faster.
Does anyone know if this is possible?
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.