How to save a project independent of a spreadsheet

[MP]

Hi,
I see no way to "Export" or "Save" a project.
The only option is Save the xls

How does one create standalone project that can be used in any spreadsheet?
Export only does individual module files...how to do the Project as a whole?

Thanks
mark

 

[Chip Pearson]

A project cannot exist outside of a XLS workbook. I think by "standalone",
you might mean an XLA add-in. An XLA isn't any more than a workbook having
an "XLA" extension rather than an "XLS" extension, and the IsAddIn property
is True.

Another type of add-in is called a COM Add-In. This is typically written in
VB6, VBNET, VC++, etc.

See http://www.cpearson.com/Excel/CreateAddIn.aspx for information about
creating and XLA add-in.

See http://www.cpearson.com/Excel/creatingcomaddin.aspx for information
about writing a COM Add-In.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel, 10 Years
Pearson Software Consulting
www.cpearson.com
(email on the web site)

 

[Bob Phillips]

You cannot, the project can only exist within a host container, such as
Excel.

You could create an addin, which is still a workbook, but with careful
coding you can use the procedures from any workbook.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[MP]

Thanks, looks like xla is what I was wondering about.
Thanks for the links, nice work.
Mark