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!
Bookmarks