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

Thanks for your help John, Bryan and Kath.  It was the Excel 
references.  At least I know what I am dealing with.

David

At 21/05/2003, you wrote:
>Dave,
>
>It's basically changing your dim statements from Excel objects to just
>Object, like this:
>
>Dim objXLS as Excel.Application
>Dim objBook as Excel.Workbook
>Dim objSheet as Excel.WorkSheet
>
>To
>
>Dim objXLS as Object
>Dim objBook as Object
>Dim objSheet as Object
>
>
>
>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:52 PM
>To: accessd at databaseadvisors.com
>Subject: RE: [AccessD] Installation works on XP, not on 2K - References?
>
>
>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
>
>_______________________________________________
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com