[AccessD] Installation works on XP, not on 2K - References?

Dim objExcelapp As Object
 'show version of excel
'for example Excel XP version 10.0
'grabs last used version or highest version of Excel if multi install of 
Excel dunno?
  On Error Resume Next

Set objExcelapp = CreateObject("excel.application")
If Err.Number Then
     MsgBox "Excel not installed or not registered for Automation"
     Exit Sub
  End If
MsgBox "Excel Version: " & objExcelappVersion
objExcelapp.Quit

Set objExcelapp = Nothing
MsgBox "Excel Version: " & sVersion

David Emerson wrote:

> Do you have any examples of late binding?  The main tasks I am doing 
> is export data to a spreadsheet, then open it up and format it.
>
> David
>
> At 21/05/2003, you wrote:
>
>> Bryan is correct.  Unless you want to manually change the references
>> from Excel 10.0 to Excel 9.0, change your excel code to late binding.
>>
>>
>> John V. Ruff - The Eternal Optimist :-)
>> Always Looking For Contract Opportunities
>>
>> Home: 253.588.2139
>> Cell: 253.307.2947
>> 9306 Farwest Dr SW
>> Lakewood, WA 98498
>>
>> "Commit to the Lord whatever you do,
>>                 and your plans will succeed." Proverbs 16:3
>>
>>
>>
>> -----Original Message-----
>> From: accessd-bounces at databaseadvisors.com
>> [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David Emerson
>> Sent: Wednesday, May 21, 2003 6:00 PM
>> To: accessd at databaseadvisors.com; ACCESS-L at PEACH.EASE.LSOFT.COM
>> Subject: [AccessD] Installation works on XP, not on 2K - References?
>>
>>
>> Crossposted (because it is urgent :))
>>
>> Hello groups.
>>
>> I have an installation created by a sagekey script using Wise
>> Installation
>> v9.  It is an AXP ade connecting to SQL2K.
>>
>> When the program is installed on a machine running Office XP it runs
>> fine.  If the computer only has Office 2K then there seems to be a
>> reference problem because in fields that use Date() to set defaults it
>> only
>> shows #Name.  We tested on a machine that had OXP by downgrading it to
>> O2K
>> and the installation suddenly didn't work any more.
>>
>> The references that appear in the references box are - vbe6.dll,
>> msacc.olb, stdole2.tlb, msado25.tlb, dao360.dll, excel.exe.
>>
>> We have tried registering the files using regsvr.exe but this hasn't
>> helped.
>>
>> Can anyone please provide any things we can try?
>>
>>
>> Regards
>>
>> David Emerson
>> DALYN Software Ltd
>> 25b Cunliffe St, Johnsonville
>> Wellington, New Zealand
>> Ph/Fax (877) 456-1205
>>
>> _______________________________________________
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>>
>> _______________________________________________
>> AccessD mailing list
>> AccessD at databaseadvisors.com
>> http://databaseadvisors.com/mailman/listinfo/accessd
>> Website: http://www.databaseadvisors.com
>
>
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>