Customer Sign In---Where To Start

[amsdowns]

Hey guys,

The challenge of the day is to create a customer sign in log using excel....not access.

Basically, customers come in, see the computer, sign in, press enter or submit, and the information is then sent to three computers. The staff then simply sees whos next and calls them up.

Now there's plenty of software out there that can do this....but i want excel to.

Basic question: Where do I start?

Thanks in advance!

 

[Trevor G]

Question would be first of all, do you want them to log in within Excel or as they switch the computer on? If computer you need to look at API information I believe.

If excel then this is possible by using a personal workbook macro.

 

[amsdowns]

The staff can start the computer up in the morning and open the excel file. Then when the customers start coming in, it'll already be up and ready for them.

 

[Trevor G]

So its a specific workbook that they are opening?

You can create a log sheet and then with the workbook event on open it can log there details and date time etc, then you can send emails to who ever based on todays date in a cell.

Open a new Workbook and then use Alt + F11 to go into VBA, then on left look at the top for the workbook and sheets and below the sheet names you will see thisworkbook. Double click here, then at the top select Object and change to workbook. You then have the workbook event for Open.

Then add this code

<font face=Courier New><SPAN style="color:#00007F">Private</SPAN> <SPAN style="color:#00007F">Sub</SPAN> Workbook_Open()<br>Application.ScreenUpdating = <SPAN style="color:#00007F">False</SPAN><br>Sheets("Log").Activate<br>Range("A2").Select<br><SPAN style="color:#00007F">Do</SPAN> <SPAN style="color:#00007F">Until</SPAN> ActiveCell.Value = ""<br>ActiveCell.Offset(1, 0).Select<br><SPAN style="color:#00007F">Loop</SPAN><br>ActiveCell.Value = Environ("UserName")<br>ActiveCell.Offset(0, 1) = <SPAN style="color:#00007F">Date</SPAN><br>ActiveCell.Offset(0, 2) = Time<br>Application.ScreenUpdating = <SPAN style="color:#00007F">True</SPAN><br><br><br><SPAN style="color:#00007F">End</SPAN> <SPAN style="color:#00007F">Sub</SPAN><br></FONT>

 

[amsdowns]

I appreciate it!!!