Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Excel XMLMAPS error handling?

The code below works when the webpage serving the XML is up and
functional.
What I cant figure out is how to handle situations where strURL isnt
accessable

1) Internet is down
2) no internet connection at all
3) web server is down or spits an error rather than XML

The behavior Id want ideally is for XMLMAPS to NOT import a blank data
set if strURL doesnt deliver an XML feed. As it stands XMLMAPS
replaces existing data with NOTHING when it cant retrieve the XML. I
*DO* want XMLMAPS to replace existing data when it can retrieve the
XML... thoughts?

<EXCEL VBA Code

SectionName = TESTMAP
strURL =
http://eve-central.com/api/marketsta...8&typeid=11486

ActiveWorkbook.XmlMaps(SectionName).Import strURL, True

</Excel VBA Code
Reply
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
Error on Excel 2003 Workbook_Open XmlMaps John M[_6_] Excel Programming 1 November 24th 06 04:51 PM
Error handling in VBA 6.3 in Excel 2002 Bonsai Bill Excel Programming 2 August 18th 06 11:32 PM
Error handling with a handling routine ben Excel Programming 0 March 15th 05 03:01 PM
Excel VBA - Error handling problem brutalmetal[_2_] Excel Programming 2 January 21st 04 03:17 AM
Excel Error Handling brutalmetal Excel Programming 1 January 13th 04 02:11 PM


All times are GMT +1. The time now is 12:34 AM.

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

About Us

"It's about Microsoft Excel"