Please help me get these macros to run better

[beaks3lee]

I have use this program for some time with little problems, then of course we have to upgrade to a new server at work and that changes my desktop and file locations so i had to change every maco i had and i've had trouble ever since then and it's really starting to frustrate me.

I'm running one particular macro where i download an excel sheet from the internet, then import it into ms access. I have this macro running at like 3am b4 i get to work, and it's always running into little problems that make it stop, such as this morning, i got stuck importing the first table into access b/c it claimed it could not find the screen named IMPORT. The frustrating thing is that i run these macros while i'm sitting in front of the computer to make sure they work,,,, and of course they do so i schedule them, and then i come into work next morning and i get something like that. Actually i've gotten a lot of that since the server switch over, workspace cannot find SAVE AS, or IMPORT or cannot locate the file to open, etc. I am not sure how to fix that, or where to go from here...

i record all my macros using the macro editor, i do not use mouse clicks only keyboard controls (alt fo, to open file, ctrl-c to copy, etc. that seems to work much better than the mouse, maybe i should try mouse driven macros?)

Thanks in advance.

[forumsupport]

Hello,

Hello Subbu,

Following are few points that should be considered while recording a macro for its errorless execution.

1) While recording we recommend using more of keyboard short cuts instead of mouse clicks as they are more reliable than mouse moves/clicks irrespective of change in screen resolution or window size. Mouse clicks/moves are subject to work on a screen resolution they were recorded on. However, keystrokes will work as expected no matter whatever screen resolution you set to. For e.g. Up/Down arrow key would work in a reliable way than using mouse to scroll in an excel sheet.

2) While recording after you perform an action, wait for few seconds so that command gets enough time to execute on replay. Insufficient delay can skip any command and hence can mess up the commands. With our advanced macro product, Workspace Macro Pro 6.5, after recording, you can also edit your macro through Tools->Macro Editor to insert Delay command. You can download free version of Workspace Macro Pro 6.5 from our website:
http://www.tethyssolutions.com/macro-automation.htm

3) Here is a link to best practices for our macro products, Workspace Macro 4.6 and Workspace Macro Pro 6.5

http://www.tethyssolutions.com/bestpractices.htm

Hope that helps.