Excel Auto-Save not working

Questions & Suggestions
,
1

I love the auto-save macro for saving Word documents and wanted one for Excel. It's not working. I've noticed that for whatever reason, the way the script looks refuses to 'stick' and look like the one for Word.

Screen Shot 2017-10-03 at 10.18.10 AM.png1138×982 72.2 KB

The Word macro has italics and colors which the Excel one does not. When I first paste it in and change Word to Excel and Documents to Workbook, it looks fin. But as soon as I click away from the Macro, everything looks like plain text. Any suggestions? Thank you!

2

I don’t think you need to check if Excel is running, since this macro only fires when Excel is active. This should work:

tell application "Microsoft Excel"
	if name of the active workbook does not contain "Workbook" then save active workbook
end tell
3

If the AppleScript wont compile, then Keyboard Maestro cannot syntax color it. Paste it in to Script Editor to find where the error is.

1 Like