Thanks that did it, I was using:

....saveas(FileToBeSaved,ExcelConstant)
Dropping the filename worked

Thanks again