JezJamesBrown
New Member
- Joined
- Oct 25, 2016
- Messages
- 5
Hi everyone,
was wondering if someone could help me, i created a macro on excel 2016 on my Mac, which will import data from another work book that is not open. It works perfectly.
Now, the problem i have is when i sent it to my colleagues Mac who has excel 2011 installed everytime she runs the macro, its REALLY clunky and takes ages and also the data thats copied over has errors with it.
Is there something im missing? are there any changes thats needed to allow it to work on excel 2011?
Sub Import_Data()
Dim mydata As String
mydata = "='Macintosh HD:Users:name:Downloads:[ daily data file.xls]before'!$A$1:$AK$6"
With ThisWorkbook.Worksheets(2).Range("A1:AK6")
.Formula = mydata
.Value = .Value
End With
End Sub
Thanks in advance
was wondering if someone could help me, i created a macro on excel 2016 on my Mac, which will import data from another work book that is not open. It works perfectly.
Now, the problem i have is when i sent it to my colleagues Mac who has excel 2011 installed everytime she runs the macro, its REALLY clunky and takes ages and also the data thats copied over has errors with it.
Is there something im missing? are there any changes thats needed to allow it to work on excel 2011?
Sub Import_Data()
Dim mydata As String
mydata = "='Macintosh HD:Users:name:Downloads:[ daily data file.xls]before'!$A$1:$AK$6"
With ThisWorkbook.Worksheets(2).Range("A1:AK6")
.Formula = mydata
.Value = .Value
End With
End Sub
Thanks in advance
