Results 1 to 8 of 8
  1. #1
    3 Star Lounger
    Join Date
    Apr 2007
    Location
    Lancashire, United Kingdom
    Posts
    264
    Thanks
    32
    Thanked 5 Times in 5 Posts

    Can I create a standalone VB program to access Excel spreadsheets

    I'm getting reasonably proficient at writing VB inside Excel to access cells, manipulate data, write spreadsheets etc.

    What I would like to do is write a standalone .EXE program to do the same thing. Assuming I have access to Visual basic (which I do), what do I need to code at the beginning so that the functions work properly?

    cheers

    Alan

  2. #2
    WS Lounge VIP
    Join Date
    Dec 2009
    Location
    Earth
    Posts
    8,164
    Thanks
    47
    Thanked 976 Times in 906 Posts
    You can write routines to control any Office app as compiled programs or just in VB script. There are plenty of VBS examples on the the web.

    cheers, Paul

  3. #3
    Administrator
    Join Date
    Jun 2010
    Location
    Portugal
    Posts
    12,519
    Thanks
    152
    Thanked 1,398 Times in 1,221 Posts
    Basically what you want is to create a VB app that uses Office Automation to open excel and manipulate it from your app. Here is a starting point:

    http://support.microsoft.com/kb/219151
    Rui
    -------
    R4

  4. #4
    3 Star Lounger
    Join Date
    Apr 2007
    Location
    Lancashire, United Kingdom
    Posts
    264
    Thanks
    32
    Thanked 5 Times in 5 Posts
    It all sounds wonderful until I try and install VB6. It says I don't have enough disk space. That is because I have TOO MUCH disk space and the stupid 2003 setup program doesn't recognise it.

    Is there a modern version of VB I can play with?

    cheers

    Alan

  5. #5
    Administrator
    Join Date
    Jun 2010
    Location
    Portugal
    Posts
    12,519
    Thanks
    152
    Thanked 1,398 Times in 1,221 Posts
    Quote Originally Posted by alan sh View Post
    It all sounds wonderful until I try and install VB6. It says I don't have enough disk space. That is because I have TOO MUCH disk space and the stupid 2003 setup program doesn't recognise it.

    Is there a modern version of VB I can play with?

    cheers

    Alan
    I think this version supports Vb.Net, but Microsoft Visual Studio Express 2013 for Windows Desktop is the most recent version of Visual Studio that supports Visual Basic development: http://www.microsoft.com/visualstudi...t-2013-summary

    Probably not too big a difference from the VB you are used to (I can't help with the differences, either, I usually program in C#).
    Rui
    -------
    R4

  6. #6
    3 Star Lounger
    Join Date
    Apr 2007
    Location
    Lancashire, United Kingdom
    Posts
    264
    Thanks
    32
    Thanked 5 Times in 5 Posts
    Thank you. I'll try that.

    Alan

  7. #7
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,629
    Thanks
    114
    Thanked 645 Times in 589 Posts
    When you do install, you will want to start here

  8. #8
    3 Star Lounger
    Join Date
    Apr 2007
    Location
    Lancashire, United Kingdom
    Posts
    264
    Thanks
    32
    Thanked 5 Times in 5 Posts
    many thanks all. I'm playing with Visual Studio and I'll see how that works.

    Alan

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •