[AccessD] Object variable or With block variable not set

max.wanadoo at gmail.com max.wanadoo at gmail.com
Fri Sep 28 09:04:26 CDT 2007


Given what you have just said, it might be that the first sub down actually
uses the SAME object set in the main code, then releases it on exiting, thus
the main code no longer has the object.
Max
 

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Friday, September 28, 2007 2:50 PM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Object variable or With block variable not set

The code is way too long for a message here, Bryan. The up-side is that it
runs and does what it's supposed to. It opens about 100 Excel files, grabs
information from them and creates a new file with 50-odd pages. All the
things the code does are encapsulated in subs; it's the outermost one that
breaks. It's weird but it must have to do with the "set x = nothing"
statements at the end. Breakpoints are in order, I guess, and
single-stepping.

Arthur

On 9/28/07, Bryan Carbonnell <carbonnb at gmail.com> wrote:
>
> On 9/28/07, Arthur Fuller <fuller.artful at gmail.com> wrote:
> > 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?
>
> Can we see the code?
>
--
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