ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   edit query (https://www.excelbanter.com/excel-programming/273106-re-edit-query.html)

Mark Bigelow

edit query
 
Change this:

myurl = "http://www.m-x.ca/cotes_en.php?query= & Symbol"

to this:

myurl = "http://www.m-x.ca/cotes_en.php?query=" & Symbol

I just moved the quote to the end of the string before you insert the
variable.

Mark
---
Mark Bigelow
mjbigelow at hotmail dot com
http://hm.imperialoiltx.com

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!


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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com