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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
difference between XL VBA on Windows and the Mac???
As answered in .programming:
Excel on a Mac uses the VBA equivalent of Excel 97. In Excel 97, query tables do not have the property AdjustColumnWidth (it was added in Excel 2000), causing the code to fail on the Mac. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Dave F" wrote in message ups.com... 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
difference between XL VBA on Windows and the Mac???
Thanks, Jon.
Unfortunately I didn't see a response to my post in the .programming newsgroup. Dave Jon Peltier wrote: As answered in .programming: Excel on a Mac uses the VBA equivalent of Excel 97. In Excel 97, query tables do not have the property AdjustColumnWidth (it was added in Excel 2000), causing the code to fail on the Mac. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "Dave F" wrote in message ups.com... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|