Run excel with vb

[carld]

How do i get an excel workbook i designed with vb6 work on a machine that hasn't got vb6 on it and the vb run files won't work.
I keep on getting a message "can not load some objects because they are not available on this machine". I have used the DTPicker Control on the vb forms.

 

[Corticus]

Welcome!

As long as the file created using VB is an .exe file, you don't(shouldn't) need VB editor to run it.

You designed a workbook using VB?
As far as I know, VB will allow you to insert a spreadsheet object into a form, but to edit the data on the sheet, you have to have Excel, and it must be running.

HTH
Corticus

 

[carld]

My apologies, it was created in excel using vb to design the forms etc, it works fine on my machine because i have vb6 installed. it comes up with the object error when the excel document is opened on a machine without vb6.

 

[dmckinney]

Hi,

It seems to me the problem is that you used a control which is not available on the other machine. (You have it cos you've got vb installed.) If it's a one off, I'd suggest the following solution. Make a vb exe with a form which uses the control you want to migrate. Use the package and deployment wizard to create a set-up file. Install this on the other machine.

The effect of this will be to install the required control on the other machine (assuming administrator installation permissions).

If it's for a wider distribution and the above solution isn't practical then either use a different control or consider a set-up package to distribute your software :-0

(don't know the specific control but if it's just an .ocx with no support files, you could try copying the ocx to the system dir and then Start... Run...
"regsvr32 c:/wi./sys.../filename.ocx" to register the control.

hth,

dave.