Run time error 76 "path not found"

[HisHailo]

Good day,

I am new to this and I was requested to execute the code for work however I get the following error (the code was not written by me), I need to fix this before Monday. I have tried everything I can think of with no luck please help. The code is supposed to automatically run when you open the spreadsheet however it generates the following error:

 

[John_w]

Welcome to MrExcel forums.

Does the C: drive exist?

I get error 76 "Path not found" with FilePath = "D:\tmp\Policy.txt" because my system doesn't have a D: drive.

OTOH I get error 53 "File not found" with FilePath = "C:\tmp\Policy.txt" because that file doesn't exist; the tmp folder also doesn't exist on C:.

 

[HisHailo]

Welcome to MrExcel forums.

Does the C: drive exist?

I get error 76 "Path not found" with FilePath = "D:\tmp\Policy.txt" because my system doesn't have a D: drive.

OTOH I get error 53 "File not found" with FilePath = "C:\tmp\Policy.txt" because that file doesn't exist; the tmp folder also doesn't exist on C:.

 

[HisHailo]

Hi John, yes mine does have a C: drive, I think the issue might be that "tmp" folder not existing.

 

[John_w]

My investigation suggests you would get a different error in that case, i.e. error 53 "File not found".

 

[HisHailo]

My investigation suggests you would get a different error in that case, i.e. error 53 "File not found".

I am honestly confused now because we do have the "C:drive" (see screen print below) what might then be issue:

 

[John_w]

Regardless of the different errors I posted, if the C:\tmp\ folder doesn't exist the macro would definitely cause an error. In fact, your "Path not found" error is more sensible than my "File not found" error because logically the Open statement is evaluating the C:\tmp\ path part first, before the whole C:\tmp\Policy.txt file.

Are you sure the folder is named 'tmp' and not 'temp'?