I have a problem when distributing a program with a userform containing a
spreadsheet. The message "Could not load an object because it is not
available on this machine" is displayed. I have Excel 2003 SP2 on my computer
and use this version when programing, the computers that are giving me a
problem have Excel 2002 on them. However, my computer has the 2002 version on
it also and it loads fine there. I have looked for missing references and
addins that are missing, but have not found anything different on my computer
than the ones with the problem. I tried exporting the Userform from the
computer that works properly and importing it on the computer with a problem,
but the spreadsheet still is not in the userform.

If you have a reference to the xl2003 version of the web components, then use
xl2002 on your computer to check - of course that version will still be
available and will be found.

That won't be the case for people using an older version of excel - they
won't have the xl2003 version of the web components on their machine.

If you can, go to their computer and look in tools=References and see if if
shows it as MISSING.

You might want to try late binding.

--
Regards,
Tom Ogilvy




"Jeff Kraft" wrote:

I have a problem when distributing a program with a userform containing a
spreadsheet. The message "Could not load an object because it is not
available on this machine" is displayed. I have Excel 2003 SP2 on my computer
and use this version when programing, the computers that are giving me a
problem have Excel 2002 on them. However, my computer has the 2002 version on
it also and it loads fine there. I have looked for missing references and
addins that are missing, but have not found anything different on my computer
than the ones with the problem. I tried exporting the Userform from the
computer that works properly and importing it on the computer with a problem,
but the spreadsheet still is not in the userform.