| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
ODBC excel Macro help needed
Dim qt As QueryTable
Set qt = Worksheets("Sheet1").QueryTable(1) With qt .Connection = "ODBC;DSN=CommerceCenter;DATABASE=CommerceCenter;T rusted_Connection=Yes" .CommandText = "SELECT * FROM CommerceCenter.dbo.p21_view_inv_mast WHERE condition op value" .Refresh BackgroundQuery:=False End With -- Regards, Bill Renaud |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Macro Needed | Excel Discussion (Misc queries) | |||
| Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
| Excel Macro VBA Help Needed | Excel Programming | |||
| Macro needed to set macro security in Excel to minimum | Excel Programming | |||
| help needed with excel macro | Excel Programming | |||
Threaded Mode
