Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Illinois
    Posts
    552
    Thanks
    0
    Thanked 1 Time in 1 Post

    VB6 .exe won't run with W95 (w95/w2000/officexp)

    I wrote a little vb program that is just a form. The form has text boxes and you enter data. Then you hit submit and the data goes into excel. I have

    dim xlsApp as excel.application

    set xlsApp = New Excel.Application

    ...

    It works fine on w2000 but when i try on w95 it gives me an error message when i click on submit. Are there other references or DLLs i have to add to make it work on different operating systems? Thanks

  2. #2
    Platinum Lounger
    Join Date
    Dec 2000
    Location
    Queanbeyan, New South Wales, Australia
    Posts
    3,730
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VB6 .exe won't run with W95 (w95/w2000/officexp)

    Set a reference in the VBA window (Tools, References) to "Microsoft Excel x.x Object Library".
    Subway Belconnen- home of the Signboard to make you smile. Get (almost) daily updates- follow SubwayBelconnen on Twitter.

  3. #3
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Illinois
    Posts
    552
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: VB6 .exe won't run with W95 (w95/w2000/officexp)

    yes, that is in there already. I've set the reference to Microsoft Excel 10.0 object library.

    The exe runs on win2000 and winnt but i get an error on win95. The error is not specific enough or doesn't give me many details. I thought there might be another common element i'm supposed to add to this vb6 program to make it cross-platform compatible.

  4. #4
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: VB6 .exe won't run with W95 (w95/w2000/officexp)

    For debugging purposes, have you tried running the code from inside an Excel VBA module on the Windows 95 machine? Unfortunately, you cannot simply import the form, but you probably don't need that, just some mock data to test the submit function.

Posting Permissions

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