In my continuing quest to use excel for saving QA data for a contact center, I have a scoring sheet called "observations" that supervisors can use for scoring a call.

At the end of the sheet is a button that saves the data to anotehr sheet in the same workbook called "Sheet1".

Here is the code that does this:

Please Login or Register  to view this content.
That is all working - finally.

Now that I'm ready to actually make use of the sheet, I would like the data saved to a workbook on a shared network drive so that every supervisor can have a copy of the sheet running at their desk, and when they click the save button, instead of saving locally, it saves the data to:

s:\qadata\data.xls on sheet1

I've been making changes to this line:
Set ShB = Worksheets("Sheet1")

But have so far been unsuccessful.

I'm really struggling with the syntax to do this - any suggestions??