+ Reply to Thread
Results 1 to 3 of 3

Macro works under Excel 2010 but not Excel 2013

  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.

  2. #2
    Forum Expert
    Join Date
    10-02-2014
    Location
    USA
    MS-Off Ver
    2016
    Posts
    1,222

    Re: Macro works under Excel 2010 but not Excel 2013

    Its likely they are using an invalid path and/or file name or that it doesnt match the actual location. Id start by confirming they have it setup correct and that the provided path/file name are correct. It looks like when it breaks its not returning a file name or length of the name so its likely ProcFn = Dir() is returning "" likely because it cant find the file at the path.

    Also, VBA is not one size fits all, there is no guarantee that it will work across versions. It should, but sometimes you need to alter the code to work in another version.

    A picture of a snippet of code doesnt really help terribly much in troubleshooting. We cant see content on sheets that feed it, we cant see other code that may impact it, etc.

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

    Re: Macro works under Excel 2010 but not Excel 2013

    Hi Zer0Cool -- thanks for your response. I've uploaded everything you need, and have modified my original post accordingly.

+ 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. 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