How to use Auto Macro Recorder in Excel?
Customer: Thanks, what I mean is how do you make the macro
(that has been recorded via your program) part of my Excel
spreadsheet. Right now I have an Excel spreadsheet that calls
(externally) one of the macros I made using the Auto Macro
Recorder software. The problem is that the way this is done
is by a hyperlink. If I move the files for whaterver reason,
the path will break and I would have to manually go and reconnect
the path for each and every one that I created (which is alot).
Our answer: Auto Macro Recorder's script can NOT be part
of the code in VB, maybe you can call the scp file by using
VB. You said you use hyperlink to call the scp file, so I
suggest you put the excel files and scp files in same folder,
when you insert hyperlink, you don't need to input the full
path, just input the scp file name. Eg: There is a folder
named c:\myfiles You put mydoc.xls and script.scp file in
c:\myfiles When you want to insert hyperlink, in Excel , just
click "Insert" -- "Hyperlink" , then don't browse for file,
just input the filename script.scp Excel will find the script.scp
file in same folder automatically. So even you move the mydoc.xls
and scrpt.scp file to other computer or other folder, if they
are in same folder, it's still OK.
How to use Auto Macro Recorder to judge if webpage has
Customer: I was wondering if there was any script that would
allow for the delay to be until a webpage loads/refreshes.
I need it to be for when the page actually comes up, not for
when internet explorer opens. Could you let me know if this
is doable with your program?
Our answer: The simple solution is: Wait long time enough
to ensure that the webpage loads eg: If normally need 10 seconds
to load the page, when recording you can wait 60 seconds.>Then
when you replay the script, it'll wait 60 seconds and it's
The second solution is "use WAITFORCOLOR command", you need
to edit the >script manually.
See: >//0*0*0 is the waiting color: RGB(0,0,0)
---- Your mouse point to a pixel,if this color = the waiting
color within 100 seconds,then run(notepad) else open c:\read.txt.
To use this, you should move your mouse to point to a special
color on the webpage, use a special script to save the color
into text file using these command: SaveColor(VARSTR) ----Your
mouse point to a pixel,save it's color to a special VARSTR
(AutoRecorder's system use VARSTR ) WriteLine(c:\abcd.txt,VARSTR)
--- Write a log into c:\abcd.txt ,you can input your own strings
or use VARSTR Or use other tools(eg: DreamWeaver) to get the
RGB color value. Then edit the part of replay script manually
to judge if your mouse point to a correct color(that means
the webpage has been loaded), then continue to replay.
There is a example -- wait4blackcolor.scp in installation
folder of Auto Macro Recorder. You can run it to see the result.
Run that script, after 1 second, if you point to a black color,
it'll launch notpad, if you don't point to a black color within
5 seconds, it'll launch Explorer
You can change it to WAITFORCOLOR(0*0*0,50000,doscp(script1.scp),doscp(script2.scp))
to run other script files. (If point to black color, run script1.scp,otherwise
run script2.scp) or WAITFORCOLOR(0*0*0,50000,delay(100),exit())
(If point to black color, run delay 0.1 second and continue
to run the script,otherwise exit AutoMacroRecorder)
How to Power off / Shut down my computer using Auto Macro
Customer:I'm using FTP software or BT software to download
files, I always want Auto Macro Recorder shutdown my computer
after 3 or 5 hours automatically.
Our answer: In Option, Set Repeat Timer = 14400 seconds (
4 hours) Make a shutdown.scp file, content is: poweroff(2)
(Also you can Record your shutdown windows' operation as shutdown.scp)
Run shutdown.scp, Auto Macro Recorder will shutdown my computer
after 4 hours.
How to shut down my computer after I quit my TV card's
application -- WinDVR?
Customer: I sleep on my bed and use TV card to watch TV by
using WinDVR, when I quit WinDVR using remote controler of
TV card, it's so tired to getup to poweroff my computer manually.
Our answer: Run WinDVR to watch TV first. Run Auto Macro
Recorder, press F10 to record, set focus to WinDVR, press
F10 again to save current active window's title. Use notepad
to open the scp file, find that WinDVR's title is "InterVideo
WinDVR". In option,Set Repeat Timer = 30 seconds, set repeat
times = 999999 Make a tv.scp file, content is: IF_WINDOW_EXIST("InterVideo
WinDVR",delay(100),open(shutdown.scp)) Everytime after I start
WinDVR, I'll run tv.scp. Now Auto Macro Recorder check if
WinDVR's windows is exist,if can't find it, Auto Macro Recorder
will shutdown my computer automatically.
How do I determine the caption and class name for a window?
After you press F10 to record, when you press F10 again,
Auto Macro Recorder will save the active window's caption
and class name automatically into the script file. You can
use notepad to open the script file, search "movewindow" to
find out the caption and class name.
How to Lock PC and log in automatically using Auto Macro
Customer: Sometimes I'll leave computer for a while, I want
Auto Macro Recorder lock pc after it complete its job and
log in to continue to do jobs after a timer.
Our answer: "Start" -- "Programs" --
"AutoMacroRecorder" -- "Lock PC" , you
can use this tool to lock pc. We don't suggest you save your
system account information in our script file, it's not safe.
So you can lock pc using our tool and don't need to record
your computer account information.