saving xla problem
Are you setting the 'IsAddin' property of the workbook object to true?
I am thinking that this needs to be done and saved for Excel to register the
change from workbook to Add-In.
HTH
Paul Smith
"ndalal" wrote in message
oups.com...
Hi,
I'm doing the following, but my excel workbook does not save xla:
1] Open excel workbook
2] Tools-Add-In XLA (made sure that XLA was added and seen in VBA
editor left pane)
3] Save workbook and close
4] Re-open the saved workbook and XLA is gone.
XLA does not get saved with excel workbook this way.Is this a bug in
excel?
However if I refer to my XLA using Tools-References from VBA editor
and save workbook,
close it and re-open it then the XLA is saved properly.
I dont understand why the first method does not work. Any response is
appreciated.
Thanks,
- Andy
|