Jim Lawrence
accessd at shaw.ca
Fri Sep 28 12:52:37 CDT 2007
Hi Arthur: Had a similar error some time ago and it was due to an out-of-scope error. Either the variable/object being addressed is not sufficiently global; the snippet/object that spawned the variable/object is closed/being closed or is unreachable. It may be just an error caused by not closing objects in the correct order... an Excel thing. HTH Jim -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller Sent: Friday, September 28, 2007 6:09 AM To: Access Developers discussion and problem solving Subject: [AccessD] Object variable or With block variable not set I'm getting this message in running some code in Excel. Everything appears to work fine but I get this message at the end of the run. No idea why. Any suggestions? TIA, Arthur -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com