Importing a Module.bas using VB

greg0226 · Mar 12th, 2002, 12:01 AM

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 · Mar 12th, 2002, 01:19 AM

Quote:

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 · Mar 12th, 2002, 07:33 AM

what do you mean by reference the VB extensibility file?

greg0226 · Mar 12th, 2002, 07:37 AM

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

Greg

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 12th, 2002, 12:01 AM	#1
greg0226 New Member Join Date: Feb 2002 Location: Benicia, CA Posts: 31	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

Mar 12th, 2002, 07:33 AM	#3
greg0226 New Member Join Date: Feb 2002 Location: Benicia, CA Posts: 31	what do you mean by reference the VB extensibility file?

Mar 12th, 2002, 07:37 AM	#4
greg0226 New Member Join Date: Feb 2002 Location: Benicia, CA Posts: 31	thanks, i got it working.. appreciate the help. Greg