Excel Form on Local Area Network

[Waqar]

Hi all.

I have a Lab wher 25 PCs are connected which other. I make a complain form, I want any one fill that form from own PCs about complain and that Complain regiister on my PCs in Main Complain Record Excel File.

File Name :: User Form (at client site)
File Name :: Main Comlain Record (at server site)

Plz Guide me

Regards

 

[Waqar]

Smitty can u help me out ??

 

[Smitty]

Thanks alot Smitty

I go through with ur suggestion making a form but unable to understand how to make that form independent so that user fill that form and when they press ADD that complain entre in my main sheet via LAN.

Thanks in advance
Regards

To have a stand-alone form that writes to an Excel workbook you'd need to build something in .NET. On the other hand you can set up an Excel workbook to only display a user form, so that users can't see the data behind it.