Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recommend: object intermediate between Application and Project
At present there is no object intermediate between Application (Excel) and
Project. It would be nice if there were a new object, "Planet" under which would be Projects. Each Planet would have its own subset of Projects. Then if one booted up Excel, say holding down the Shift Key, one would be given the choice of which Planet he wished to open with. One Planet might be "Manage Stock Portfolio" which would include all the projects used in Planet "Manage Stock Portfolio". Another planet might be "Solve Quadratic Equations" which would include all projects and worksheets, etc for this planet. One would then have the capability of exporting modules from one Planet and importing them into the others if so desired. Obviously this is very useful when the functions of some Planets are totally unrelated to the functions of the other Planets. The only way to currently accomplish this is to have two separate installations of Excel which is very wasteful of resources. I hope this suggestion will lead to other suggestions leading to a more flexible Excel. Please feel free to let me know of other ways to accomplish this, or any questions you might have. -- May you have a most blessed day! Sincerely, Michael Fitzpatrick ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/communities...el.programming |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recommend: object intermediate between Application and Project
hi
in xl help, look up workspace. it tells you how to devide your projects up into planets. Regards FSt1 "MichaelDavid" wrote: At present there is no object intermediate between Application (Excel) and Project. It would be nice if there were a new object, "Planet" under which would be Projects. Each Planet would have its own subset of Projects. Then if one booted up Excel, say holding down the Shift Key, one would be given the choice of which Planet he wished to open with. One Planet might be "Manage Stock Portfolio" which would include all the projects used in Planet "Manage Stock Portfolio". Another planet might be "Solve Quadratic Equations" which would include all projects and worksheets, etc for this planet. One would then have the capability of exporting modules from one Planet and importing them into the others if so desired. Obviously this is very useful when the functions of some Planets are totally unrelated to the functions of the other Planets. The only way to currently accomplish this is to have two separate installations of Excel which is very wasteful of resources. I hope this suggestion will lead to other suggestions leading to a more flexible Excel. Please feel free to let me know of other ways to accomplish this, or any questions you might have. -- May you have a most blessed day! Sincerely, Michael Fitzpatrick ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/communities...el.programming |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Recommend: object intermediate between Application and Project
Greetings! Thanks for your response. I tried your suggestion. I saved my
existing setup (consisting of 2 Projects and a Personal Workbook) as Insider Workspace, and setup a new workspace called New Workspace which just has a blank workbook. I opened the New Workspace, and performed Alt-F11 to open VBE. All the modules from the Personal WorkBook of Workspace "Insider Workspace" appear in the Project Explorer window of this new workspace. Ideally I would like a separate Personal Workbook which would just be for the New Workspace. In other words each workspace should have its own Personal Workbook--I do not want stock selection modules intermingled with baseball team analysis modules. But unique Personal Workbooks must be setup for the two Workspaces to be completely independent of one another-- which is especially important if the two workspaces deal with entirely different subject areas. How can one have a new Personal Workbook for each Workspace one sets up? May you have a blessed day. -- May you have a most blessed day! Sincerely, Michael Fitzpatrick "FSt1" wrote: hi in xl help, look up workspace. it tells you how to devide your projects up into planets. Regards FSt1 "MichaelDavid" wrote: At present there is no object intermediate between Application (Excel) and Project. It would be nice if there were a new object, "Planet" under which would be Projects. Each Planet would have its own subset of Projects. Then if one booted up Excel, say holding down the Shift Key, one would be given the choice of which Planet he wished to open with. One Planet might be "Manage Stock Portfolio" which would include all the projects used in Planet "Manage Stock Portfolio". Another planet might be "Solve Quadratic Equations" which would include all projects and worksheets, etc for this planet. One would then have the capability of exporting modules from one Planet and importing them into the others if so desired. Obviously this is very useful when the functions of some Planets are totally unrelated to the functions of the other Planets. The only way to currently accomplish this is to have two separate installations of Excel which is very wasteful of resources. I hope this suggestion will lead to other suggestions leading to a more flexible Excel. Please feel free to let me know of other ways to accomplish this, or any questions you might have. -- May you have a most blessed day! Sincerely, Michael Fitzpatrick ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree" in the message pane. http://www.microsoft.com/communities...el.programming |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VB6 and the Excel.Application Object | Excel Programming | |||
Excel sort application should work with Project WBS | Excel Worksheet Functions | |||
Accessing an Embedded Project Object in Spreadsheet | Excel Programming | |||
Excel Project to Application.Exe | Excel Discussion (Misc queries) | |||
Accessing the VBA project object model | Excel Programming |