I have an addin which has a couple of worksheets and a code module a
the basis of a new file.

I would like the addin to save these 3 items as a new file but when
use something like...

ThisWorkbook.SaveAs Filename:="BalanceSheet.xls"
FileFormat:=xlWorkbookNormal

It saves the file as an xls fine but retains the property...

IsAddin = True

Can I set this to false when saving or does it have to be done anothe
way?

Rgds,
Matt

--
Message posted from http://www.ExcelForum.com

See one reply at your other post.

"MattShoreson <" wrote:

I have an addin which has a couple of worksheets and a code module as
the basis of a new file.

I would like the addin to save these 3 items as a new file but when I
use something like...

ThisWorkbook.SaveAs Filename:="BalanceSheet.xls",
FileFormat:=xlWorkbookNormal

It saves the file as an xls fine but retains the property...

IsAddin = True

Can I set this to false when saving or does it have to be done another
way?

Rgds,
Matt.

---
Message posted from http://www.ExcelForum.com/

--

Dave Peterson