[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?
>