[AccessD] OT: Excel Goto method

Jim DeMarco Jdemarco at hshhp.org
Tue Aug 12 10:29:01 CDT 2003


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/cadbb562/attachment-0001.html>


More information about the AccessD mailing list