Results 1 to 11 of 11
  1. #1
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Anybody got a system without Office? (VB 6, but no Office)

    If I compile a program that includes a reference to the Word 97 and Excel 97 object libraries, what happens if I try to run the program on a system that has NO version of Word or Excel, and no option that uses Word or Excel is run?

    Will the program still load and run?
    Or will it crap out because of the broken references even tho the code paths involving Word and Excel are unused?

    I've got no system without Office, so I cannot test this?

    Such a program can be found at http://www.standards.com/Sorting/SortPerfo...escription.html.

  2. #2
    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: Anybody got a system without Office? (VB 6, but no Office)

    I can't test that one either, but shouldn't VBA be consistent for all referenced libraries? You could try to test with a reference to an NT-specific DLL on a 9x system, or vice versa.

  3. #3
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Anybody got a system without Office? (VB 6, but no Office)

    It's a VB 6 .exe, not Office VBA.

    VBA is only used with the VB 6 program when I create a Word/Excel object and do some automation of Word/Excel.
    The only system that I have that does not have a VBA based Office is an old Win 95 system with Office 95.
    If I could install the VB 6 runtimes on that system, then I might be able to test.

    I'll need to find out whether VB 6 runtimes will run on Win 95.

  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: Anybody got a system without Office? (VB 6, but no Office)

    Actually, the VB / VBA difference probably is relevant here, because the missing references problem in Office-hosted solutions seems to occur at compile time. I'll be interested to hear if your tests are conclusive one way or the other.

  5. #5
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Anybody got a system without Office? (VB 6, but no Office)

    It's not really the same as Office does not have a true compile that produces a .exe.

    I believe that the VB 6 runtimes will install on a Win 95 system.
    If so, then I'll try my experiment on a Win 95 system with Office 95.
    Obviously, if I select ant Word/Excel option, thre program will blow up.
    Otherwise, I'll find out the hard way.

  6. #6
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Anybody got a system without Office? (VB 6, but no Office)

    1. Powered up ye ole 486 and booted to Win 95.
    2. Uninstalled VB 5 Learning Edition.
    3. Installed VB 6 run-times.
    4. Installed VB 6 SP5 runtimes.
    5. Brought ove ra VB 6 app tat did not use Office.
    6. App worked.
    7. Brought over my Sort Performance Monitor.
    8. Program loaded with no error.
    9. Seems to work properly if I do not choose one of the 3 Word/Excel sort methods.
    10. When I choose a Word sort method, I get an error 429 as Word 95 knows knothing about VBA.
    11. When I choose the Excel sort, I get error 13. Likely because Excel 95 does know about VBA.
    12. My code traps, and reports, the errors, then continues normally.

    Only issue, and I doubt that I will try to fix this is the error sometimes gets reported for the wrong sort method. This would occur if the ennumerated constants I am using to identify things are somehow getting out of whack due to the Word/Excel errors. I might be able to program around that, but the program requires Word/Excel 97, or later, so it ain't worth the effort, tho I am curious as to why this might occur.

  7. #7
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Anybody got a system without Office? (VB 6, but no Office)

    I cleaned up the error messages, but I doubt that I'll find a system that does not have Word/Excel with Win 95 or later.

  8. #8
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Anybody got a system without Office? (VB 6, but no Office)

    I tried this on a clean install of Windows 98SE in a virtual PC (VMWare) System. There was no version of Office installed nor any version of VB.

    I tried the QuickSort option without any problems. I then tried the Excel Worksheet option and got an Error 429 message. see attached.

    The following is the content of the SortPerformancLog.txt file.<pre>Sort Performance Comparison(Start: 21:23:43 on 17 Mar 2004)
    Set randomize seed: Yes
    Algorithm Comparison(Start: 21:23:54 on 17 Mar 2004)
    Data type: Long
    Display data: No
    Number of data items: 1000
    Number of samples: 1
    Order of source data: Random
    Reuse data: No
    Verify sort: No
    Source: Array
    Target: Array
    Use integer data: Yes
    Maximum integer value: 999
    Quick Sort(S7.4): 53 milliseconds
    Algorithm Comparison(End: 21:23:54 on 17 Mar 2004, timed/elapsed: 53/90 milliseconds, 58.89%)
    Algorithm Comparison(Start: 21:24:11 on 17 Mar 2004)
    Data type: Long
    Display data: No
    Number of data items: 1000
    Number of samples: 1
    Order of source data: Random
    Reuse data: No
    Verify sort: No
    Source: Array
    Target: Array
    Use integer data: Yes
    Maximum integer value: 999
    Excel Worksheet Sort: Error 429, ActiveX component can't create object
    Algorithm Comparison(End: 21:24:12 on 17 Mar 2004, timed/elapsed: 0/1732 milliseconds, 0.00%)
    Sort Performance Comparison(End: 21:24:16 on 17 Mar 2004)</pre>

    If you would like me to try anything else post back.

    Andrew C

  9. #9
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Anybody got a system without Office? (VB 6, but no Office)

    Thanx.

    That's the expected result and seems to confirm my hypothesis that I got the error 13 because Excel 95 is VBA aware.

    I did not realize that Win 98 SE came with the VB 6 runtimes.

    Oh well, this gives me an excuse to keep my ole 486 around as it has only the VB 6 runtimes, tho it does have Office 95.

  10. #10
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Anybody got a system without Office? (VB 6, but no Office)

    < I did not realize that Win 98 SE came with the VB 6 runtimes. >

    It does not.

    I installed the appropriate runtime file in order to carry out the experiment.

    Andrew C

  11. #11
    Gold Lounger
    Join Date
    Dec 2000
    Location
    New Hampshire, USA
    Posts
    3,386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Anybody got a system without Office? (VB 6, but no Office)

    Thanx fer the clarification.

Posting Permissions

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