Permalink
| title | keywords | f1_keywords | ms.prod | ms.assetid | ms.date | ms.localizationpriority |
|---|---|---|---|---|---|---|
|
Path not found (Error 76) |
vblr6.chm50035 |
vblr6.chm50035 |
office |
8a75c288-c9c4-2c4a-a58a-f6fbaa9b3896 |
06/08/2017 |
medium |
The path to a file includes the drive specification plus the directories and subdirectories that must be traversed to locate the file. A path can be relative or absolute. This error has the following cause and solution:
- During a file-access or disk-access operation, for example, Open, MkDir, ChDir, or RmDir, the operating system was unable to find the specified path. Respecify the path.
For additional information, select the item in question and press F1 (in Windows) or HELP (on the Macintosh).
[!includeSupport and feedback]
I have this Error Message, i’m completely lost…
I think I checked everything that could be wrong, maybe one of you guys can see a mistake or something. My brain is now completely blocked.
Thanks in advance
Option Explicit
Public newestFile As Object
Sub Scan_Click()
Dim path As String
Dim row As Integer: row = 2
Dim ws As Worksheet
Set ws = ThisWorkbook.Sheets("ETA File Server")
With ws
Do
If .Cells(row, 1).Value = "" Then Exit Do
path = .Cells(row, 1).Value
Application.StatusBar = "Processing folder " & path
DoEvents
If .Cells(row, 1).Value <> "Root" Then
Call getNewestFile(path)
.Cells(row, 9).Value = newestFile.DateLastModified
.Cells(row, 10).Value = newestFile.Name
Set newestFile = Nothing
row = row + 1
Else
row = row + 1
End If
Loop
End With
Application.StatusBar = "Done"
End Sub
Private Sub getNewestFile(folderpath As String)
Dim objFSO As Object, objFolder As Object, objFile As Object
'get the filesystem object from the system
Set objFSO = CreateObject("Scripting.FileSystemObject")
Set objFolder = objFSO.GetFolder(folderpath)
'go through the subfolder and call itself
For Each objFile In objFolder.SubFolders
Call getNewestFile(objFile.path)
DoEvents
Next
For Each objFile In objFolder.Files
If newestFile Is Nothing Then
Set newestFile = objFile
ElseIf objFile.DateLastModified > newestFile.DateLastModified Then
Set newestFile = objFile
End If
Next
End Sub
asked Oct 22, 2013 at 7:27
6
I get this error when the file I am trying to reach is in SharePoint.
As a workaround what I do is I will open that link in Explorer view (SharePoint link — Library — Connect & Export — Open with Explorer). Once I have the SP in explorer view it functions smoothly.
To resolve this we have to map that SP link into a drive and call the drive address instead of SP link.
Link for that — Get the content of a sharepoint folder with Excel VBA
answered Nov 23, 2018 at 12:27
Allright I found an answer! Windows can only handle paths under 255 characters.
So all you have to do is add \? before a path, for example \?c:users on server adressen you have to add \?unc —> \?uncservernamepath
Hope that helps you out!
Dominique
16.3k15 gold badges54 silver badges106 bronze badges
answered Oct 25, 2013 at 8:54
ChrisChris
531 gold badge1 silver badge6 bronze badges
It could be caused by the long file name due to extensive folder & subfolder of a file to be copied.
Try reduce the length of the name of all the folders / subfolders before you copy.
It solve my problem, hope solving yours too.
Regards,
answered Jun 2, 2015 at 6:55
I had exactly the same symptom, but un-understandibly, I could make the symptom go away by unchecking «Run as administrator» for the shortcut that starts the app :
Maybe this is helpful for people experiencing the same symptom, and nothing else helped.
answered Sep 7, 2020 at 14:00
TheBlastOneTheBlastOne
4,2913 gold badges37 silver badges72 bronze badges
|
microsoft visual basic run-time error 76 path not found |
||||||||
Ответить |
||||||||
Ответить |
||||||||
Ответить |
||||||||
Ответить |
Hello
I use an excel Macro that creates a report and saves it to a file in a network drive. If I use the Macro in the excel file everything works fine. The problem exist when i try to use the macro from the personal workbook i get the following error Run-time Error: ’76’ Path Not Found. The codes are identical in both macros.
Here is the code where I get the error.
Function AssignCenterDailyReportFile(ReportsDirectory As String, ReportSearchHint As String) As Variant
‘Need code here to search for what should be the already present monthly .xls report file
‘If the file isn’t found, need to create a new monthly file based on a template
Application.ScreenUpdating = False
Application.DisplayAlerts = False
Application.EnableEvents = False
Dim sNewFilename As String
Dim iMonth As Integer
Dim strarMonths(1 To 12) As String
Dim objFile As Object
Dim objFolder As Object
Dim iFoundCount As Integer
Dim objFileSystem As New Scripting.FileSystemObject
Dim sReportFileToAssign As String
Set objFileSystem = CreateObject(«»Scripting.FileSystemObject»»)
Set objFolder = objFileSystem.GetFolder(ReportsDirectory)
iFoundCount = 0
For Each objFile In objFolder.Files
If Mid(objFile.Name, 1, 2) = Mid(ReportSearchHint, 1, 2) Then
iFoundCount = iFoundCount + 1
sReportFileToAssign = objFile.Name
End If
Next
‘Found the report file starting with the 2 digit month (zero lead)
If iFoundCount = 1 Then
AssignCenterDailyReportFile = sReportFileToAssign
‘Didn’t find the report file, have to create a new one based on the template
ElseIf iFoundCount = 0 Then
strarMonths(1) = «» Jan»»
strarMonths(2) = «» Feb»»
strarMonths(3) = «» Mar»»
strarMonths(4) = «» Apr»»
strarMonths(5) = «» May»»
strarMonths(6) = «» Jun»»
strarMonths(7) = «» Jul»»
strarMonths(8) = «» Aug»»
strarMonths(9) = «» Sep»»
strarMonths(10) = «» Oct»»
strarMonths(11) = «» Nov»»
strarMonths(12) = «» Dec»»
iMonth = Int(Val(ReportSearchHint))
sNewFilename = ReportSearchHint & strarMonths(iMonth) & «».xls»»
FileCopy ReportsDirectory & «»»» & «»DONT_DELETE»» & «»CenterDailyTemplate.xls»», ReportsDirectory & «»»» & sNewFilename
AssignCenterDailyReportFile = sNewFilename
‘Shouldn’t get here, means more than one report file starting with the same 2 digit code was found
Else: AssignCenterDailyReportFile = CVErr(xlErrNA)
End If
Application.ScreenUpdating = True
Application.DisplayAlerts = True
Application.EnableEvents = True
End Function
The line containing Set objFolder = objFileSystem.GetFolder(ReportsDirectory)is highlighted indicating the error. Thanks in advance for any suggestions.
Read these next…
Laptop screen went black — can’t find the cause/ solution!
Hardware
Hi guys, I’m new here and really hope I can get some help :)I was using my laptop normally (Samsung np-sa31, Bremen — M motherboard), I turned it off, by pressing the power button and then closing the lid if I remember correctly since I was in a hurry…
O365 Emails Issue?
Cloud Computing & SaaS
Client in question has 18 O365 email users/mailboxes with MS Business Standard license.In the last 2 to 3 weeks a few users that are using certain business website where they login to these website are having issues creating new logins or resetting the pw…
Snap! — Brain Video, Mosquito-proof Cloth, Sound-Induced Torpor, Nugget Tetris
Spiceworks Originals
Your daily dose of tech news, in brief.
Welcome to the Snap!
Flashback: May 26, 1949: Howard Cunningham was born, the American programmer who developed the first wiki (Read more HERE.)
Bonus Flashback: May 26, 1969: Apollo 10 returns to e…
Bringing IT Infrastructure back in house
Best Practices & General IT
I started with a new company and they want to bring their IT Infrastructure back in house from the MSP they are using. What’s the best procedure to do this and what’s a good management platform to use to mange theses devices?
Finding remote IT work in Europe
IT & Tech Careers
I’m looking for advise for finding remote English speaking IT work in Europe.If you know of any job notice board that specialise in remote work what are they?And any other bits of advice.
Attention Before you read this post, I highly recommend you check out my resources page for access to the tools and services I use to not only maintain my system but also fix all my computer errors, by clicking here!
In the vast majority of cases, having some background understanding of the error, will go a long way in helping you resolve it. In this tutorial, I’ll be discussing runtime error 76, what it is, and how to fix it.
Runtime error 76 typically occurs when the computer is unable to read a file it requires, either due to it being corrupted, unregistered or erased. A good example of this, would be if the end user installed Microsoft Word, and somehow, a file, critical to its functionality was erased, as a result, when the end user attempted to run the program, the computer system would try to load, specific files, required by the program, eventually halting, because of its inability to locate the culprit file.
What Causes Runtime Error 76?
This particular error, when it occurs, is displayed in the following fashion:
Runtime Error 76:
Path Not Found
As previously stated, the error occurs, when the computer is unable to locate and/or load the required file to carry out whichever action you want it to.
The cause may include the following:
- The required file has been accidently deleted, by the installation or uninstallation of a program.
- There is a DLL file conflict between one or more programs installed on your system.
- A virus has infiltrated your system and corrupted important system files.
- The Windows registry has been corrupted.
When it comes to resolving this issue, it’s a simple matter of tackling the cause, rather than the error itself.
How to Fix It
The good thing about all of this, is that it is possible to repair runtime error 76, with the approach taken, being most important.
The first thing you’ll want to do is ensure the culprit application is running, along with any associated files and settings.
All of this will be explained below, so I recommend you continue reading, for those much needed solutions.
Run a Registry Scan
One of the most common causes of system errors, which includes runtime error 76, is the corruption of the Windows registry. If you don’t know what the registry is, it’s basically a central database system, used for storing all the most important data, such as hardware and software settings information.
However, despite the obvious importance of this Windows component, it is highly susceptible to corruption, due to a plethora of reasons. When the registry becomes corrupt, it can adversely affect your operating system, preventing specific Windows features, applications and hardware components from working properly or at all.
However, it is possible to repair the registry, providing you use a professional registry cleaner tool like Advanced System Repair Pro. This tool will scan the registry and remove and/or repair any infractions that it finds.
You can learn more about how Advanced System Repair Pro can help you, form the link below:
CLICK HERE TO CHECK OUT ADVANCED SYSTEM REPAIR PRO
Run a Virus Scan
Another known cause for runtime error 76, is the corruption of the culprit file. This corruption can be caused by many different things, with a virus, being right up there as the most probable.
Thus, I’d recommend you ran a full scan of your system using your own Internet Security solution. However, if you do not have any real security, or if you’re currently dissatisfied with your current solution, then I’d recommend SpyHunter, which is the very best antimalware tool available right now.
SpyHunter is capable of removing a plethora of virus types, while restoring previously damaged components.
With that said, I suggest you check the link below:
CLICK HERE TO CHECK OUT SPYHUNTER
Repair Installation
Sometimes, the error isn’t the result of a corrupt file, but the corruption of the entire operating system. In situations like this, you’ll need to run a repair installation to fix it.
So, if you have your Windows CD, I’d suggest you carried that out. However, if you do not, which is quite common nowadays, then I’d suggest you used Reimage, which is a Windows repair tool, capable of reinstalling your operating system, on the fly, without the requirement of an OS Windows CD.
You can learn more about Reimage, and its many benefits from the link below:
CLICK HERE TO CHECK OUT REIMAGE
The solution(s) below are for ADVANCED level computer users. If you are a beginner to intermediate computer user, I highly recommend you use the automated tool(s) above!Reinstall Culprit Application
If all of the solutions above, fail to repair runtime error 76 (which is highly unlikely), then you may want to start with checking the culprit application, that is, the application that is causing the error to manifest.
What you’ll want to do is run a repair installation of that program. This can be done, several ways. The first, is by doing the following:
1. First, boot into your computer with administrative rights.
2. Then press 
+ R, type Appwiz.cpl and click on OK.
3. When Add or Remove a Program loads up, click on the Application, then click on Change, and follow the onscreen instructions to repair the current installation.
Note: Not every application has this feature.
The second option is simply to reinstall the application using the installation CD. This is probably your best option, as you’d be better off uninstalling the application.
The software removal, is probably the most important aspect of the process, you want to ensure that every trace of the application is removed, before you reinstall it, that way, any issues that existed prior, will not be inherited when you put the program back.
It’s for this reason why I recommend the use of a professional uninstaller tool, like Express Uninstaller, that is capable of not just removing the tool from your Program Files folder, but also removing it from your Common Files and AppData folders and the registry.
You can learn more about Express Uninstaller from the link below:
CLICK HERE TO CHECK OUT EXPRESS UNINSTALLER
Replace Missing File
This next method of fixing runtime error 76, entails replacing the specified file. The file that is missing should display in the error message.
To replace the file, you will need to find an alternative, however this can vary, depending on the type of file, whether it’s a program file or an operating system file.
If the file is an application file, then you should be able to find it on the programs installation CD. Simply load the CD into your CD-ROM drive and locate it on there.
Once done, copy and paste it to your installation (Program Files) folder.
The success of this method is dependent on the availability of the specified file.
Update Windows
If all the solutions up to this point have failed to repair runtime error 76, it could very well be the case, that the error is the result of an outdated operating system. It’s important that you regularly update your operating system so that it is constantly receiving the latest patches and security updates.
To update Windows on the fly, just do the following:
1. Boot into your computer with administrative rights.
2. Then press + R, type wuauclt.exe /updatenow and click on OK.
There may be known conflicts between specific applications currently on your system. Microsoft is constantly working to eliminate these conflicts with every Windows update release. This is why it’s so important you keep things up-to-date.
Are you looking for a way to repair all the errors on your computer?
If the answer is Yes, then I highly recommend you check out Advanced System Repair Pro.
Which is the leading registry cleaner program online that is able to cure your system from a number of different ailments such as Windows Installer Errors, Runtime Errors, Malicious Software, Spyware, System Freezing, Active Malware, Blue Screen of Death Errors, Rundll Errors, Slow Erratic Computer Performance, ActiveX Errors and much more. Click here to check it out NOW!