SteveInAlabama
Board Regular
- Joined
- Aug 22, 2002
- Messages
- 94
Thanks in advance for any ideas/help you might have.
I have six identical PC's on the plant floor, all using the same spreadsheet file as a template to send test data to a database. The source spreadsheet is on a read-only directory of a server. They use a short-cut (.LNK) to get the spreadsheet and file.
I have the following code to close everything down if they need to run something else:
Private Sub Workbook_BeforeClose(Cancel) as Boolean
ThisWorkbook.Saved = True
Application.Quit
End Sub
Works fine on the 1st PC set up to access the file. But sometimes on the 2nd, and always on the rest, the msg comes up asking the operator "Do you want to Save: Yes, No, or Cancel".
Are they interacting? I tried ActiveWorkbook instead of ThisWorkbook, but it doesn't act any different. I even tried copying the template spreadsheet file to the local drive of one of the boxes and running it from there, but it still asked about saving. Now I'm really confused...
I have six identical PC's on the plant floor, all using the same spreadsheet file as a template to send test data to a database. The source spreadsheet is on a read-only directory of a server. They use a short-cut (.LNK) to get the spreadsheet and file.
I have the following code to close everything down if they need to run something else:
Private Sub Workbook_BeforeClose(Cancel) as Boolean
ThisWorkbook.Saved = True
Application.Quit
End Sub
Works fine on the 1st PC set up to access the file. But sometimes on the 2nd, and always on the rest, the msg comes up asking the operator "Do you want to Save: Yes, No, or Cancel".
Are they interacting? I tried ActiveWorkbook instead of ThisWorkbook, but it doesn't act any different. I even tried copying the template spreadsheet file to the local drive of one of the boxes and running it from there, but it still asked about saving. Now I'm really confused...