Hi, I was curious to see if one could use RegEx to solve it. Not sure if there are any upper limits when the file gets much larger but for one million lines it will complete it in around 1 second. Let>InputFile=C:\Users\Christer\Documents\testfile.txt Let>OutputFile=C:\Users\Christer\Documents\resfi...

In the separate> line the result will go into the variable file_names, whereas in the subsequent loop you check for the number of items of filenames (filenames_count), ie inconsistent naming of the variable.

Another alternative could be to use RegEx. (I think the XLSheetToArray requires xls format so for new excel files you may need to save as xls) XLSheetToArray>C:\...\Your excelfile.xls,Sheet1,arr Let>tmp2= //Create a string, concatenating the relevant cells separated with commas //If column 7 contain...

Hi, One way would be to do as you suggest, to simply loop over the relevant cells and just add up the numbers. An alternative (since there are so many powerful functions in excel) is to place a formula (in this case COUNTIF) in an empty cell to calculate the value and then bring the result back into...

An alternative (for example if you have variable number of spaces between strings) would be to use RegEx

JRL, many thanks - will help going forward.

Sorry, something happened when I posted it (looked ok in preview)

Let>tmp=R74862 60009AG10C9P 0050
Separate>tmp, ,arrItems

Let>ct=0
While>ctct=ct+1
Messagemodal>arrItems_%ct%
EndWhile

For example:

Let>tmp=R74862 60009AG10C9P 0050
Separate>tmp, ,arrItems

Let>ct=0
While>ctct=ct+1
MessageModal>arrItems_%ct%
EndWhile

I was first playing with pulling also the date information and still had the date format left on (mm/dd/yy). (Admit maybe inconsistent with looking for the time but I did not think the format would affect it)

Hi,

I get an error code if excel is formatted with one of the excel date formats. Unformatted it works well, so format seems to impact (I am using excel 2010)

Microsoft VBScript Compilation error :1006.

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.