I'm glad you solved your problem. But I'd keep an eye open for it to recur.

(I've got a funny feeling your fix was a coincidence--but I've been wrong
before--lots of times!)



viaene wrote:

Thanks for looking at this problem. It didn't have something to do
with the antivirus either, but I managed to solve my problem. In the
VBA code I created a long string with severel line continuations.
Although the compiler didn't give any problems, and the code worked
OK, this was creating the problem. After 10 line continuations I used
a string concatination. Now the file is saving just fine and I could
delete the 'strange' files, although I still have no idea why this
happens.

Dave Peterson wrote in message ...
How about the Antivirus program? Did you try disabling it to test?



viaene wrote:

Thanks for the info, but I don't think that's my problem. It's not
even the case that I save the excel file from within the VBA code. I
have this problem when I just hit the save button in the excel
toolbar, after I closed the visual basic editor, or even when I never
opened it and just save the file without making any changes. Also I
don't think there's a permissions problem because the file is on a
network folder and I have no problem, reading, writing or deleting in
the folder.
I really have to get this issue solved, HELP!!

Many Thanks

--

Dave Peterson