BeforeSave Crashes Excel

Try:

Please Login or Register  to view this content.

Thanks zbor, I gave that a go and it still didn't work. So I've stripped right back to basics and got rid of everything other than the following:

Please Login or Register  to view this content.

It saves the file with the correct file name, but crashes Excel

I think it's because I'm trying to save within beforesave, thus creating some kind of loop...so what I really need to do is pass the filename to the inbuilt save

---------- Post added at 08:08 AM ---------- Previous post was at 08:01 AM ----------

So, just to prove that saying the problem out loud (or at least on the Internet) can be the thing that fixes it, I've sorted it:

Please Login or Register  to view this content.