Learning Visual Basic

**The_Doctor** · 06-13-2005, 17:37

I bought Visual Basic 6 for Dummies.

**The_Doctor** · 06-13-2005, 18:06

Oh great, the CD that came with the book does not have VB6 on it. The source code on the CD does not work with the VBA on Excel.

Is there is way to make it work on VBA?

If not,

Where can a get a copy of VB6?
Is it expensive?
It so, how can I get it for free? (the book cost £30, I do not want to pay a lot for it.)

**TonkaToys** · 06-14-2005, 08:42

The VB6 source code should be similar to VBA... what version of Excel are you using in case that makes a difference?
Actually, it could be good practice for you to take a simple piece of code that doesn't work, run it through the debugger and then try to fix the errors. That might be a good way of getting your head around it.
What type of errors are appearing? Perhaps the .Org can help.
I don't think you can get VB6 for free, legally.

**The_Doctor** · 06-14-2005, 10:06

I load up Excel and put the disk I got with the book in.

I go to file then import file and locate the file I want.

Then it says:

The form class contained in D:\Chapter3\Hello1.frm is not supported in VBE. The file can't be loaded.

I will put the files on the C drive, to see if that makes a difference.

**The_Doctor** · 06-14-2005, 10:09

That did not work.

I am running Excel 2000, though my OS is XP.

**Al Khalifah** · 06-14-2005, 11:59

What is the difference between VB6 and .net?

Visual Basic.net uses the Microsoft dotNET framework which makes it a more fully object oriented language. It's much tighter in a lot of areas in terms of what you're allowed to get away with. There's also no more 'Any', but since you haven't used VB6, that won't bother you, neither will the near eradication of 'Get' and 'Set'.

dotNET programs and assemblies can be registered for interop with COM (pre-dotNET assemblies) easily. Doing the reverse is very difficult.

**TonkaToys** · 06-15-2005, 13:21

The form class contained in D:\Chapter3\Hello1.frm is not supported in VBE. The file can't be loaded

Ahhh... you are trying to load a form. Forms are difficult to translate from VB to VBE; a form is the interface to your VB program, whilst in VBE the interface is the application (Excel, Word, etc).
What you need to do is copy the event procedures behind the controls on the form, create your own form in Excel with the same controls on it (same names too) and then paste the event procedures into your Excel form. Sounds complicated... it could be, and it may not completely work!