It could be a number of things: different version of Windows, Excel, or who knows. Something to keep in mind is that if you changed my code above to be more like the code below you will need the err.number to be 71.
Private Sub Worksheet_Activate()
On Error GoTo errHandler
Open...
Below is a VBA code example that works in Excel to check if a disk is in drive 'A' before saving the workbook. If there is not, it checks to see if the user would like to try to save to disk again; meaning that the user has put a disk in the drive. However, the user can choose not to try again...
Below is a example that will work in VB6. It is better to use the CreateProcess API call but that is pretty complex. I hope this works for you.
Private Sub Form_Load()
Dim temp As String, tmp As String
Shell "dos_program > c:\output.txt", vbHide
MsgBox "Do not click...