VB6 identity crisis

Reply

Join Date: Nov 2004
Posts: 6
Reputation: nutwood33 is an unknown quantity at this point 
Solved Threads: 0
nutwood33 nutwood33 is offline Offline
Newbie Poster

VB6 identity crisis

 
0
  #1
Nov 6th, 2004
Please could someone help me with a very simple question. I use VB macros quite extensively for a variety of data contol tasks in Excel. I'm totally self taught assisted by "Help" and frustration in equal measures.
"Help" tells me I'm using VBA 6.0.8435. I would like to learn more about VB but all the books I look at refer to VB as a seperate program rather than something only accessed through Excel/macros. Is this VB6 I've been using the same program as the books refer to or should I be obtaining a seperate piece of software to continue learning?
Reply With Quote Quick reply to this message  
Join Date: Jul 2004
Posts: 200
Reputation: mnemtsas is an unknown quantity at this point 
Solved Threads: 1
mnemtsas's Avatar
mnemtsas mnemtsas is offline Offline
Junior Poster

Re: VB6 identity crisis

 
0
  #2
Nov 6th, 2004
Originally Posted by nutwood33
Please could someone help me with a very simple question. I use VB macros quite extensively for a variety of data contol tasks in Excel. I'm totally self taught assisted by "Help" and frustration in equal measures.
"Help" tells me I'm using VBA 6.0.8435. I would like to learn more about VB but all the books I look at refer to VB as a seperate program rather than something only accessed through Excel/macros. Is this VB6 I've been using the same program as the books refer to or should I be obtaining a seperate piece of software to continue learning?
You've been using Visual Basic for Applications, which is a subset of Visual Basic. If you want to learn to program applications that are stand alone (rather than part of an Excel workook, a word document, or MS Access) then Visual Basic is what you want to try. The easiest transition from VBA to VB is Visual Basic 6, though this is an old package now, and you'll have trouble buying it anywhere.

There are vba books around if you are interested in learning more about this. My local bookstore has several. I did the same as you, went from VBA to VB. Ask anymore questions you may have.

Mark
Reply With Quote Quick reply to this message  
Join Date: Nov 2004
Posts: 6
Reputation: nutwood33 is an unknown quantity at this point 
Solved Threads: 0
nutwood33 nutwood33 is offline Offline
Newbie Poster

Re: VB6 identity crisis

 
0
  #3
Nov 6th, 2004
Ah-ha; Thanks Mark, I suspected something like this. Any good suggestions as to where I could lay my hands on VB6 would be much appreciated.
In the mean while, are there dramatic differences between VBA and it's stand alone parent? Most of the ideas I've gained from the books I've investigated appear to work with VBA although I'm obviously not using the software to it's full potential
Reply With Quote Quick reply to this message  
Join Date: Jul 2004
Posts: 200
Reputation: mnemtsas is an unknown quantity at this point 
Solved Threads: 1
mnemtsas's Avatar
mnemtsas mnemtsas is offline Offline
Junior Poster

Re: VB6 identity crisis

 
0
  #4
Nov 7th, 2004
Originally Posted by nutwood33
Ah-ha; Thanks Mark, I suspected something like this. Any good suggestions as to where I could lay my hands on VB6 would be much appreciated.
In the mean while, are there dramatic differences between VBA and it's stand alone parent? Most of the ideas I've gained from the books I've investigated appear to work with VBA although I'm obviously not using the software to it's full potential
From a base code level, no there is not a lot of difference. However, there are a lot of things in the full VB that simply do not exist in VBA. This includes classes, the way forms are handled, much better access to third party controls, and installation/setup issues. The best way to try it is to suck it and see.

I've got no real idea where to buy VB6 these days. If you become a MSDN subscriber you'll get it that way (as well as the other dev tools). This is several hundred dollars so it's not cheap. However, if you're doing it for work it's a good buy. I'm going to re-subscribe this year.
Reply With Quote Quick reply to this message  
Join Date: Nov 2004
Posts: 6
Reputation: nutwood33 is an unknown quantity at this point 
Solved Threads: 0
nutwood33 nutwood33 is offline Offline
Newbie Poster

Re: VB6 identity crisis

 
0
  #5
Nov 11th, 2004
Thanks Mark. This thread has let me know where I'm at. Unfortunately my work is unlikely to come at forking out for my software education as the VBA things I'm up to have been a side line introduced by myself. I'm not complaining as the $'s saved there will undoubtedly find their way into my control to be spent on other interesting gizmos for me to play with.
I'll keep my eyes open for VB6. In this big bad world you never know!

Steve


Originally Posted by mnemtsas
From a base code level, no there is not a lot of difference. However, there are a lot of things in the full VB that simply do not exist in VBA. This includes classes, the way forms are handled, much better access to third party controls, and installation/setup issues. The best way to try it is to suck it and see.

I've got no real idea where to buy VB6 these days. If you become a MSDN subscriber you'll get it that way (as well as the other dev tools). This is several hundred dollars so it's not cheap. However, if you're doing it for work it's a good buy. I'm going to re-subscribe this year.
Reply With Quote Quick reply to this message  
Join Date: Oct 2004
Posts: 3,972
Reputation: vegaseat is just really nice vegaseat is just really nice vegaseat is just really nice vegaseat is just really nice vegaseat is just really nice 
Solved Threads: 920
Moderator
vegaseat's Avatar
vegaseat vegaseat is online now Online
DaniWeb's Hypocrite

Re: VB6 identity crisis

 
0
  #6
Nov 14th, 2004
The VB6 Working Model is floating around for almost free on a CD ROM with a number of books. I picked up "Sams Teach Yourself Visual Basic 6 in 24 Hours" at Borders for $19.99. The VB6 Working Model performs well, but lacks the help files. At least you get to find out if you like it, before you spent the big bucks.
May 'the Google' be with you!
Reply With Quote Quick reply to this message  
Join Date: Nov 2004
Posts: 6
Reputation: nutwood33 is an unknown quantity at this point 
Solved Threads: 0
nutwood33 nutwood33 is offline Offline
Newbie Poster

Re: VB6 identity crisis

 
0
  #7
Nov 16th, 2004
Thanks for the tip on the books. I'll do some scouting around. Unfortunately I'm down the bottom of the world in Tasmania so I'm restricted to what I can locate on the net but I'll give it a bash.
I've ordered a couple of VBA books which are in transit so hopefully I'll get that side of things up to speed anyway.
Steve
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the Visual Basic 4 / 5 / 6 Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC