excel 2007 runtime error 75 Chazy New York

Address 42 Nightengale Dr, Plattsburgh, NY 12901
Phone (518) 314-9713
Website Link
Hours

excel 2007 runtime error 75 Chazy, New York

Let me know on any of these. If you DON'T lock it back, it comes up with this error. Below is the Code I'm using: VB: Private Sub Workbook_Open() Dim ff As Long Application.ScreenUpdating = False Application.DisplayAlerts = False On Error Goto netcon ff = FreeFile() Open "\\fileshares.corp\groups\RAPID_REPORTS\logs\log.inf" For Append In my case, the "x" box is locked out from the user, and closing, opening and pretty much all else is under vba control.

Go to Sheet2 and Sheet3 and do the same. However, some users (Excel 2010/ Windows 7) get the run time Error 75 - Path/ File Access Error. Can I email it to you direct 0 LVL 41 Overall: Level 41 MS Excel 41 Message Expert Comment by:dlmille2012-02-08 I think that would be ok, but we'll need to Thanks ipisorsView Member Profile Oct 3 2012, 06:09 PM Post#2BannedPosts: 9,239Joined: 21-June 07I don't think there's any reason to believe it's a problem with anything other than, the code literally is

Yep, the Code Cleaner is a goody. Advanced Search Forum HELP FORUMS Excel General Run-Time Error 75 on Excel 2010/ Windows 7 while opening Text File Excel Training / Excel Dashboards Reports If this is your first visit, However, the code works fine if the same file is placed locally on the user's system ( the file path changed of course). My code was failing because the ontime routine was saving the workbook periodically and any attempt to save the workbook after the path/file access error instantly causes the workbook to crash.

Click Disable Events Now, open that pesky workbook, unlock the password and look at the code. How to Fix Runtime Errors How to Fix Runtime Error 13 How to Fix Runtime Error 75 How to Fix Runtime Error 91 How to Fix Runtime Error 216 How to Any path that isn't fully qualified is relative to the current drive and directory. From what I have read about error 75 it looks like Excel is unable to find/ does not have access to one of the files that VBA needs to run the

Yes, it's still happening, sporadically, but I can't seem to generate it at will. regards, Dave Dave Unger View Public Profile View message headers Find all posts by Dave Unger Find all threads started by Dave Unger #8 January 9th 10, 07:09 PM You may have to register before you can post: click the register link above to proceed. Dave 0 LVL 1 Overall: Level 1 MS Excel 1 Message Author Comment by:Bunchil2012-02-08 Thanks Dave, the file is on its way and I have no problem about posting the

http://www.formulasoft.com/vba-code-compare.html hth Rob 0 LVL 10 Overall: Level 10 MS Excel 10 Software-Other 1 Message Active 6 days ago Expert Comment by:broro1832012-02-09 hi Dave, There should be an email on The second works without error. You could also open the workbook, unlock the password and check for all this before saving, as it appears you can see the code before saving - so see if its Change the read-only attribute of the target file or save the file with a different file name.

Have you also tried with the (text) file being saved in a different location? Powered by vBulletin® Version 4.1.8 Copyright © 2012 vBulletin Solutions, Inc. Does everything work? To start viewing messages, select the forum that you want to visit from the selection below.

if the user clicks cancel, the routine returns an empty filename. I suggest this because some of the changes are not in the visible text shown within the VBE. The code I use for both is as follows: would working with the API calls create the problem? The forms and modules are also inside the workbook.

Click here to view the relaunched Ozgrid newsletter. saved the file as same name 5. I thought it might have been at the top of Dave's list to try which is why I only mentioned it briefly. :-) Actually, it should be but you know how Sorry again, Saiju Paul C Excel Video Tutorials / Excel Dashboards Reports Reply With Quote Quick Navigation Excel General Top Site Areas Settings Private Messages Subscriptions Who's Online Search Forums: Forums

Can't find any code that would be addressing an invalid path via dir/open/etc., nor anything that appears to be wanting to interface the VBA Project. Fixing network runtime 75 errors is a bit tricky as there are so many variables. Let's say I have forms A, B, C, D, E in the vba object list. Dave Unger View Public Profile View message headers Find all posts by Dave Unger Find all threads started by Dave Unger Ads #2 January 7th 10, 10:09 AM posted

Subscribe to our monthly newsletter for tech news and trends Membership How it Works Gigs Live Careers Plans and Pricing For Business Become an Expert Resource Center About Us Who We Rob 0 LVL 41 Overall: Level 41 MS Excel 41 Message Expert Comment by:dlmille2012-02-09 >>Yep, the Code Cleaner is a goody. Bpth machines are running Office 2007 Home & Student. I checked memory usage on task manager and it does increase a little over time but the crash happens way before any memory gets used up.

Join our community for more solutions or to ask questions. Don't get me wrong - Excel 2007 is a buggy piece of **** in my opinion and I try never to use it, but I am not convinced that that is Regards, Saiju Paul C Excel Video Tutorials / Excel Dashboards Reports Reply With Quote June 29th, 2012 #4 Saiju Paul C View Profile View Forum Posts I agreed to these rules Check to see if the server or computer hosting the required file is online.

I think lots of code editing such as copy & pasting can cause some crap to be left in the "invisible" lines of code until the code is exported & re-imported. Share it with others Like this thread? The only other thing I can suggest that you might try is not using the default instancing of the forms - declare a variable and use that, then destroy the variable On Opening you have to click the Live Score option to start the timer.

If you can show this to be a replicable bug (a demo workbook would be ideal) under a specific OS, then I will file it as a bug, though I cannot In this example from my system, the first command triggers that same error #75. Solved Path/file access error - runtime error 75 - lost visual basic project Posted on 2012-02-07 MS Excel Software-Other 1 Verified Solution 24 Comments 4,344 Views Last Modified: 2012-03-25 I have Thank you Dave!

Try your operation again, but save as the same name (after having made a backup).Dave 0 LVL 80 Overall: Level 80 MS Excel 75 Software-Other 12 Message Active today Expert You may have to register before you can post: click the register link above to proceed. Hi Robert, I started having similar problems quite recently (Run Time Error 75" ("Could Not Find The Specified Object"), seems to happen sporadically when vba is trying to reference a form Robert C.