Working with mutiple files

[omacron77]

Can someone explain to me if and how to have Workspace Pro select a file to work with, do what ever process the macro is designed to do and then select the NEXT file in sequence and then continue?

I can create the macro to select a file, do its processing but of course when it repeates it selects the same file not the next one. I want it to increment to the next file in the folder for processing.

Can anyone offer any insite to this?

[forumstaff]

Hello,

We would like to suggest you to try using Keystrokes rather than mouse clicks, as mouse clicks are specific to screen coordinates and if you move your mouse while the macro runs, it will lose its trajectory and ultimately result into failure of macro. Keystrokes do not depend on screen coordinates and provides us flexibility to use it for different files.

For example in your case, follow bellow mentioned steps:

1. Keep that folder open where your files are placed and select first file.(Please make sure the files are in list view for better navigation of keystrokes)
2. Start recording macro.
3. Using the keystrokes like ENTER (to open file), Ctrl+A (to select all content), Ctrl+C (to copy content), Alt+ [Tab](To navigate to another file), Ctrl+V(past copied values), Altr+F4(to close the file ) and so on to make your task work accordingly.
4. Once we are done with our required process use, return to the folder where the file is being selected. Finally hit “Down arrow” key so that the next file is selected and stop the recording.
5. Now you can set the repeat option for your required number of times and run the macro.

Please let us know how it goes.