Jul 31, 2015 02:56 AM|Nan Yu|LINK
Hi anupamabr ,
Is it possible to update existing excel file located in share drive using sql data in vb.net
From my point of view ,the question may be divided into two parts: firstly ,you need to reading excel file which is on shared drive , when you could refer to link below which discuss and provide several ways to access file in shared file:
In addition ,If several users have the same file open, only the first person is using the active document, the rest are opening a read only version .
Secondly ,you need to open the excel and update it with vn.net ,please refer to links below for more details and demo: