How to save a project independent of a spreadsheet
 

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

How to save a project independent of a spreadsheet
 

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)



"MP" wrote in message
...
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

How to save a project independent of a spreadsheet
 

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" wrote in message
...
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

How to save a project independent of a spreadsheet
 

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

"Chip Pearson" wrote in message
...
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)



"MP" wrote in message
...
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