Save xla as xls?

  • Thread starter Thread starter MattShoreson
  • Start date Start date
M

MattShoreson

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
 
See one reply at your other post.

MattShoreson < said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

xla/xls help needed! 1
SAVE AS MACRO 6
SAVE AS MACRO 4
PLEASE HELP!! SAVE MACRO 2
.XLA's Code Not Available? 2
VBA Save 3
xlsm SaveAs xls 4
xla is opening the corresponding xls 2

Back
Top