P
phillman5
I need to make a number of new sheets. I'd like to use the present
sheet as a template, without using the edit/move or copy sheet menu
command. Actually now I'd just like to learn how to better use
automator with Excel. Is there anyplace that shows how to use the
actions installed with Excel?
The "Add New Sheet to Workbooks" action has the description:
This action inserts either a blank sheet or the specified sheet
from an open Excel workbook into
the Excel workbook passed from the previous action. Version
1.1. Copyright © 2007 Microsoft
Corporation. All rights reserved.
Input: Excel workbooks
Result: Excel sheets
At the top of this action are fields labeled "Sheet name" & "Sheet
number". These give the new sheet a name and location, but the
active sheet is not copied
How do I specify the sheet to copy? I don't see an action for that.
I always just get a new blank sheet. Although I don't think I need
now, what action do you use to pass the Excel workbook name to receive
the new sheet?
sheet as a template, without using the edit/move or copy sheet menu
command. Actually now I'd just like to learn how to better use
automator with Excel. Is there anyplace that shows how to use the
actions installed with Excel?
The "Add New Sheet to Workbooks" action has the description:
This action inserts either a blank sheet or the specified sheet
from an open Excel workbook into
the Excel workbook passed from the previous action. Version
1.1. Copyright © 2007 Microsoft
Corporation. All rights reserved.
Input: Excel workbooks
Result: Excel sheets
At the top of this action are fields labeled "Sheet name" & "Sheet
number". These give the new sheet a name and location, but the
active sheet is not copied
How do I specify the sheet to copy? I don't see an action for that.
I always just get a new blank sheet. Although I don't think I need
now, what action do you use to pass the Excel workbook name to receive
the new sheet?