+ Reply to Thread
Results 1 to 2 of 2

Macro files are not running in Excel 2016

  1. #1
    Forum Contributor PRADEEPB270's Avatar
    Join Date
    02-19-2010
    Location
    INDIA
    MS-Off Ver
    MSoffice-2010
    Posts
    292

    Macro files are not running in Excel 2016

    I have 48 macro enabled files which was created in 2013 excel version.

    Now,I have shifted to excel 2016 version.But No VBA or macro-enabled files are working on excel 2016.

    Can anyone help me ? How will it work on 2016 excel version ?

    I have insert developer tab on excel file.
    Regards


    Pradeep Kumar Gupta
    Gurgaon ( INDIA )

  2. #2
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,783

    Re: Macro files are not running in Excel 2016

    My first guess is that it sounds like you shifted from 32-Bit Excel 2013 Version to a 64-Bit 2016 Version.. But this should impact only certain files that use 32-Bit components that aren't available in 64-Bit Excel.

    However, you will have to tell us a bit more about the issue. Can you tell what error code you are getting? Also, the line of code that is erroring out.
    Last edited by NeedForExcel; 01-13-2020 at 07:12 AM.
    Cheers!
    Deep Dave

    www.NeedForExcel.com

+ 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. I'm having trouble running a VBA macro in Office 2016 on 64-bit MacOS
    By headcase in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-26-2018, 02:20 AM
  2. excel 2016 stops running(crashes) after running VBA that was working fine on previous vers
    By lauriejerome in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-08-2017, 01:51 PM
  3. [SOLVED] EXCEL 2016 workbook_open not running
    By cchen212 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-21-2016, 06:47 PM
  4. troubles with running a plug-in in excel 2016 on a 64 bit system (mac)
    By samsonicx in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-12-2016, 03:28 AM
  5. [SOLVED] Need help batch running an excel macro on .csv files and saving back to the same .csv
    By OutKlast in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-31-2013, 09:16 PM
  6. Replies: 2
    Last Post: 11-26-2012, 08:33 AM
  7. How to work on other excel files while running a macro?
    By manohar.sv in forum Excel General
    Replies: 3
    Last Post: 12-02-2008, 07:34 AM

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