XLDelCol

[only1platinum]

I am trying to use the below script to delete a bunch of un-needed columns from an excel file. Wondered if anyone could help me find what is wrong in this code. Right now it just sits the and loops. It should stop deleteing columns at row 66 starting at 26. I have tried the until command with and without quotes. I must be doing this wrong some how.

Let>c=26
XLGetCell>xlBook,%filename_without_extension%,1,66,delColCheck

Repeat>delColCheck
XLDelCol>xlBook,%filename_without_extension%,c
Let>c=c+1
Until>delColCheck=""


PS. Filename_without_extension is defiened earlier in the script and I know it works in the rest of the script properly.

[Marcus Tettmar]

There is nothing inside your Repeat/Until loop that sets delColCheck, so it will never become "". So the loop will never end.