Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
difference between XL VBA on Windows and the Mac???
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? |