Results 1 to 3 of 3

Macro works under Excel 2010 but not Excel 2013

Threaded View

  1. #1
    Registered User
    Join Date
    07-10-2005
    Location
    Atlanta
    Posts
    20

    Macro works under Excel 2010 but not Excel 2013

    I've got a macro I developed on my PC (Excel 2010/Windows 2010) for a client who has Excel 2013/Windows Server 2012.

    On my PC, the macro correctly finds workbooks (e.g., 18BC1111.xlsx) in a folder. On her PC, the macro can't find those files.

    The attached picture shows the code snippets (identical on both PC's) and the MsgBox that checks the filename and len(filename) in the folder.

    ==============
    Thanks for your response saying that you needed the entire application. I've just uploaded all that information:

    = Description of how it's supposed to work, in "TheBCarchiveMacro.pdf" READ THIS FIRST
    = The macro-enabled workbook containing the macro: "BCarchive.xlsm"
    = Two test files.

    You should create two folders: Process (containing the two test files), and Archive (which will initially be empty), and then click the icon in "BCarchive.xlsm" to kick off the macro.

    Again, the macro succeeds under Excel 2010/Windows 2010, but failed under Excel 2013/Windows-Server 2012

    Thanks for your help.
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by Carrfamily; 12-09-2017 at 07:06 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro that works in Excel 2010 does not work in Excel 2013
    By karenmwhaley in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-12-2016, 08:12 PM
  2. [SOLVED] Macro to move a row works in excel 2010 but not in Excel 2013
    By mmccra2858 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-31-2015, 05:07 PM
  3. Excel 4.0 macro works in 2010 but is broken in 2013
    By gregsedwards in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-04-2014, 05:48 PM
  4. Excel 2007 works but not 2010 or 2013
    By Miliano in forum Excel General
    Replies: 1
    Last Post: 10-02-2014, 03:20 AM
  5. Replies: 4
    Last Post: 04-10-2014, 12:11 PM
  6. [SOLVED] Macro works in 2010&2013 but not Excel 2003
    By Mattiac in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-06-2014, 03:12 AM
  7. Replies: 10
    Last Post: 08-20-2013, 01:02 PM

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