Forum Discussion
Help debbuging - I have checked the path, files names, etc. any help is appreciated.
Private Sub Workbook_Activate() End Sub Private Sub Workbook_BeforeClose(Cancel As Boolean) Workbooks("DONT DELETE.xls").Close SaveChanges:=False Kill "G:\Training Unit\Cadet Training\Unit Folder...
Run-time error '1001';
Microsoft Excel cannot access the file'G/traiing Unit\........
-The file name or path does not exist
-The fie is being used by another program
Microsoft Excel cannot access the file'G/traiing Unit\........
-The file name or path does not exist
-The fie is being used by another program
Could a workbook named DONT DELETE.xls exist in the specified folder?
Or is DONT DELETE.xls the name of the workbook in which the code is running?
- I believe the "Could a workbook named DONT DELETE.xls exist in the specified folder?" is the issue. I need to confirm the file exists.
That is a private folder that i have requested access to.