Converting Excel Macros to run on APPLE MACINTOSH
I have a HUGE Excel VBA Macro that was written under Windows. It reads in a CSV file, changes the content, then writes out a new CSV. Sometimes it reads in .JPG files just to check if they exist. No databases.
NOW I want to run it on a Mac using "Excel for Mac" under OS/X, and not using Parallels, VMware, etc.
SOOOOOO does anybody know what is needed to convert Excel VBA from Windows to MAc/OSX? Offhand the only change I can think of is to change all the "C:" to "Macintosh HD" but I am SURE there is more to it.
OR is the a Converter, or does Excel MAC know how to open & use Macros from an Excel WINDOWS?
--------------------------
Note: Orig Excel VBA/Macro written for Windows XP and Microsoft Office 2000 But runs on most Excel versions. Mac has Excel for Mac 2008 but will upgrade if needed.
NOW I want to run it on a Mac using "Excel for Mac" under OS/X, and not using Parallels, VMware, etc.
SOOOOOO does anybody know what is needed to convert Excel VBA from Windows to MAc/OSX? Offhand the only change I can think of is to change all the "C:" to "Macintosh HD" but I am SURE there is more to it.
OR is the a Converter, or does Excel MAC know how to open & use Macros from an Excel WINDOWS?
--------------------------
Note: Orig Excel VBA/Macro written for Windows XP and Microsoft Office 2000 But runs on most Excel versions. Mac has Excel for Mac 2008 but will upgrade if needed.
Martin Liss
Are you aware that you can run any version of Windows (including all windows software) as a virtual machine on the MAC? I use a piece of software called Parallels and it allows me to seamlessly run Windows XP side by side with Lion.
As you do not want any VM or Parallels I think of only the below steps.
Apple's spreadsheet application, Numbers, can't read macros that are written in VBA.
Consider,
* Use AppleScript to create your spreadsheet macros. This is the built-in Mac OS X scripting language. All iWork '09 applications, including Numbers, support the use of AppleScript.
* Switch to using the previous version of Excel for Mac. Excel 2004 supports the use of VBA macros.
* Convert your Numbers '09 spreadsheet to a Windows Excel spreadsheet format. Open your Numbers spreadsheet, and click "File," then "Save As." Select "Save copy as," and choose Excel Document from the pop-up menu. You can now apply macros to the spreadsheet by opening the spreadsheet with a Windows version of Excel.
Apple's spreadsheet application, Numbers, can't read macros that are written in VBA.
Consider,
* Use AppleScript to create your spreadsheet macros. This is the built-in Mac OS X scripting language. All iWork '09 applications, including Numbers, support the use of AppleScript.
* Switch to using the previous version of Excel for Mac. Excel 2004 supports the use of VBA macros.
* Convert your Numbers '09 spreadsheet to a Windows Excel spreadsheet format. Open your Numbers spreadsheet, and click "File," then "Save As." Select "Save copy as," and choose Excel Document from the pop-up menu. You can now apply macros to the spreadsheet by opening the spreadsheet with a Windows version of Excel.
ASKER
Suvmitra - Good idea ... I would gladly downgrade to Excel for Mac 2004 if that will do the trick with minimal code changes. I'll check ebay/craigslist too see if I can buy a 2004 version.
Martin -thx for the tip ... yes we are running it now using VMware. looking for a 100% Mac solution - long story :-)
Martin -thx for the tip ... yes we are running it now using VMware. looking for a 100% Mac solution - long story :-)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Oh, I'm sorry, I missed the part where you said that you didn't want to use Parallels.