convert _VBA_ to VB.net?

  • Thread starter Thread starter susiedba
  • Start date Start date
S

susiedba

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
 
does anyone know any helpful ways to import VBA from Excel into VB
2005?
Click to expand...

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,

The OP is Aaron Kempf in drag. Look for other posts today by
(e-mail address removed)

Bruce
 
Tom,

The OP is Aaron Kempf in drag. Look for other posts today by
(e-mail address removed)

Bruce
Click to expand...

I know. I realized shortly after I posted. He is a real live troll.
 
Tom Shelton said:
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.
Click to expand...

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 pisses 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 pissed 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 tom, btw why are you scared of VBA? i mean; it's just like VB6;
but it has a 90% market share; I mean.. Excel and Word and Outlook is
on -everyones- machines.. the framework isn't on 10% of desktops

-Aaron
 
I'd like to recommend to the readers of this list to completely
disregard posts from the following sources:

susie dba
dba hooker
punjab tom
aaron kempf
larry linson, jr
master programmer

They're all manifestations of the same entity that haunts this
discussion list, a nameless, low life form between a troll and a bot,
and, still, less than a ghost. A postergeist, if you forgive the bad
pun.

For the matter of comparison, think Peeves, of Hogwarts infamy, or, to
the elders among you, Slimer, that green, transparent and farting
thing from GhostBusters. As with its ectoplasmic peers, the more you
listen to its moans, the more filth it will regurgitate in the room.

Be warned.

Branco.
 
(e-mail address removed) schreef:
and tom, btw why are you scared of VBA? i mean; it's just like VB6;
but it has a 90% market share; I mean.. Excel and Word and Outlook is
on -everyones- machines.. the framework isn't on 10% of desktops

-Aaron
Click to expand...

No, Word, Excel and Outlook are not on our PC's here, we use
alternatives. VBA has similarities with VB6. Alot of it is
interchangeable, but not everything. So what if the framework is not on
every desktop yet. Just put on on the CD with your program, I mean
really. We have an old VB program which doesn't run on any windows
incarnation... until we install the right dll's. Just like a .NET
program needs the framework, oh boohoo.
 
I'd like to reccomend that everyone turn off the sopranos and
disregard this WOP

I am _NOT_ mp
I wish I was

he is very well spoken; thanks kid
 
vb6 apps work on these operating systems out of the box

windows 2000
windows 98
windows me
windows xp
windows vista
windows server 2003

does not the runtime _SHIP_ with windows for vb6?

ROFL

cuz the 100mb framework sure doesn't download on dialup very well.. no
wonder nobody uses it for commercial apps

its' not a question of a CD
it's a question of 1mb or 100mb
 
(e-mail address removed) schreef:
vb6 apps work on these operating systems out of the box

windows 2000
windows 98
windows me
windows xp
windows vista
windows server 2003

does not the runtime _SHIP_ with windows for vb6?

ROFL

cuz the 100mb framework sure doesn't download on dialup very well.. no
wonder nobody uses it for commercial apps

its' not a question of a CD
it's a question of 1mb or 100mb
Click to expand...

A hello world app maybe, but other than that you need to install some
extra stuff.

The .NET framework is not a 100MB download. It's around 23MB. And we do
use it for commercial apps. And we're not the only ones.

Look, you don't want to use VB200x, that's just fine. Use VB6. As you
said it works great on Vista. You can go on for years on that path.
What's stopping you? Just because MS stopped actively updating VB6?
Please. They also EOL'd Win9x/2000. That doesn't mean they don't work
anymore, No. You said it yourself with your 8 input Win98 box.

I don't like to use Outlook. Does that mean I have to goto the Outlook
newsgroup and bitch about it?

You just have a gripe with your old employer and want to discredit them
here. You've made your point, now please leave it alone.
 
now why in the hell would I ever install any other crap?

the standard controls, ADO and a database is all I ever need.
Maybe if you kids stopped reinventing the wheel you might now have
such complexities


but I choose VB6 over VFRED any day of the week





and I DO NOT Have a gripe with an old employer

MICRO ****ING SOFT KILLED MY MOTHER ****ING LANGUAGE EAT A ****ING
NAZI JACKBOOT YOU DUTCH PUSSY
 
Back
Top