Visual Basic 6 or Visual Studio for EXCEL use

jimbo45

New Member
VIP Member
Guru
Messages
4,373
Location
Hafnarfjörður IS
Hi there
I'm just messing around a bit with Visual Basic - I just want to use EXCEL (mainly) and a couple of really simple Windows stuff. I can't be bothered with C# or .NET -- I'm not (nor intend to be) a professional programmer -- but would like to have a go with some small applications and get to grips with the Basic in EXCEL.

I've got the old Ms Visual Basic 6 disks -- is it worth while messing about with these on W8 (Ms believe it or not is going to support the platform through W8 releases !!!) or should I just bite the bullet and download Visual Studio express which seems a bit overkill also for what I'm really trying to do.

As I'm running a 32 bit version of Office it would seem that most of the VB6 stuff could run quite simply in EXCEL 2010 (32 bit) even though my OS is x-64 --or I could even run it in an XP VM.

Any suggestions as to which is the better way to go -- I just want this for casual use -- not as a professional.

Cheers
jimbo
 

My Computer

System One

  • OS
    Linux Centos 7, W8.1, W7, W2K3 Server W10
    Computer type
    PC/Desktop
    Monitor(s) Displays
    1 X LG 40 inch TV
    Hard Drives
    SSD's * 3 (Samsung 840 series) 250 GB
    2 X 3 TB sata
    5 X 1 TB sata
    Internet Speed
    0.12 GB/s (120Mb/s)
Doesn't Office 2010 still support VBA (Visual Basic for Applications)? I think that is what you mean by Basic in Excel?

As far as supporting VB6 in Win 8, VB6 apps do run in Windows (32 bit), though we've had issues at work with some 3rd party components. I'm pretty sure 64 bit is out for VB6! I couldn't get any VB6 executables to run on my Windows 7-64 box, though they will run just fine in an XP VM.

I think your options are VBA in Excel if you want to stick with classic VB...
 

My Computer

System One

  • OS
    Windows 8 Pro
    System Manufacturer/Model
    Sony Vaio Duo 11
    CPU
    i7
    Memory
    8 GB
    Graphics Card(s)
    Intel 4000
    Sound Card
    Realtek High Definition Audio
    Monitor(s) Displays
    11.6" touch screen w/ digitizer & Asus 27" external monitor
    Screen Resolution
    1920x1080
    Hard Drives
    256 GB SSD
    Cooling
    Internal fan
    Keyboard
    Slider keyboard
    Mouse
    Logitech T650 Touchpad & Microsoft Touch Mouse
How did you get Visual Basic 6 to install on Windows 8 jimbo using a Virtual Machine as you said in VB 6 Pro Install on Windows 8.

Which Virtual Machine did you use?
 

My Computer

System One

  • OS
    Windows 10 64bit
    Computer type
    Laptop
    System Manufacturer/Model
    DELL Inspiron
    CPU
    Intel
    Motherboard
    DELL
    Memory
    8GB
    Graphics Card(s)
    Intel HD Graphics
    Sound Card
    RealTek
    Hard Drives
    C: 0.90GB SSD Card rubbish
    D: 1.0TB SATA Drive
    Browser
    IE11
    Antivirus
    Avast Free
The VB6 programming language will run on Windows 7 and 8, 32 bit or 64 bit. And VB6 executables are supported too.
Microsoft offer "it just works" support until 'at least' 2024.

You can install and run VB6 on 64 bit Windows 7 or 8. You don't need to use a VM. You do need to install as an Administrator.

Existing VB6 applications can also run on 64 bit Windows 7 or 8. 32 bit applications run fine on 64 bit Windows (again without a VM).

For Excel, Microsoft recommend installing as 32 bit rather than as 64 bit. Both support VBA (which is almost identical to the VB6 programming language), though the 64 bit version has limitations.
 

My Computer

System One

  • OS
    Windows XP, 7 and 8.1
    Computer type
    PC/Desktop
Back
Top