1st attempt using cDataSet's excel pull of REST services - run time error

38 views
Skip to first unread message

merchant...@gmail.com

unread,
May 8, 2013, 11:18:58 PM5/8/13
to excel-r...@googlegroups.com
Hi Bruce et al,

Thanks for the incredible amount of tools you've provided! Lots of these tools that you've described seems to be extremely valuable for a lot of the work I'd like to do!

Unfortunately, I'm hitting the same error when running the tests. I'm attaching the error and the line that seems to be hitting the bug.

I'm wondering if the problem has to do with Excel not being able to connect the internet.. Would love any advice or attempts to try and fix this!

Thanks,
Michael
jsonExcelErr2.png
jsonExcelErr1.png

Bruce McPherson

unread,
May 9, 2013, 3:21:28 AM5/9/13
to excel-r...@googlegroups.com
Hi Michael
Yes it is a connectivity problem. If you look in the debugger immediate window you'll see the URL it was trying to execute I think. Copy that to your browser and see if it works to check connectivity

Bruce

Sent from my iPad
--
You received this message because you are subscribed to the Google Groups "Excel Liberation" group.
To unsubscribe from this group and stop receiving emails from it, send an email to excel-ramblin...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
 
 
<jsonExcelErr2.png>
<jsonExcelErr1.png>

Michael Idris Merchant

unread,
May 9, 2013, 7:52:35 AM5/9/13
to excel-r...@googlegroups.com
Hi Bruce, thanks for the quick response. The URL seems fine. I went as far as making my own addition to the library, supplying the rest call I was trying to query as the URL and putting a dummy character 'a' as the query in the function call. Same issue.

I'm guessing the problem is with excel's connectivity?

Michael

Sent from my iPhone
You received this message because you are subscribed to a topic in the Google Groups "Excel Liberation" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/excel-ramblings/ZfSpgeqZmU4/unsubscribe?hl=en-GB.
To unsubscribe from this group and all of its topics, send an email to excel-ramblin...@googlegroups.com.

Bruce Mcpherson

unread,
May 9, 2013, 9:51:06 AM5/9/13
to excel-r...@googlegroups.com
i guess.. Excel would use IE.. which browser did you try it in? are you at work (is there a proxy) .. can you send me the url.

regards
browser
Reply all
Reply to author
Forward
0 new messages