Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Loading information from a VBA project to spreadsheet | Excel Programming | |||
how do i set up a 'moveable date' on a project spreadsheet? | Excel Discussion (Misc queries) | |||
Can I project an Excel spreadsheet without the menu bar? | Excel Discussion (Misc queries) | |||
Problem when attempting to save Workbook with VBA project protected | Excel Programming | |||
Locking VBA code via Project properties but cannot save the workbook over itself | Excel Programming |