does anyone know any helpful ways to import VBA from Excel into VB
2005?

I just swear; 2/3rds of the Vb6 code in the world never touched Visual
Basic 6.0; and I want to re-use some of my existing code without a
bunch of effort.

I was thinking that the convertor could help me to do this; but It
won't import the VBA from a spreadsheet

thanks

Susie

yeah.. I've sure got a _LOT_ of VB6 code living in spreadsheets and
VBS files; it sure would be nice if the VB convertor would work with
those files.

Of course, it's impossible to jump on a full speed train

I think that we should all vote for Ralph Nader for president of
Microsoft; I think that he is the only person that can save this
company

-Aaron

On Feb 9, 7:14 pm, "susie...@hotmail.com" <susie...@hotmail.com>
wrote:
> does anyone know any helpful ways to import VBA from Excel into VB
> 2005?
>

Well... To be honest I've never been much a vba person, but since no
one has given you any helpful answers yet - I'll take a stab....

In 2005 you have the ability to convert code snipits at a time... If
you look in the menu, you should see an options that says Upgrade
Visual Basic 6 Code. You can then copy and paste or type code into it
to see what the translation would be. I suppose, you could copy your
vba functions into that box and see what happens I suspect you
will have some issues due to differences between VBA and VB6, but it
might get you partway there anyway.

--
Tom Shelton

Tom,

The OP is Aaron Kempf in drag. Look for other posts today by
(E-Mail Removed)

Bruce

"Tom Shelton" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> On Feb 9, 7:14 pm, "susie...@hotmail.com" <susie...@hotmail.com>
> wrote:
>> does anyone know any helpful ways to import VBA from Excel into VB
>> 2005?
>>
>
> Well... To be honest I've never been much a vba person, but since no
> one has given you any helpful answers yet - I'll take a stab....
>
> In 2005 you have the ability to convert code snipits at a time... If
> you look in the menu, you should see an options that says Upgrade
> Visual Basic 6 Code. You can then copy and paste or type code into it
> to see what the translation would be. I suppose, you could copy your
> vba functions into that box and see what happens I suspect you
> will have some issues due to differences between VBA and VB6, but it
> might get you partway there anyway.
>
> --
> Tom Shelton
>

On 2007-02-10, Bruce W. Darby <(E-Mail Removed)> wrote:
> Tom,
>
> The OP is Aaron Kempf in drag. Look for other posts today by
> (E-Mail Removed)
>
> Bruce

I know. I realized shortly after I posted. He is a real live troll.

--
Tom Shelton

"Tom Shelton" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> On Feb 9, 7:14 pm, "susie...@hotmail.com" <susie...@hotmail.com>
> wrote:
>> does anyone know any helpful ways to import VBA from Excel into VB
>> 2005?
>>
>
> Well... To be honest I've never been much a vba person, but since no
> one has given you any helpful answers yet - I'll take a stab....
>
> In 2005 you have the ability to convert code snipits at a time... If
> you look in the menu, you should see an options that says Upgrade
> Visual Basic 6 Code. You can then copy and paste or type code into it
> to see what the translation would be. I suppose, you could copy your
> vba functions into that box and see what happens I suspect you
> will have some issues due to differences between VBA and VB6, but it
> might get you partway there anyway.
>
> --
> Tom Shelton
>

Tom,

You're being a really nice guy here, so I feel I have to tell you that this
is one of Aaron's aliases. So is dbahooker. He's having a conversation with
himself in this thread.

Robin S.

yeah I don't want to copy and paste

i've got hundreds of spreadsheets; hundreds of Access applications

I just want to know why VB 2005, 2002 or 2003 doesn't have some
functionality to import VBA code

-Aaron

I'm not a troll

I've got legitimate grievences about VB and you kids claim that
everything is peachy

VB 2005 doesn't do full 3/4 of the activities I need to do with VB; so
please tell me how to proceed-- continue using VB6 and vb 2005?

do I really need to go from one langauge to FOUR?

OLD DAYS:
VB6 / VBA / VBS

NEW PARADIGM
C# - a _LOT_ of samples are showing up only in this newly invented
langauge and that just flat out ****es me off
VB6 - because 2002,2003,2005 don't have 3/4 of the functionality of
VBA / VB6 / VBS
VB 2005 - because i'm a vb guy, duh
Javascript - clientside DHTML, because Microsoft killed off clientside
vbScript in ASP.net - I read this in MS press book, VBS clientside is
not supported any longer

now do you get some clue why I'm ****ed off?

the answer is _NOT_ 'just learn 4 languages' in addtion to the half
dozen db langauges I need

the answer is 'find a new language'

and please stay on-topic, thanks