[AccessD] OT: Excel Goto method

Roz Clarke roz.clarke at donnslaw.co.uk
Tue Aug 12 10:11:56 CDT 2003


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.)

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030812/d30ff9b2/attachment.html>


More information about the AccessD mailing list