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

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