Hi, I have not had a chance to go through the script in detail but just a quick example producing the pivot layout you looked for. (Opening an excel sheet, assuming the source data is in Sheet1, starting in cell A1): Segment Amount 1 Amount 2 Corp 100.00 100.00 Elect 200.00 200.00 Corp 100.00 0.00 E...

Hi, have you tried to put curly brackets around the expression (has solved it for me when I had the problem)? Not sure if there is a different global way to do it.

let>amount={%r1%-1,50}

Hi, Not sure if you can use the IE[0]/currIE handles directly. If you get a handle through GetActiveWindow then it works better. IECreate>IE[0] Let>currIE=IE[0] Let>WIN_USEHANDLE=1 GetActiveWindow>strTitle,nXPos,nYPos,, Let>currURL=www.wsj.com IENavigate>currIE,currURL,res IEWaitDocumentComplete>cur...

Hi, My understanding is that you could arrange SK_DELAY to be random, however, if you use Send> then one SK_DELAY would apply to the whole text in the Send command (so the delay would be the same for each character). If you want separate delays for separate characters then I think you could to do so...

Hi, I modified it slightly, hope it helps. VBSTART Sub Test Set objExcel = CreateObject("Excel.Application") xlCTB=4 'Constant for xlCellTypeBlanks = 4 objExcel.DisplayAlerts = False strWB = "C:\Test\admin make busy." Set objWorkbook = objExcel.Workbooks.Open(strWB & "xls") objWorkbook.ActiveSheet.R...

Did some more thinking and I think it is clear to me now. The systems variables start off at default values and stay unchanged until changed (or end), ie in my case "using Window Handles" is active also later in the program. By using "SetFocus" with RegEx selected it was actually trying to match a W...

I used the Code Builder to insert "SetFocus>" in a script. I selected the RegEx option so it looked like this: Let>WIN_REGEX=1 SetFocus>Skype Alone in a script this works fine. However, in my script it did not focus consistently. Then I realized that I had used "Window Handles" earlier in the script...

This also seem to work (i guess the same thing but w/o VB)

Hi, for issue 3, have you tried this?

Using RegEx takes care of the first part (gives the digits as digit_1, digit_2, ...)

Hi, for me this works. This will open my (default) browser and navigate to http://www.wsj.com

ExecuteFile>www.wsj.com,

You could also use Separate> and Trim> to extract the order item: Let>x1= 1000 3.5x2 Premium Business Cards ($39) Separate>x1,(,res Trim>res_1,result MDL>result (If there could be parentheses also in the order item then you would have to adjust the result eg through concatenating all items until the...

Hi, If the reference in WB1 is in column C, then you just have to change in one place: XLGetCell>xlBook1,SheetWB1,ct1,1,tmp1 change to XLGetCell>xlBook1,SheetWB1,ct1,3,tmp1 ct1 is the row number which is looped through iand the next parameter is the column number, which you just change from 1 to 3. ...

Hi, it is possible to do and a solution in MS could look something like this. You would need to change the file names in the beginning (as well as name of the used sheet in WB1 and WB2 if not Sheet1). I put the result in a separate file to avoid overwriting the original one in case there are any pro...

Hi, should be possible to do. Can you give an example of what the data looks like, eg?

Column 1
1
3

Column 2
3 xxx
4 yyy

Then, Column 2 should become
3
4 yyy