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

Topic

New Reply

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

Reply | Quote

Replies

Set a reference in the VBA window (Tools, References) to “Microsoft Excel x.x Object Library”.

Reply | Quote

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.

Reply | Quote

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.

Reply | Quote