Checking to see if a paticular file is open or not
I have a VB6 program that opens an existing Excel workbook fill's in some data and then closes the Excel workbook. My problem is that if two people are using my program at the same time the program could be trying to open the same Excel workbook at the same time and this causes my program problems. Is there a way I can check to see if this paticular Excel sheet is open already by someone else prior to opening it for this user? The paticular Excel workbook is on a common drive that everone can access.