![]() |
| |||||||
Workspace Macro Post messages and questions related to Macro Recorder or Windows Macro here. |
![]() |
| | LinkBack | Thread Tools | Display Modes |
| |||
| I am evaluating the trial version and I\'ve run into a problem. I have a file containing 200 plots. I need to open each plot (it opens in Paint Shop Pro), resize the plot, save it, move to the next plot and repeat the cycle. So far I have been able to get the program to recognize/record opening the plot, resizing it and saving it but it will not repeat the cycle for the remaining plots. This program seems promising but if I can\'t get it to cycle thru the 200 plots |
| |||
| Yes. You can certainly do that using Workspace Macro. Below is an example of how you can record your actions for 1 file. And then use repeat functionality to do this for you for all files. Below is an example of how you can record your actions for 1 file. And then use repeat functionality to do this for you for all files. 1) Before you record, open the folder where all your files reside. Select the 1st file. 2) Go to Workspace Macro and click 'NEW' to start recording the macro. 3) Click on the folder window in taskbar so that folder window has the focus (taskbar is the bottom bar where all windows are shown). It is important that you don't click within the folder again. (This may become clear later on when we use it with repeat) 4) Click 'ENTER' to open the file. 5) Perform required actions on the file you opened in step #4. (For example insert your copyright notice, or replace all occurrence of one word by other, or save it as another format, what ever your task happens to be). Save the file and Close it. 6) Press down arrow key in folder window where all the files are there so now focus will be on the next file. 7) Stop and save the macro. 8) Set repeat count to how many files you want to make the change. As you probably noticed as part of the macro in step #6 you are changing to the next file using arrow key. Repeat feature will do the rest. |
| |||
| This is really helpful, I am trying to do something similar. I have a follow up question. My job requires the steps within each document to be repeated a different number of times before moving on to the next document. I'm copying text from word over to powerpoint. Each word document needs to be copied page by page into the powerpoint presentation. On one word document, I have 10 pages and need to copy 10 times before saving and closing the powerpoint. On the next word document within the folder, I may only need to copy and paste 6 times. I would like the macro to copy and paste each page of the word doc, and then move on to the next word doc when it is done. Does this seem feasible? If so, how would I go about setting it up? Thanks in advance for your help!! |
| |||
| Hello, Are you trying to run same macro for two different word documents? You can only set your macro to repeat for 'N' time so you would not be able to change the repeat time during run time. What you can do is record a macro where you copy text from one page and paste it to powerpoint. You have to set it to repeat for '10' times for one word document. and change it to repeat for '6' times for second word document. Alternatively, you can try our advanced automation software, Automation Anywhere 3.5 that has a lot of several conditional commands that you can use to figure out when to stop the macro. For e.g. if 6th page is the last page and it has some keyword that indicates so, then you make use of the following condition If $Clipboard$ Includes <some text> Then Stop Task End If You can download the Free trial from Automation Anywhere 3.5 from http://www.tethyssolutions.com/automation-software.htm |