| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro and Edit query help
Is this right? what am i missing? it does not seem to work. I'm usin
Office system 2003 Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address = "$C$3" Then With QueryTables("myQueryTable") .Connection "URL;http://table.finance.yahoo.com/d?a=...&g=d&s=)" & _ CStr(Range("C3").Value) & "&d=t" .Refresh False End With End If End Su -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Query Wizard Cannot Be Used To Edit This Query | Excel Discussion (Misc queries) | |||
| why does edit query button not open query | Excel Discussion (Misc queries) | |||
| MS Query - unable to edit query | Excel Discussion (Misc queries) | |||
| Problem with MS Query - can't edit query | Excel Discussion (Misc queries) | |||
| Excel open an existing MS Query in edit mode via macro attached to a button. | Excel Programming | |||
![qitrader888[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
