Macro Recording and Automating Windows with Macro Scheduler – Tips & News
Thanks to Alberto Voli for this little tip. The code below can be used to print an Excel file without having to manipulate the printer dialogs. It uses VBScript to interface with Excels’ COM object model to call it’s PrintOut method. Place the VBSTART .. VBEND lines near the top of your script ready for […]
I’m often asked how to make a macro behave differently based on certain criteria. The power and flexibility of Macro Scheduler makes this an easy task. There are hundreds of different reasons you might want to do this. Maybe it’s dependent on : The answer to a question. The success/failure of an operation. The contents […]
This has come up a few times lately so I thought I’d post it here. One or two people have been asking about writing a Macro Scheduler script that performs a Google search and pulls back the resulting URLs. They have discovered that trying to automate Google can be awkward because of the dynamic nature […]
How do you make compiled macros respond to hotkeys? Here’s how: http://www.mjtnet.com/blog/2007/11/20/exes-and-hotkeys/
Dorian has just uploaded a video demonstrating his Screen Capture and Email script. Nice video, check it out:
Someone asked today how it might be possible to paste what is in the clipboard into an object using Macro Scheduler without having to use keystrokes. It can be done by sending the WM_PASTE message using the SendMessage API function. Here’s an example: //Sending WM_PASTE to an object causes a clipboard paste, like sending CTRL-V […]
In this post from 2008 I demonstrated how to get data from Excel worksheets using Macro Scheduler’s database functions. This works fine if Office is already installed on the PC. But what if you want to get data from an Excel sheet and the PC you are running on doesn’t have Office installed? Well […]
Here’s a small piece of code which will tell you whether the current session is a Remote Desktop/Terminal Services session or not: Let>SM_REMOTESESSION=4096 LibFunc>User32,GetSystemMetrics,isRemote,SM_REMOTESESSION If>isRemote>0 MessageModal>Current Session is RDP/Terminal Services Session Else MessageModal>Current Session is Local Session Endif
Did you know you can make just about any kind of schedule or trigger using Custom Event Triggers? You’ll find the custom trigger option under Macro Properties in the Trigger tab. Parsnipnose3000 has just posted a tip on Custom Event Triggers to the forums, showing how you can have a macro fire based on an […]
It occurred to me the other day while working on a script for a customer that I use this regular expression frequently: (?<=TOKEN1).*?(?=TOKEN2) It is very useful when parsing information out of web pages, or when finding elements in web pages. What it does is pull out all the text between TOKEN1 and TOKEN2. Those […]