JasonEnsor
Programmer
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?
Regards
J.
Does anyone know if this is possible?
Regards
J.