Help needed: VBA for Mac 2011

[kyuuten]

Hi guys,

I have a VBA compiled which works fine on PC, but don't know if it works for Mac.
Can anyone help me?

As you can see, the website is a password protected one, so I'd just need the syntax checked.

PS: Crosspost here: http://www.excelforum.com/excel-pro...help-needed-vba-for-mac-2011-a.html?p=3202608

Thanks,
Iulian

With ActiveSheet.QueryTables.Add(Connection:= _
"URL;http://www.gurufocus.com/financials.php?symbol=" & AddSheetQuestion, Destination:=Range _
("$m$2"))
.Name = "financials.php?symbol=" & AddSheetQuestion
.FieldNames = True
.RefreshOnFileOpen = False
.BackgroundQuery = True
.RefreshStyle = xlInsertDeleteCells
.SavePassword = True
.SaveData = True
.WebSelectionType = xlSpecifiedTables
.WebTables = """R1"",""Rf"""
.WebConsecutiveDelimitersAsOne = True
.WebSingleBlockTextImport = False
.WebDisableDateRecognition = False
.WebDisableRedirections = False
.Refresh BackgroundQuery:=False
End With​