Importing a Module.bas using VB

[greg0226]

What would be the code to Import a module.bas using VB code. I keep trying to use the SendKeys function but once the import file box comes up it does not type anything, so i was hoping someone had an easier way to import a module by just using one line of code. Any help would be greatly appreciated. Thanks

Greg

 

[Ivan F Moala]

On 2002-03-11 23:01, greg0226 wrote:
What would be the code to Import a module.bas using VB code. I keep trying to use the SendKeys function but once the import file box comes up it does not type anything, so i was hoping someone had an easier way to import a module by just using one line of code. Any help would be greatly appreciated. Thanks

Greg

ActiveWorkbook.VBProject.VBComponents.Import "Full path name to Bas file"

You'll need to reference the Micorsoft Visual basics extensibilty file.


Ivan

 

[greg0226]

what do you mean by reference the VB extensibility file?

 

[greg0226]

thanks, i got it working.. appreciate the help.

Greg