Applescript-running script on saving an Excel file

[oyster]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hello, I am trying to have a script run automatically each time the Excel file is saved. The script will duplicate the file to another folder. I have the script working as a drag n' drop applescript application, but I would like to take a step further.

Thanks for any help.

oyster

 

[Jim Gordon MVP]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hello, I am trying to have a script run automatically each time the Excel file is saved. The script will duplicate the file to another folder. I have the script working as a drag n' drop applescript application, but I would like to take a step further.

Thanks for any help.

oyster

Hi Oyster,

You can probably use Automator to accomplish this.

Open the Automator application
Choose Custom
In the Variables box type the word Excel
Drag the Save Excel Workbooks action to the right side
Repeat, so that you now have two Save Excel Workbooks actions on the right.

Click the Run button to run the workflow.

You can save your workflow as a plugin:
From Automator’s menu choose File@@-->Save As Plugin. Change the lower
pop-up to Plug in for: Script menu. Give the plug-in an appropriate
name, as shown, and then click the Save button.

Your workflow will not be on the right-most script menu in your menu bar.

-Jim

 

[Jim Gordon MVP]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)
Processor: Intel

Hello, I am trying to have a script run automatically each time the Excel file is saved. The script will duplicate the file to another folder. I have the script working as a drag n' drop applescript application, but I would like to take a step further.

Thanks for any help.

oyster

Hi Oyster,

You can probably use Automator to accomplish this.

Open the Automator application
Choose Custom
In the Variables box type the word Excel
Drag the Save Excel Workbooks action to the right side
Repeat, so that you now have two Save Excel Workbooks actions on the right.

Click the Run button to run the workflow.

You can save your workflow as a plugin:
From Automator’s menu choose File@@-->Save As Plugin. Change the lower
pop-up to Plug in for: Script menu. Give the plug-in an appropriate
name, as shown, and then click the Save button.

Your workflow will not be on the right-most script menu in your menu bar.

-Jim

 

[oyster]

Hi Jim. Thanks for the reply and help. I will give this a try later tonight and see if that works. It sounds like it will. I didn't think about automator.

oyster

 

[oyster]

Jim, I tried to use Automator, but I do not have Automator support for Excel. I have the student version, which apparently does not include support for Automator. I guess I should be more detailed in the info on which version. I didn't realize there was a difference, but after surfing for a minute I found I was indeed wrong in that assumption.

Any other ideas?

Thanks again for the help.

oyster

 

[Jim Gordon MVP]

Jim, I tried to use Automator, but I do not have Automator support for Excel. I have the student version, which apparently does not include support for Automator. I guess I should be more detailed in the info on which version. I didn't realize there was a difference, but after surfing for a minute I found I was indeed wrong in that assumption.

Any other ideas?

Thanks again for the help.

oyster

Hi,

You can create Automator actions in all editions of Office 2008.

All the editions come with some Automator actions already done for you
except for Home and Student edition, but you can make your own Automator
actions in Home and Student edition.

-Jim