Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Web Query Comma Parameter Error in MS Excel
Sub keystrokes() ' ' keystrokes Macro ' Macro recorded 2/20/2008 by e023123 ' ' Application.Run "EMS_Reporting_Interface_Client.xls!ShowClientDialog" Range("B25").Select Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True Selection.QueryTable.Refresh...- JosephF
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Web Query Comma Parameter Error in MS Excel
Hello, In Microsoft Excel 2000, I have a web query which has a parameter value of Client. I am linking the parameter to a cell from which I have a mulitselect Client list. The problem is that some of the Clients have a comma in their name and a comma is used to separate one name from another...- JosephF
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
