QUOTE(screwedpeep @ May 21 2017, 09:27 PM)
If you check on first page, our sifu did mention this:
You can use macro on OSX but macro on OSX relies on different applications as to macro on Windows. So need to tweek the coding to make your macro Excel work on OSX.
TL;DR: macro running on Windows won't directly be able to run on OSX.
I think I've gotten around the issue with my macro Excel, after 2 nights of tweaking, trial and error
i'll update my tweaked code here later on for reference.
EDIT:
After latest update of MO 2016 for Mac, the macro Excel uploaded by ]@polarbearz] and idyllrain somehow can't work, with this error popping out:
I updated the declare statement with "PtrSafe" attribute, and updated LONG arguments for pointers with LONGPTR. My coding as below. Reference for declare statement update is HERE and for "long" arguments is HERE
The tweaked code is here:
TBH, i'm not sure if i have amended all necessary LONG arguments but it works and i'll let it be until next error
I see. Thanks.» Click to show Spoiler - click again to hide... «
You can use macro on OSX but macro on OSX relies on different applications as to macro on Windows. So need to tweek the coding to make your macro Excel work on OSX.
TL;DR: macro running on Windows won't directly be able to run on OSX.
I think I've gotten around the issue with my macro Excel, after 2 nights of tweaking, trial and error
EDIT:
After latest update of MO 2016 for Mac, the macro Excel uploaded by ]@polarbearz] and idyllrain somehow can't work, with this error popping out:
» Click to show Spoiler - click again to hide... «
I updated the declare statement with "PtrSafe" attribute, and updated LONG arguments for pointers with LONGPTR. My coding as below. Reference for declare statement update is HERE and for "long" arguments is HERE
The tweaked code is here:
» Click to show Spoiler - click again to hide... «
TBH, i'm not sure if i have amended all necessary LONG arguments but it works and i'll let it be until next error
May 22 2017, 09:12 AM

Quote
0.0215sec
0.81
6 queries
GZIP Disabled