[AccessD] OT: Excel Goto method

Nope, that construction is OK.
 
Turns out I had a hanging Excel process - doh!
 
Thanks for the suggestion
 
Roz
 
-----Original Message-----
From: Jim DeMarco [mailto:Jdemarco at hshhp.org] 
Sent: 12 August 2003 16:29
To: Access Developers discussion and problem solving
Subject: RE: [AccessD] OT: Excel Goto method
 
Maybe oApp should be :
 
Set oApp = CreateObject("Excel.Application") 'or GetObject
 
HTH, 
Jim DeMarco 
Director of Product Development 
HealthSource/Hudson Health Plan 
-----Original Message-----
From: Roz Clarke [mailto:roz.clarke at donnslaw.co.uk]
Sent: Tuesday, August 12, 2003 11:12 AM
To: AccessD (AccessD at databaseadvisors.com)
Subject: [AccessD] OT: Excel Goto method
Any Excel gurus out there who can tell me why this:
oApp.Goto Reference:=shtCurr.Range("qryF1")
would return an 'Application-defined or object-defined error'??
TIA
Roz
(PS the full code is
    Set oBook = GetObject("I:\IT\Systems Dev\Jobs\821GFGMIS\BBS Format UKI
Donns.xls")
    Set oApp = oBook.Parent
    Set shtCurr = oBook.Sheets(Format(Forms!frmGreenFlag!txtBeginningDate,
"mmmm"))
    
    oApp.Goto Reference:=shtCurr.Range("qryF1")
with qryF1 being a single-cell range which exists on all the sheets in the
workbook.)


****************************************************************************
*******
"This electronic message is intended to be for the use only of the named
recipient, and may contain information from Hudson Health Plan (HHP) that is
confidential or privileged. If you are not the intended recipient, you are
hereby notified that any disclosure, copying, distribution or use of the
contents of this message is strictly prohibited. If you have received this
message in error or are not the named recipient, please notify us
immediately, either by contacting the sender at the electronic mail address
noted above or calling HHP at (914) 631-1611. If you are not the intended
recipient, please do not forward this email to anyone, and delete and
destroy all copies of this message. Thank You".
****************************************************************************
*******
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030812/28aae7ac/attachment-0001.html>