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.
