Search found 327 matches
- Mon Nov 10, 2014 11:02 am
- Forum: Technical / Scripting
- Topic: Issue with CodeBlock in v14.2
- Replies: 7
- Views: 4550
Re: Issue with CodeBlock in v14.2
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...
- Sat Nov 08, 2014 1:12 pm
- Forum: Technical / Scripting
- Topic: Issue with CodeBlock in v14.2
- Replies: 7
- Views: 4550
Issue with CodeBlock in v14.2
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?
Code: Select all
CodeBlock
MessageModal>Hello
EndCodeBlock
- Fri Nov 07, 2014 9:58 am
- Forum: Technical / Scripting
- Topic: WriteLn create a 2-byte Empty File
- Replies: 7
- Views: 5435
Re: WriteLn create a 2-byte Empty File
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?
- Tue Oct 21, 2014 3:29 pm
- Forum: Technical / Scripting
- Topic: Sub directory names
- Replies: 2
- Views: 2506
Re: Sub directory names
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_...
- Mon Sep 15, 2014 4:09 pm
- Forum: Technical / Scripting
- Topic: Find today's date in Excel Worksheet
- Replies: 5
- Views: 4719
Re: Find today's date in Excel Worksheet
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...
- Mon Sep 15, 2014 8:20 am
- Forum: Technical / Scripting
- Topic: Find today's date in Excel Worksheet
- Replies: 5
- Views: 4719
Re: Find today's date in Excel Worksheet
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...
- Mon Sep 08, 2014 8:06 pm
- Forum: Beginners
- Topic: Separate each line of variable into individual variable
- Replies: 2
- Views: 3657
Re: Separate each line of variable into individual variable
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...
- Fri Aug 29, 2014 6:11 am
- Forum: The Water Cooler
- Topic: The Unofficial Macro Scheduler Puzzler #11
- Replies: 8
- Views: 25680
Re: The Unofficial Macro Scheduler Puzzler #11
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...
- Thu Aug 28, 2014 3:27 pm
- Forum: The Water Cooler
- Topic: The Unofficial Macro Scheduler Puzzler #11
- Replies: 8
- Views: 25680
Re: The Unofficial Macro Scheduler Puzzler #11
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...
- Tue Aug 26, 2014 3:25 am
- Forum: The Water Cooler
- Topic: The Unofficial Macro Scheduler Puzzler #11
- Replies: 8
- Views: 25680
Re: The Unofficial Macro Scheduler Puzzler #11
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.
- Mon Aug 11, 2014 11:12 pm
- Forum: Beginners
- Topic: Exit command
- Replies: 6
- Views: 6612
Re: Exit command
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).
- Sun Aug 10, 2014 12:08 pm
- Forum: Beginners
- Topic: Excel variable use in macro
- Replies: 3
- Views: 4549
Re: Excel variable use in macro
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...
- Sat Aug 09, 2014 3:06 pm
- Forum: Technical / Scripting
- Topic: RegEx Pattern - Variable - Text Insert - Pattern
- Replies: 6
- Views: 4648
Re: RegEx Pattern - Variable - Text Insert - Pattern
My first version should still be ok, or did you have problem with that one as well?
- Sat Aug 09, 2014 7:34 am
- Forum: Enhancement Suggestions
- Topic: Scheduling
- Replies: 1
- Views: 3798
Scheduling
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...
- Sat Aug 09, 2014 6:56 am
- Forum: Technical / Scripting
- Topic: RegEx Pattern - Variable - Text Insert - Pattern
- Replies: 6
- Views: 4648
Re: RegEx Pattern - Variable - Text Insert - Pattern
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:
Code: Select all
RegEx>~,Source,0,M,NM,1,*TC~,res