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:
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:
Bookmarks