search

VBA-tools / VBA-JSON

JSON conversion and parsing for VBA
MIT License
1.76k stars 568 forks source link

Syntax Error #165

Open Dvanoverbeke opened 4 years ago

Dvanoverbeke commented 4 years ago

I have attached a photo of the issue. Capture Thanks

PerditionC commented 4 years ago

Looks like you copied the urls and that replaced the & with & so change those back to &. May not be only issue, but quick glance that will cause you a syntax error.

PerditionC commented 4 years ago

One of those & should be & amp; :-)

Dvanoverbeke commented 4 years ago

Can you please specify where the error is for me?

strUrl = "https://maps.googleapis.com/maps/api/directions/json?origin=" & orgin & "&destination=" & destination & "&key=" & apikey

Thanks!!

On Thu, Apr 9, 2020 at 4:15 PM Kenneth J Davis notifications@github.com wrote:

One of those & should be & amp; :-)

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/VBA-tools/VBA-JSON/issues/165#issuecomment-611756041, or unsubscribe https://github.com/notifications/unsubscribe-auth/APD37KPJETFM5DSBESRF4BDRLY3GZANCNFSM4ME6L7QA .

PerditionC commented 4 years ago

strUrl = "https://maps.googleapis.com/maps/api/directions/json?origin=" & "&destination=" & destination & "&key=" & apikey

Note how all the & amp; are now just &