Saving data to a closed workbook

[Niraj Baraili]

Hi Experts,

For example, we have a form which we shared with multiple people and the output file is saved in a shared location and process is that first output file is openned and after saving data it is closed. I was just wondering do we have option in VBA to save data to a workbook without openning it ? Can the multiple users data can be saved in same file ?

Any idea and suggestion ?

 

[Chihiro]

It is possible using ADO provided that your data is in Sql like table structure. However, it's not true database, so there is possibility of conflicting entries being committed etc (especially when multiple users are doing data entry concurrently).

See example given in links below.
http://stackoverflow.com/questions/...ange-the-value-of-a-cell-in-a-closed-workbook
http://erlandsendata.no/?p=2131

If you can utilize MS Access or other type of database. That'd be ideal (you can use ADO to append data to Access).

 

[Niraj Baraili]

Hi Chihiro,

Thank you for the information. I will go through this link.