petlahev / vbe_modules Goto Github PK

As a user I want to be able import an item to the active project

I have to be forced to choose a path from where the items should be loaded
but
If I already imported/exported to/from the project, the path should be defaulted for me.

A form with all items from the folder will be displayed adn I'll be able to

• select all
• select only certain types (class, module, form)
• select a specific item(s)

I need to be given with two options

• Overwrite if already exists (default)
• Make copy (the item with the same name in the project will be retained)

1. Open office app (e.g. Excel)
2. Open VBE editor
3. VBE Menu - VBE modules
4. Export
5. Click on the Browse button
6. Cancel it and Close the * Export* form
7. Reopen the Export form and again click on the Browse button
8. Cancel it

Now, the Select Folder dialog will reopen
If you repeat steps 4-7 the Select Folder dialog will reopen as many times as the Export form was opened

As an user I may want to export/import from/to many projects.
Currently when I hit the Browse.. button, the selected folder always start on the root _C:_

In many cases it may be useful if I export/import from a new project(it is not saved in configuration setting yet) that the preselected folder in the folder dialog will be the one I last used

As an user I want to be able to remove components from an active project.

I should be able to choose which components I want to remove (including all)
The document level components should be just cleared
A confirmation message must be given

If you open an Office application and while it's opening you keep pressing ALT+F11 (open VBE editor), you can get funky behavior of the Component manager menu, like two menus, or just half of the menu etc.

The components are not sorted by name

Currently user has a choice to import components in non override mode.
In that case if VBE figures out that the same name already exists, it will add a new component and adds ordinal number as suffix like

Module1
Module11
Module12
and so on

However this build-in functionality doesn't work for UserForms and importing a form will cause an exception.

Note, inserting a new UserForm and then rename it won't work as import forms consists from two files.
We need to copy the form we want to import, rename both files (frm, frx) and then import

1. Open Excel
2. Open VBE editor
3. Select the unsaved VBProject project
4. VBE menu - VBE modules - Export

This components will be listed in the form however only ThisWorkbook and Sheet1 should be listed there

The forms in the project has a selection panel and a label that displays number of components (including selected). Currently the contol that list components is TreeView.
Manual (de)selection causes inconsistency between what is selected and what the label displays

Also the selection panel should work as a switcher on/off.
For example

1. the first click on All will check all components
2. the second click on All will uncheck all components
   The same logic should work with others

As a user I want to be able export any item from the current project.
I should be able to

• Export all
• Export only specific type (module, class, forms)
• Export selected item(s)

If I export first time from this project I need to choose a path where to export
If I already exported from the project, use the known path but give me ability to change it if I need

As a user I want to be able to add/change/delete project/paths on a view.

The view will allow me to

• delete any existing project saved in the settings file - c:\Windows\Temp\VBE\VbeComponentsConfig.xml
• change path for any existing project with validation
• add new projectwith path, again with validation

When I export items which includes empty ThisWorkbook or ThisDocument class sometimes I got error
Invalid procedure call or argument

Sometimes the same scenario works fine.