[AccessD] Access Function To Create Spreadsheet Fails On 2nd Run

On 12/7/05, Paul Hartland (ISHARP) <paul.hartland at isharp.co.uk> wrote:
> To all,
>
> I think I may have a siilar problem to that post by Lonnie a couple of weeks
> back, I have a function that creates an Excel sheet which I have to call
> twice, once for last weeks figures and once for year to date.....The first
> run works without a hitch (and I close all references to Excel objects etc),
> on the second run I get the error message:
>
>         Run-time error '1004';
>         Method 'Sheets' of object '_Global' failed

Is _Global a global variable?

--
Josh McFarlane

"Peace cannot be kept by force. It can only be achieved by understanding."
-Albert Einstein