Sometimes I have had problem with hidden windows that could confuse what is in focus. Both SetFocus and WaitWindowOpen have the choice to look for visible windows. Not sure if that is an issue here. I have updated my previous code (below) and it works on my machine without any problem. Day>dd Month>...

Hi, I also print to pdf regularly and then to simplify and make my macros more robust I usually set "Adobe PDF" as the default printer. Then it is automatically pre-selected and there is no need for the image recognition. Then for your case it would just be a simple macro like below. (alternatively ...

Hi bstafford,

What you can do is:

PRESS F5 (goto/select range in Excel)
Wait>0.2
SendText>A:A (eg to select A column)
Wait>0.2
PRESS ENTER

Hi, I am not sure which version of Excel you are using but eg in Excel 2010 you could select a cell in the column you want to sort and then access SORT through the key combinations ALT+A+SA (ascending) ALT+A+SD (descending) (ie you press ALT then can access the menus and submenues through letter com...

Hi! One way would be to split the text in two parts and feed them to the mousemove function. Let>blahblahXY="123, 321" Let>delim1=, Let>delim2=" Separate>blahblahXY,delim1,arrItems StringReplace>arrItems_1,delim2,,arrItems_1 StringReplace>arrItems_2,delim2,,arrItems_2 Trim>arrItems_1,arrItems_1 Trim...

There seems to be an issue with the help text when you move over commands using the Command Locator. (I see no help text and the old text box still hangs for some time even when I change and move over a different topic, resulting in a "snake" of text boxes).

It may also help if you concatenate a " in the beginning and end of your path/file name on each row. (""""" & cellRC & """"") plus the trim mentioned above. (ie just create a second column and have MS run on that one).

Not sure of your code, I tried a simple example where I have the file name (with path and proper extension) in one cell in excel and then copy it to the clipboard, then GetClipBoard>test wait>.2 RTrim>test,test wait>.2 ExecuteFile>test And it works fine on my machine (also tried different file types).

Hi jpuziano, For me it works if I add the following to your code: Set xlBook = xlBook.sheets("Exceltest") (ie to add a reference to the sheet in addition to the workbook. Sheet name seems to be the same as the CSV name file). Sub OpenExcelFile(filename) Set xlApp = CreateObject("Excel.Application") ...

After changing the path it all works fine.

VBEval>RuniMacros("mjtnet.iim"),res

Hi, I have a question but not sure if the problem relates to MS or iMacros (I am using MS Pro 12.0.5 and iMacros 7) I am trying the simple MS example they show on their web page (http://wiki.imacros.net/Macro_Scheduler) (see below). When I run the iMacros script (in iMacros) it returns: "Windows Aut...

Maybe you can use the shortcut ALT+D to select the address bar, ie.

Press ALT
SendText>D
Release ALT

Then copy to clipboard etc.