[AccessD] Excel Code

Erwin Craps Erwin.Craps at ithelps.be
Tue Aug 5 00:35:12 CDT 2003


Late binding is ok...


-----Original Message-----
From: Bob Heygood [mailto:bheygood at abestsystems.com] 
Sent: Tuesday, August 05, 2003 2:30 AM
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] Excel Code


Hey Erwin,
Got it.

Should have been:

Set xlsheet = xlbook.Worksheets("Whatever")

Yes, I will be careful to include closing/setting to nothing all the
objects when done. Unfortunately I have to use late binding to
accommodate users with different versions of Excel.

Thanks again for your time and help.

Bob


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


More information about the AccessD mailing list