Solved: Newbie once again, importing a module

[slang]

I know I am referencing this the wrong way or something, it couldn't be as simple as the statement below. What am I missing?
Thanks again Excel gods

ActiveWorkbook.VBProject.VBComponents.Import ("c:\bdr\GOOJFC.bas")

[rory]

It is that simple but you have to have Programmatic access to the VBProject trusted under Tools-Macro-Security, on the Trusted Sources tab.

[slang]

How would I get the code to work on my field reps laptops? Would I have to add it to each users trusted sources? Is there a way around it?

Oops, never mind, I can't even add myself because of our desktop standardization. AARG.

[rory]

Depends on how tight the security is. You can override it through code:
[VBA]'Code removed by administrator.
[/VBA]
if they have access to the registry.

[Aussiebear]

The thread was considered to be moving in a direction which is contravening a major policy of this forum. By utilizing code which enables a person to adjust the settings within the Trusted Sources component of a system, simply breaks down the security of a system.

Please be advised that this will not be condoned by the Administrators of this forum. Unless this thread moves in another direction, it will be closed.

[rory]

Apologies (again) - I wasn't really thinking when I posted that!

[Aussiebear]

That's okay Rory.

[slang]

Also sorry, wasn't my intention. With my limited knowledge of VBA I would be venturing into some very questionable ground anyway. Could have been a classic "CLM"
career limiting move.
Thanks......