Thread
:
Help on macro coding for URL
View Single Post
#
3
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
external usenet poster
Posts: 10,124
Help on macro coding for URL
I gave you the solution on your OTHER post. Pls don't post in more than one.
Proper place is programming for this
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"Eric" wrote in message
...
Does anyone have any suggestions on following macro coding?
[Working]
With Sheets("Temp").QueryTables.Add(Connection:= _
"URL;http://www.stata.com/help.cgi?macro",
Destination:=Sheets("Temp").Range("$A$1"))
[Not working]
myVariable = "http://www.stata.com/help.cgi?macro"
With ActiveSheet.QueryTables.Add(Connection:= _
"URL;" & myVariable, _
Destination:=sheets("Temp").Range("A1"))
It seems to me that
"URL;" & myVariable is not equal to
"URL;http://www.stata.com/help.cgi?macro".
Do anyone have any suggestions on how to solve it?
Thank you very much for any suggestions
Eric
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett