+ Reply to Thread
Results 1 to 3 of 3

Porting VBA to MAC - pointers and hints.

  1. #1
    Registered User
    Join Date
    04-09-2012
    Location
    London, UK
    MS-Off Ver
    Excel 2016 Windows
    Posts
    13

    Porting VBA to MAC - pointers and hints.

    Moderators note:
    This thread was provided by Phil, one of our members.
    It contains a link to some handy notes about dealing with Excel for Windows & Mac, both in general and for a particular OSGB Add In.
    --------------------------------------------------------------------------------------------------------------------------------------------------------------------

    I have completed porting an excel/VBA project to MAC. At times it was both frustrating and puzzling - our main problem was the sandbox limitations.
    Ron de Bruin and Nigel Dyer are good references but I felt that I should also document my experience for others' benefit.
    My notes are here, but content is prettier than presentation!

    http://jbhconsulting.co.uk/web-design/PhilBrady
    Hope they help.

    Phil
    Last edited by Richard Buttrey; 12-16-2020 at 10:51 AM.

  2. #2
    Forum Moderator Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,411

    Re: Porting VBA to MAC - pointers and hints.

    Many thanks Phil for a most comprehensive run down on this frustrating subject. Extremely useful.

    I'll make it a Sticky.

    I've occasionally encountered clients who have previously used Excel for Windows but subsequently gave access to a few users who used a Mac - painful.
    After one or two of these I promised myself never to try to develop Excel applications which would be used on both platforms, it was just far too time consuming.

    Mind you that was nowhere near the nightmare when Excel for Mac 2008 was released which dropped VBA completely and overnight Mac clients found they couldn't use macros at all.....!
    Last edited by Richard Buttrey; 12-16-2020 at 10:52 AM.
    Richard Buttrey

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    04-09-2012
    Location
    London, UK
    MS-Off Ver
    Excel 2016 Windows
    Posts
    13

    Re: Porting VBA to MAC - pointers and hints.

    Readers may find this version more readable.
    http://www.haroldstreet.org.uk/osgb/...e-code-to-mac/
    Hope it helps.
    Phil Brady

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Porting Python code to VB?
    By Rhudi in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-26-2016, 01:17 PM
  2. Porting Data from Excel to Word
    By jomili in forum Excel General
    Replies: 14
    Last Post: 12-22-2015, 01:26 PM
  3. [SOLVED] Porting Data Using s Sumif
    By Aussie1 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-18-2013, 07:09 PM
  4. [SOLVED] Issues with porting spreadsheets
    By Frank O in forum Excel - New Users/Basics
    Replies: 12
    Last Post: 08-25-2012, 04:39 PM
  5. Porting VBA to Excel 2010 for 64-bit
    By 6StringJazzer in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-18-2012, 10:51 PM
  6. [SOLVED] Porting Modules
    By Mel Monroe in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-18-2005, 02:05 PM
  7. Why no hints after typing .
    By Mike NG in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-23-2005, 04:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1