Visual basic and MS Excel


  1. mohab
    Posts : 130
    Windows 7 Professional 64 bits
       New #1

    Visual basic and MS Excel


    How much more would I be able to do in Excel if I knew Visual Basic
      My Computer
    Quote Quote

  3. Palbus
    Posts : 11
       New #2

    VBA opens up a whole new world . Google "VBA Excel ebooks" and don't dismiss the dummies guide, very good for beginners, can free d/l
      My Computer
    Quote Quote

  4. TanyaC
    Posts : 784
    Linux Mint 17 Cinnamon | Win 7 Ult x64
       New #3

    Just a completely obscure piece of rhetoric as I pass by..

    Microsoft Excel is an extremely powerful set of tools, even without VB. It's amazing how many people turn to VB to do things that Excel can do natively.. Only twice have I ever had to resort to using VBA in an excel workbook, and some of my "programs" are pretty complicated.

    But that's not to diminish the power of VB in Excel. PalBus is right, there is a lot more you can do with VBA.

    VB does have a hit on your system though. Some advice - always see if there is a way to do it natively in Excel before you resort to writing VB scripts.

    Good luck.
      My Computer
    Quote Quote

  6. mohab
    Posts : 130
    Windows 7 Professional 64 bits
    Thread Starter
       New #4

    TanyaC, I agree with you that Excel is very powerful but flexible at the same time. I personally am amazed that a big software like Excel can operate on our machines ( as opposed to requiring a mini computer and a workstation). Whenever I thought that "no that's too complex for Excel" then I searched online, I would usually find a way to do it in Excel.
      My Computer
    Quote Quote

 

  Related Discussions
Help! Visual Basic 6.0
in General Discussion

Hey Guys, It's me again... I am a Computer Engineering Student and working on our thesis now... I wonder if you could help me in my problem. I Want to print a receipt from the form in visual basic 6.0... If it clicked a button, it will print automatically... I want to know what is the code for...
Visual Basic 6
in Chillout Room

Guys n Gals Any of you know where I might be able to locate a copy of VB6 Professional or Enterprise ? I have a licence key but need the installation media.
I have downloaded MS VB 2008... I understand that it is free software but it requires me to register the product through Help -> Registration... I click it and Internet Explorer opens, asks for my e-mail id and password and stalls to this screen.. (see thumbnail) I want to know is there is any...
Visual Basic
in Software

I am having a go at Visual Basic Express 2008 and looking for books or websites for training. One thing has me confused what is the difference between Visual Basic Express 2008 and Visual Studio 2008? I would also like to know of any good websites for training. Thanks jack
Slowly starting to restore all my programs that ran on WinXP. Seems most of the *.exe programs are running but a few that didn't run I tried to reconstruct them and it appears I need some more dll's. I can't remember if there were 2 CD's that came with VB6 PE. Before I start tearing my computer...
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

 © Designer Media Ltd
All times are GMT -5. The time now is 12:06.
Find Us