Error Excel 2007 cannot access file "~ar28CE.xar"

[HorseGoose]

Hello

I have a program which has been running on excel 2003 and has been migrated to 2007. Most things are working fine except.

When the program is left open for a while it returns the following error.

Microsoft excel canot find the following file "path\~ar28CE.xar"

When the user clicks OK a second info box says

An unexpected error has occured. Auto recover has been disabled for this session of excel.

My question is, what is the file that the program is looking for? I dont reference this file in the code, it must be something to do with excel. That said it is always to be found in the documents and settings fodler for the individual user.

I cannot show you the code as the program is pretty large and I don't exactly where the error is happening. It a`appears to be random.

Thanks

HG

Does anyone have any ideas?

 

[strongm]

>it must be something to do with excel

It is an Excel autorecover file, as the error dialog tries to hint.

AutoRecover, if active, automatically saves your open files on a regular basis (normally every 10 mins). The file is saved as a hidden file with an arbitrary filename with the extension .XAR (for example, ~ar28CE.xar).

Now, as to why Excel cannot find the file ... well, that's more troublesome. Can you tell us what <path> is in the first error message? And what OS you are runnning on.

 

[HorseGoose]

Thanks Strongm.

OS is XP Pro. 2002 SP3

Path is the documents and settings for that user files then excel.

Thats a great help though, I have disabled the autorecover function as it is not needed for this application. Thanks.

HG