I tried to re-install v14.2 and also on a separate machine but I still cannot run my old scripts that are using CodeBlock so I will need to revert back to the previous installation. Also I cannot seem to find a place to submit a support ticket (was it (re)moved?) so I repost it here: Full error mess...

Hi, I just downloaded v14.2 and it gives me problem with CodeBlock. Says "Error in _debug.dbg...". Bug or do I need to modify something to use the new version?

Hi, When I try JRL's code I get 0kb. My understanding is that if the file already exists then it will append to it. Did you try to delete the test file before running the new code?

If you set GFL_TYPE=1 then GetFileList will return a list of directories. Then you can check which directories that match the hex name criteria and proceed (copy etc, here just a message box). Let>GFL_TYPE=1 GetFileList>C:\Users\.......\*.*,files,; Separate>files,;,file_names Let>ct=0 While>ct<file_...

Hi again. I changed it slightly so that it sets focus to the right sheet and also that it searches for values (The constant xlValues=-4163 could vary depending on Excel version but hopefully ok for you). I am not sure if one also has to change to ensure the date formats are consistent (could the ini...

Hi, hopefully this will help you. VBSTART Sub xlExample(date) Set oExcel = CreateObject("Excel.Application") oExcel.Visible = true oExcel.Workbooks.Open "C:\My Stuff\Data\microsoft excel 97\BTB.xlsx" Set SearchRes = oExcel.Sheets("BTB-Workout").Range("C2:XDF1000").Find(date) If NOT SearchRes is Noth...

Hi, If I understand your problem correctly then you could use RegEx to pull out the information in each line and assign it to variables: GetClipboard>varClipboard Let>tmp0=(?m)(?<=^Line \d: ).+?$ RegEx>tmp0,varClipboard,0,M,NM,0 In case you have not used RegEx before, what it says is, look for a pat...

Just to avoid confusion for anyone new to MS, to initiate an array I usually use RegEx or a loop. Involving PI was just for this particular problem to increase the speed. Also, for anyone new to RegEx, the command: RegEx>0,0000000000,0,M,NM,0 will search for the first string (0) in the second string...

I think you fellow puzzlers have had enough time so here is my attempt for a solution. Without comments etc around 100 or so lines of code. Can get it down to around 60 but then it will be around 1s slower. Hopefully I did not mislead anyone with my comment about PI. I did use it but maybe not in th...

Hi, thanks for a great puzzle. I answered the last one too quickly before people had the chance to think it through, which kind of "ruined" the discussion, so will not do that mistake again. I will post my solution (if still worthy) on Thursday. Let's see if I am the only one using PI to solve it.

I think you need to use WSI_TIMEDOUT instead of WSI_TIMEOUT for the second check (small spelling difference - WSI_TIMEOUT sets the timeout in seconds and WSI_TIMEDOUT shows if the function "timed out" or not - TRUE/FALSE).

Hi, just before saving I note the original question has been removed, however, here is what I would have suggested. Hopefully it still helps. Depending on the web site and what you want to do you may want to check MS tools to interact with web pages if there is a better way. //Your excel sheet (chec...

My first version should still be ok, or did you have problem with that one as well?

I have scheduled scripts that from time to time needs the scheduling to be changed. It would be nice if one from the main control center could right-click on a script and select say something like "Edit scheduling" and be taken directly to the page where you set/edit when the script should be run. A...

I was not sure if there were any other ~ so played it safe. However, if there are no other ~ or irrelevant if any other would be affected you could simplify the RegEx to: