Prev: Help in a query
Next: Migrate from Access 97?
From: Stuart McCall on 20 Feb 2010 10:48
"Lauren Quantrell" <laurenquantrell(a)hotmail.com> wrote in message
news:0190d16d-3e0a-47d2-8e88-5a0ba4b906e3(a)y33g2000yqb.googlegroups.com...
> Thanks. Same thing happens when I revert to early binding by the way.
> I'll check Excel/Word automation.

Another thing you could try is to attempt automation from a new database. If
it works ok then your Access file may be corrupt. If so, import everything
from your original db to this new one and try it out.


From: Lauren Quantrell on 20 Feb 2010 12:12
Thanks, I hadn't thought of that. Easy enough just to take a file from
a WinVista System running Access 2003/Outlook 2007 where it works fine
and check. I was thinking it's an Access 2007 bug.
From: Lauren Quantrell on 20 Feb 2010 12:24
Checking automation with Excel:

Dim objXL as Object
Set objXL = CreateObject("Excel.Application")

Above works whether or not Excel is open.

Set objXL = GetObject(, "Excel.Application")

Above fails always.

Set objXL = GetObject("", "Excel.Application")

Above works always (Excel is open or Excel is closed).

So Automation is working differently for Outlook 2007 than it is for
Excel 2007.



From: Stuart McCall on 20 Feb 2010 13:00
"Lauren Quantrell" <laurenquantrell(a)hotmail.com> wrote in message
news:90eeb854-aecd-4b9f-9a9e-5868b210be92(a)a18g2000yqc.googlegroups.com...
> Checking automation with Excel:
>
> Dim objXL as Object
> Set objXL = CreateObject("Excel.Application")
>
> Above works whether or not Excel is open.
>
> Set objXL = GetObject(, "Excel.Application")
>
> Above fails always.
>
> Set objXL = GetObject("", "Excel.Application")
>
> Above works always (Excel is open or Excel is closed).
>
> So Automation is working differently for Outlook 2007 than it is for
> Excel 2007.

Was this code executing in your original db or a new one?


First  |  Prev  | 
Pages: 1 2
Prev: Help in a query
Next: Migrate from Access 97?