Yes, that's the trick! Export first, then import.
I was trying to import directly into VB, but I couldn't find the modules..
----- Original Message -----
From: "Rob Bruce" <[log in to unmask]>
To: <[log in to unmask]>
Sent: Thursday, March 08, 2001 3:04 AM
Subject: Re: Visual Basic and Excel VBA
> >===== Original Message From A list to stimulate discussion about the
> technical aspects of the developme
> <[log in to unmask]> =====
> >Can you use an Excel VBA Module in a VB Project? I have seen Excel
> used in Visual Basic, but are there any special requirements and
> regarding the interchangeability of the two types of modules (and
> subroutines). Is there any literature on this?
> >Thanks David
> Hi David,
> The modules are completely interchangeable. Just export from Excel and
> into VB5/6 (you can drag and drop from explorer if you have a few modules
> This does not mean that the code is going to be interchangeable, of
> That bit's up to you!