ThisWorkbook.SaveAs not working?

Hi all,

I have this piece of code, which does copy the original sheet, and does generate a valid filename (sFileName). However, the save line isn't saving anything?

Any suggestions gratefully recieved..

Please Login or Register  to view this content.

Thanks,

Dave

Are you meant to be saving ThisWorkbook or the ActiveWorkbook ?

Good grief.

ActiveWorkbook of course.

Thanks DO.