+ Reply to Thread
Results 1 to 5 of 5

Macro that worked fine, now crashes after running macro on new laptop/installation

  1. #1
    Registered User
    Join Date
    12-08-2017
    Location
    VA, USA
    MS-Off Ver
    Excel 2016
    Posts
    17

    Question Macro that worked fine, now crashes after running macro on new laptop/installation

    I was using a workbook just fine on an old machine running Excel 2016, but now with a new installation, excel crashes every single time this line is run within a macro. Is there something I am missing that I need to install on the new machine that let's it process successfully like before? The java runs fine via command prompt outside of excel.

    'appending the command prompt
    Shell "cmd.exe /K echo *** Date: %DATE:/=-% and Time:%TIME% *** >> C:\EDITPDF\output.log" & " && java -jar C:\EDITPDF\editpdf.jar " & Chr(34) & saveFile & Chr(34) & " >> C:\EDITPDF\output.log" & " && echo. >> C:\EDITPDF\output.log" & " && echo. >> C:\EDITPDF\output.log", vbNormalFocus
    End Sub

    I appreciate any help!

  2. #2
    Valued Forum Contributor
    Join Date
    12-22-2015
    Location
    HK
    MS-Off Ver
    2010
    Posts
    532

    Re: Macro that worked fine, now crashes after running macro on new laptop/installation

    Check driver C has folder "EDITPDF" or not.

  3. #3
    Registered User
    Join Date
    12-08-2017
    Location
    VA, USA
    MS-Off Ver
    Excel 2016
    Posts
    17

    Re: Macro that worked fine, now crashes after running macro on new laptop/installation

    Quote Originally Posted by ikboy View Post
    Check driver C has folder "EDITPDF" or not.
    Yep, I checked that. I copied the original directory right into the C:\ drive like before.

  4. #4
    Registered User
    Join Date
    12-08-2017
    Location
    VA, USA
    MS-Off Ver
    Excel 2016
    Posts
    17

    Re: Macro that worked fine, now crashes after running macro on new laptop/installation

    Also, even though both excel versions are the same, Windows changed from 7 to 10.

  5. #5
    Registered User
    Join Date
    12-08-2017
    Location
    VA, USA
    MS-Off Ver
    Excel 2016
    Posts
    17

    Re: Macro that worked fine, now crashes after running macro on new laptop/installation

    Weirdest thing. I did a reinstall last night and worked again. Then this morning it starting having the same problems all over again....

+ 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. 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
  2. [SOLVED] Macro worked, but now crashes my workbook.
    By taylorsm in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-27-2017, 04:41 PM
  3. 2003 Macro is not running fine in 2010 why?
    By latifpatel.t in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 09-09-2016, 05:12 PM
  4. URGENT: Macro That Worked Fine Not Working Now - No Changes Made To Code
    By stevevb in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 05-19-2013, 05:49 PM
  5. Macro runs fine when I step through with F8, but crashes Excel when I run it
    By ncalkins in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-01-2012, 09:18 PM
  6. Excel 97 not running macro that runs fine in 2000
    By Rich J in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-22-2006, 02:50 PM
  7. Loop in my macro doesn't seem to be running; however, it compiles fine...
    By Goobies in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-01-2006, 09:00 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