Excel 2010 Runtime Error 76 Path Not Found
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might runtime error 76 path not found visual basic have Meta Discuss the workings and policies of this site About runtime error 76 path not found windows xp Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads runtime error 32809 excel 2010 with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million runtime error 1004 excel 2010 programmers, just like you, helping each other. Join them; it only takes a minute: Sign up Runtime Error 76 Path not found up vote 1 down vote favorite 1 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
Runtime Error 76 Vba
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 = objFi
be down. Please try the request again. Your cache administrator is webmaster. Generated Sat, 15 Oct 2016 07:27:53 GMT by s_wx1094 (squid/3.5.20)
Path Not Found If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, http://www.vbforums.com/showthread.php?509453-RESOLVED-Run-time-error-76-Path-Not-Found select the forum that you want to visit from the selection below. Results 1 to 9 of 9 Thread: [RESOLVED] Run-time error '76': Path Not Found Tweet Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Feb 17th, 2008,08:03 AM #1 muzamilsumra View Profile View Forum Posts Thread Starter Lively Member Join Date Feb 2008 Posts 91 [RESOLVED] Run-time error '76': Path Not Found Hello Guys, runtime error Can someone help me please? Actually i have made an app using visual basic 6 that edits some files in a specific folder in drive c. In my computer it does everything fine...but when i try it another computers it gives me an error "Run-time error '76': Path Not Found"... but the files tht it has to acces are in the same drive where they shud b but still it givs me this error... any help would runtime error 76 be appreciated.. Thx. Reply With Quote Feb 17th, 2008,08:15 AM #2 CDRIVE View Profile View Forum Posts PowerPoster Join Date Jul 2007 Posts 2,540 Re: Run-time error '76': Path Not Found You say it's on the same drive, but what about the Path? <--- Did someone help you? Please rate their post. The little green squares make us feel really smart! If topic has been resolved, please pull down the Thread Tools & mark it Resolved. Is VB consuming your life, and is that a bad thing?? Reply With Quote Feb 17th, 2008,08:47 AM #3 muzamilsumra View Profile View Forum Posts Thread Starter Lively Member Join Date Feb 2008 Posts 91 Re: Run-time error '76': Path Not Found well the path is correct to bro :S... Reply With Quote Feb 17th, 2008,09:43 AM #4 MartinLiss View Profile View Forum Posts Former Admin/Moderator Join Date Sep 1999 Location San Jose, CA Posts 32,948 Re: Run-time error '76': Path Not Found Did you install your program on the other PC or did you just copy the exe? Do not worry about your difficulties in Mathematics. I can assure you mine are still greater. Albert EinsteinTips, Examples & Tutorials: A valuable forum tool • Generate unique TreeView keys • TreeView with "open" and "closed folder" icons • Time code using GetTickCount • How to trap the Tab key • Scroll a form