Storing data from Userform to Shared Excel file wothout opeing the excel file.

HI,
I have designed a Userform. which uses by 10 members from 10 different systems for entering Customers data. In shared drive we have a shared Excel file. Here my problem is: whatever data entering by my team from different systems, the data needs to store in one excel file which i have already saved in shared drive without opening the file. Below is example code which i have written. In my code excel file opens every time and closes. I don't want the file to open. I want data to be stored even the file is in closed status. please help me in this..

Private Sub CommandButton1_Click()
Dim RowCount As String, a As String, b As String
a = Range("a1")
b = Range("b1")

' write data to worksheet
Dim wb As Excel.Workbook
Set wb = Workbooks.Open("D:\Balaji Naik\Chit Fund\bdungav.xlsx")

RowCount = wb.Worksheets("Data").Range("A1").CurrentRegion.Rows.Count
With wb.Worksheets("Data").Range("A1")

.Offset(RowCount, 0).Value = a
.Offset(RowCount, 1).Value = b
End With
wb.Save
wb.Close

End Sub

Honestly, this type of scenario would be best suited using an Access database setup with front-end and back-end files so multiple users can enter information via forms and it is automatically in the back-end db

Thank you AYData.. can you please provide me an example code...

Hi,

I have another question. I have a userform with 4 textbox and 1 command button. In four text boxes i need to input data from four different applications. for moving Userform to other applications i use shortcut key (Alt+Tab). Problem: Once textbox1 filled with some data, i pressed Tab key. Then cursor moved to Textbox2. Now I used Alt+Tab for moving to application for getting customer name. again I came back to userform, but the cursor is not appearing on Textbox2.

Please advise, what need to do for appearing cursor where it was before I pressed Alt+Ctrl.

I'd use google docs, data capture using webforms is beyond trivial - the backend workbook updates in real time, you can have unlimited users and you don't even need to write any code.

In my company our management restricted to use outside domains. Kindly provide solution on VBA code..! Thank you in advance