Vba Excel Code That You

For a better experience, please enable JavaScript in your browser before proceeding.

Vba Excel Code That You

I was wondering if the syntaxcode that you write on a Mac is different than it written on a PC Ultimately, I need to be able to write VBA on a PC, but if its the same on both then its no problem.

I know a little bit of HTML and the basics of SQL, if that helps.

In Excel 2011 for Mac, Microsoft has re-introduced VBA, and its even finally the same version of VBA that Excel for Windows has been using all along.

However, there are a substantial number of differences in how Excel itself behaves between the two platforms, and in how VBA interacts with these platforms.

Ive only done enough testing to know its going to be a lot of work to make my stuff compatible.

I have attached sample data, i need someone to help me convert the left side to how the data looks on the right.

The only problem is he has a MAC and we have not been able to load it on the MAC.

Do we need to package it first into some format What can we do to get the file open Please let me know our best course of action.

Apple had decided they did not need VBA as there is a good Apple macro system.

The latest version of Excel supports macros again, i am lead to believe.

I dont understand what you mean with he is actually running numbers.

I meant that he is running the MAC spreadsheet program Numbers.

If it is an Apple product for sure it will only support AppleScript.

See also this page - no mention of macros, only compatability with.xlsx workbooks.

The Numbers interface is simple and attractive, but its capabilities are minimal.

The mac version of Excel supports.xlam.xlsb so your projects can be made to work cross platform.

You have to be careful you dont accidentally force your code to be Windows-only.

Including any Active-X controls will fail, as this open source technology was never ported to the Mac.

Vba Excel For Mac