File/Path Access Error (Error 75)

[AlanAnderson]

Hi,

On ocasion I am getting the above error. It does NOT occur during the actual running of the programme but seems to randomly occur while I have the VBA open. It often occurs even when I've left machine unattended for hours. The warning message appears with a Help and a OK button. If one presses OK repeatedly it eventually shows following different message. "MS Visual Basic. System Error &H8000FFFF (-2147418113)

Only way out of this is Cntrl Alt Del

VBA help indicates it is a problem related to "Open", "RmDir", "MkDir", "ChDir".
Problem is the only one of these commands used is :

sWb = Application.GetOpenFilename(sFil, iFilterIndex, sTitle)

and

Workbooks.Open FileName:=sWb

These are used when starting up system. If there was a fault here I surely wouldn't even have been able to load up programme.
Only other place open used is in the following routine which is only called by selecting it from a menu and I have not been near that option for months.

Application.Workbooks.Open (FullName)

As this only seems to happen whilst in VBA is this something I can just live with or could this turn into a problem when being run by clients?

Regards,

Alan

 

[daverunt]

This guy had a problem with the file trying to autosave to a network drive and failing when it couldn't causing the crash.

http://www.vbforums.com/showthread.php?t=500971

Some other links on the subject.
http://www.wiredbox.net/Forum/Thread256609_system_errror_H8000FFFF.aspx

 

[AlanAnderson]

Hi Dave,

Thanks for this. What that guy described is almost exactly the same as my problem.

BUT !!!!

I am not using a network drive. Certainly it does not happen when I'm opening, closing or saving a file. Reading his issue leads me to think that perhaps it is happening when Excel does it's autosave.

However, if it does not fall over during an ordinary save why would autosave be any different.

Confused and perplexed!!


Regards,

Alan

 

[daverunt]

Save and Autorecovery are different.

The term 'autosave' is probably being abused.

http://support.microsoft.com/kb/289273

Early versions of Excel used to have an autosave add-in that incrementally saved the file at defined times.

Autorecovery in the later versions saves recovery information for the file at the defined time periods in (default location).
C:\Documents and Settings\User Name\Application Data\Microsoft\Excel

and this sort of format.
~ar7DFC.xar
It is deleted when the file closes if there were no problems.
I'm not sure a recovery file is created if the opened file doesn't change?

Google the error as you have typed it here. It is a not uncommon problem going back many versions in all Office programs.
Maybe an add-in problem.

 

[AlanAnderson]

Hi Dave,

Thanks again for your ongoing interest and help. With your help I think I am getting somewhere.

Firstly, I doubt that it is Autorecovery "on its own" that's causing problem. I have been watching carefully and its been doing its thing every ten minutes without once falling over at that point.
However your remark about add ins may well be the issue.
As far as I know this problem is only occurring on my development machine and not on the other machines I have here.

The major difference is that the development machine has the following add ins:

ExTools ver 2.0.5
Enhanced DataForm v3A
Ejhtml4-En (Excel Jeannie

Any ideas??

Regards,

Alan

 

[daverunt]

No, apart from unchecking the Add-ins and see what happens. Add them back one at a time.

What Excel version is on your machine and are the others the same?

 

[AlanAnderson]

Hi Dave,

Have removed two ( ExTools ver 2.0.5 and Enhanced DataForm v3A) and thus far - problem has not re-appeared. I'll have to wait a while as the problem has not been predictable or consistent. I strongly believe it to be solved though (Holding thumbs)

Thanks a million for the help - it had not even occurred to me to look at add ins.

Thanks

Alan

 

[daverunt]

I hope it's solved too.

can you post back when you have identified which add-in you are fairly certain is the cause for the benefit of others, which Excel version it appears in.