LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10
Default error handling not working

I am using a get external data function to data mine a site that doesn't
seem to stay up. I would like my error handler to wait 5 min. and try again.
The issue I have is that I keep getting a runtime error even though I have
an on error statement. Any ideas are greatly appreciated.

The run-time error is created on both Excel 2000 and Excel 2002.

On Error GoTo lookupq
lookupq:

With Selection.QueryTable
.Connection =
"url;http://yp.yahoo.com/py/ypResults.py?...080&cs=5&ed=Sn
0nqK1o2Tw0.9HPRRleuMAQeeYXa9fQwG42xMx_8nidwQ--&tab=B2C&stx=85537085&stp=y&de
sc=All+Churches&stat=ClkNxtUpper&ls=&lp=&zip=" + CStr(zip) + "&offset=" +
CStr(Offset)

'http://yp.yahoo.com/py/ypResults.py?Pyt=&zip=80210&country=us&msa=2080&cs =5
&ed=Sn0nqK1o2Tw0.9HPRRleuMAQeeYXa9fQwG42xMx_8ni dwQ--&tab=B2C&stx=85537085&st
p=y&desc=All+Churches&stat=ClkNxtUpper&ls=&lp=

'http://yp.yahoo.com/py/ypResults.py?Pyt=Typ&zip=80210&country=us&desc=All +C
hurches&offset=20&FBoffset=0&toggle=&stat=ClkNxtUp per&ls=&lp=
.WebSelectionType = xlAllTables
.WebFormatting = xlWebFormattingNone
.WebPreFormattedTextToColumns = True
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = False
.Refresh BackgroundQuery:=False
End With


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Handling #NUM! error Michel Khennafi Excel Worksheet Functions 1 February 26th 07 08:49 PM
error handling off?? Tom Ogilvy Excel Programming 0 August 19th 04 04:31 PM
Error handling Gareth Excel Programming 1 July 11th 04 07:34 PM
Error handling V. Roe Excel Programming 2 February 27th 04 08:04 PM
Error Handling Todd Excel Programming 1 February 13th 04 11:29 PM


All times are GMT +1. The time now is 05:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"