| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
macro doesn't work on Excel for the mac but works on Windows XL??
I just tried running a macro and got the following error:
"Run time error '1004': Methos 'Refresh' of object '_QueryTable' failed" This same macro runs fine on a Windows computer. The macro code in question is: Set qt = ActiveSheet.QueryTables.Add(Connection:=connectstr ing, Destination:=ActiveSheet.Range("tickers").Offset(0 , 1)) With qt .Name = "T1" .AdjustColumnWidth = False .RefreshStyle = xlOverwriteCells .RefreshOnFileOpen = False .Refresh End With Ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| autofilter problem in Mac, but works in Windows, Excel 2003 | Excel Discussion (Misc queries) | |||
| Macro works Macro does not work | Excel Discussion (Misc queries) | |||
| macro which works in excel 2000 does not work in excel 2002 | Excel Programming | |||
| Simple Macro, works in Excel 2002, 2003 but won't work in 2000 | Excel Programming | |||
| Automation error -2147417848 on windows 98 while using excel in VB ( works fine in XP) | Excel Programming | |||
Threaded Mode
