• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

Visual Basic 6 or Visual Studio for EXCEL use


jimbo45

New Member
VIP Member
Guru
Hafnarfjörður IS

Posts
4,373
#1
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)

skallal

New Member
Member
In the OC

Posts
204
#2
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 Number
    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

Keithuk

New Member
Posts
19
#3
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 8 64bit
    Computer type
    Laptop
    System Manufacturer/Model Number
    Samsung (NP350E7C-A04)
    CPU
    Intel Pentium B970
    Motherboard
    Samsung
    Memory
    6GB
    Graphics Card(s)
    Intel HD Graphics (Samsung)
    Browser
    IE10
    Antivirus
    Avast Pro
Posts
2
#4
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