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

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

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

Is the code password protected?

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

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Steve G" wrote:

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

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

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

On Tue, 21 Aug 2007 15:20:01 -0700, Wigi wrote:

Is the code password protected?

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

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

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 wrote:

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

--

Dave Peterson

thank you to Gordon Dibben, Dave Peterson, and Wigi regarding Importing Alan Beban's code on Arrays; Importing a module or a project
 

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