Importing Alan Beban's code on Arrays; Importing a module or a project

[Steve G]

I downloaded Alan Beban's code on Arrays from his web site to a file
on my hard drive. How do I copy the module containing his code and
place it into my personal.xls file?

Also--is there a way to export the project of Alan Beban's module or
any other project for that matter. I do not think Alan Beban's
project has a User Form. But if there was a User Form I would want to
export it into my personal.xls file. I know in Word there is
Organizer. Does Excel have something similar?

Thank you.

Steve G

 

[Guest]

Is the code password protected?

In case you don't know that, can you provide a direct link to the file?

 

[Gord Dibben]

If the file is ArrayFunctions.xls there is no protection on the VBAProject.

Export the module11 and then import to your Personal.xls

Or just open the module11 and copy the code to a general module in Personal.xls


Gord Dibben MS Excel MVP

 

[Dave Peterson]

Or open both workbooks.
Open the VBE
hit ctrl-r to see the project explorer window
and drag the module from one project to the other.

(Not sure if there is other code in that module that you don't want, though.)

 

[Steve G]

I want to thank Gordon Dibben, Dave Peterson, and Wigi for the
assistance. I opened the file that had the Alan Beban code and I went
to the VBA of my personal.xls. I just dragged the module from one
project to another and now Alan Beban's code is in my personal.xls.
Now I will try to learn how to use Mr. Beban's code. Thank you
again. Steve G