Hi, sgolwalkar4ever,

SaveAs-Option, it should be very much down the scale (*.xlam for 2007 on, *.xls until 2003). Please mind that no Sheets in AddIn will be visible, that you need to embed an Addin via the AddIn-Manager, that code has been tested thoroughly...

Ciao,
Holger