Hi, I think you need to change

VBRun>GetXL(xlFile)
to
VBRun>GetXL,xlFile

Let>InitVal1=13.85
Let>RoundOffset=0.84
mdl>{trunc((%initval1%)-(%roundoffset%))+1}

I think you need to pass the variable in the sub call (see x in VB part and extra parameter in VBRun call). VBSTART Sub SendOutlookMail(x) Set objOutlook = CreateObject("Outlook.Application") Set objMailItem = objOutlook.CreateItem(0) ' // Option Values for Outlook Object CreateItem( ) are: ' // 0=M...

Sometimes I have had problems with hidden windows confusing my script. Then I try to look for visible windows only by adding Let>WF_TYPE=2 before the SetFocus. Not sure if the issue here, but maybe worth trying, also adding a wait before the ENTER. Let>WF_TYPE=2 SetFocus>Question -- Webpage Dialog* ...

The variable r is used twice (repeat counter and result of WriteLn) and gets reset to zero in the loop. This leads to a loop doing the same thing each time.

Small adjustment to cover either of "-", ":", or " ". Since you are new to RegEx, it is very powerful, but you have to be careful how you structure them so you don't get wrong results. The code below would work well for simple strings, starting with the ID. (If you have longer strings with several "...

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") ...