Run time Error '76' in excel

Question

Run time Error '76' in excel

Anonymous

I have to fill one form which is in excel.

Excel file type is Microsoft Excel Binary Worksheet.

In that file after filling all information there is tab in excel to validate.

After validating that file "txt" file get generate.

While we are doing the validation process it display error - run time error '76' Path not found.

We have already enabled the macro but issue not yet solved.

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

4 answers

Answer 1

Andreas Killer 144.1K Volunteer Moderator

RTE 76 in VBA means there is some VBA code that access a path that doesn't exist. This has nothing to do with the security settings.

If you need further help I need to see your (sample) file.
Why a sample file is important for troubleshooting. How to do it. - Microsoft Community

Andreas.

0 comments

Answer 2

ThisWorkbook.Path can be empty in a new file when the created file is not saved.

The ActiveCell can also be empty or can contain invalid chars, e.g. "*" which are not allowed in a path.

MkDir works on locale drives only and you can create only one folder at a time. It is not possible to have "a\b\c" in the cell and create all that folders at a time.

And as you mentioned OneDrive, you can not create folders at online file locations where the path might be "http:\ etc."

Andreas.

Answer 3

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more

Answer 4

Hi Andreas please I need your help with the same error, I dont know what else do.

"Sub crearcarpeta()

Dim ruta As String 

ruta = ThisWorkbook.Path & "\" & ActiveCell.Value 

MkDir ruta

End Sub"

I tried with the most simple code that I can do, but have the same error 76

I´m synchronize with my one drive.