+ Reply to Thread
Results 1 to 9 of 9

Excel 365 Error "Variable Uses Automation Type Not Supported in Visual Basic

  1. #1
    Registered User
    Join Date
    04-15-2014
    Location
    Warwickshire England
    MS-Off Ver
    Excel 2010
    Posts
    5

    Excel 365 Error "Variable Uses Automation Type Not Supported in Visual Basic

    I have just subscribed to Office 365 Home for MAC and am unable to use VBA from developer mode. If I go to Developer mode double click on "sheet" from the sidebar to open the VBA modules then select Worksheet from the dropdown list I get a Message Box as follows

    VISUAL BASIC

    Variable uses automation type NOT supported in Visual Basic.

    As I am unable to proceed past this point I am therefore prevented from coding with VBA .

    After searching online it seems there have been very many raising this same problem.

    This leads me to think that this may only be a MAC issue running MS EXCEL , therefore I would like to know from the forum that if I purchase a new PC running Windows 7 Pro or Windows 10 are there any members running Office 365 coding with VBA with this setup ?

    Regards

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex
    MS-Off Ver
    365
    Posts
    5,697

    Re: Excel 365 Error "Variable Uses Automation Type Not Supported in Visual Basic

    I write lots of code using 365 on Win10 machines, both standalone and networked, and I have no such issues.

    The error message you mention is a known problem with Excel on Macs. See the link below for some detail on it and some workarounds.
    https://support.microsoft.com/en-us/...2-d2f1bec0e5ad

    BSB

  3. #3
    Registered User
    Join Date
    04-15-2014
    Location
    Warwickshire England
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Excel 365 Error "Variable Uses Automation Type Not Supported in Visual Basic

    Hi BSB thank you for your fast reply

    It seems it's as I suspected, especially as you say there are no issues with 365 running on your PC under Windows 10.

    On the MAC it's a mess the functionality is terrible there isn't even a user form available within Developer mode to built from.

    I just dont understand where Microsoft are heading to, why destroy a perfectly good tool for Excel and other Office Apps.

    Without having access to the user form also means having to develop other more dificuld time consuming ways of working.


    In Summary I think I might return to a Windows based PC rather than suffer to loss of functionality on the MAC

    Please let me thank you for you response and confirmation that 365 works as normal with Windows 10

    just to confirm are you finding 365 provides you with the User form as it has always been to develop from or has that disappeared on windows PC too.

    Once again thank you for your help

    TT

  4. #4
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex
    MS-Off Ver
    365
    Posts
    5,697

    Re: Excel 365 Error "Variable Uses Automation Type Not Supported in Visual Basic

    I create userforms as a big part of my day job and quite often as part of solutions on this forum, so I can indeed confirm userforms are available on Office 365 on a Win10 system.

    BSB

  5. #5
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    5,586

    Re: Excel 365 Error "Variable Uses Automation Type Not Supported in Visual Basic

    Just FYI, you can use userforms on the Mac, there just still isn't a designer (about 5 years after they said they were working on it, I believe).
    Rory
    I drink, and I know things

  6. #6
    Registered User
    Join Date
    04-15-2014
    Location
    Warwickshire England
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Excel 365 Error "Variable Uses Automation Type Not Supported in Visual Basic

    Hi BSB,

    thanks once again, now you have confirmed the Windows Version of 365 is compliant with User forms in developer deign mode I will revert back to WIndows PC . I just didn't want to revert back to Windows then find there were still issues with VBA in Developer mode etc.

    Shame really and disappointing that Microsoft haven't fully fixed this issue on MAC.

    Your help and advice has been extremely useful.

    Kind Regards

  7. #7
    Registered User
    Join Date
    04-15-2014
    Location
    Warwickshire England
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Excel 365 Error "Variable Uses Automation Type Not Supported in Visual Basic

    Thanks Rorya, for you information, as you can see from my reply back to BSB I have decided not to find work-arounds for what is fundamentally a Microsoft responsibility to fix. I would have been courteous if Microsoft had made this situation known to MAC subscribers thereby preventing this problem in the first place.

    Thanks for your support

    Kind regards

  8. #8
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    2016 primarily
    Posts
    5,586

    Re: Excel 365 Error "Variable Uses Automation Type Not Supported in Visual Basic

    IMO, between Apple's sandboxing and MS lack of interest in VBA generally, developing on a Mac is just too painful.

  9. #9
    Registered User
    Join Date
    04-15-2014
    Location
    Warwickshire England
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Excel 365 Error "Variable Uses Automation Type Not Supported in Visual Basic

    I agree Rorya,
    I ahve Purchased a Windows Laptop and downloaded Office 365, thanks to both BSB and Yourself I now once again have access to VBA

    Last Friday I spent almost 2 hours with Microsoft Support remote connected trying to resove why I was unable to get VBA running on my MAC even reinstalling 365 they too were lost , this is the truth. Thank God for this Forum.


    Thanks Both

+ 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. Replies: 2
    Last Post: 08-30-2017, 10:07 AM
  2. Excel Visual Basic error "Object has disconnected from its clients"
    By shaves in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-23-2017, 10:50 AM
  3. Visual Basic for Applications - Automation error
    By Adrian Parker in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-08-2017, 11:11 AM
  4. [SOLVED] run-time error '13' type mismatch visual basic
    By Michell Feitosa in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-23-2012, 07:42 PM
  5. "Microsoft Visual Basic runtime error '424' object required".
    By SharonG. in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 07-04-2006, 08:40 PM
  6. [SOLVED] Visual Basic macro run time error(13) type mismatch
    By Paul in forum Excel General
    Replies: 0
    Last Post: 10-25-2005, 03:05 AM
  7. [SOLVED] I Visual Basic Error "File Not Found" when Excel opens
    By Brent E in forum Excel General
    Replies: 1
    Last Post: 03-02-2005, 12:06 AM

Tags for this Thread

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