Search found 277 matches

by hagchr
Mon Jun 13, 2016 7:18 pm
Forum: Beginners
Topic: Run Msword macros with Macro Scheduler
Replies: 12
Views: 7573

Re: Run Msword macros with Macro Scheduler

Hi, next try (sorry some soccer distractions in between). I used the command you mentioned - it belongs to the VB world so there needs to be a VBS section. I changed the trigger to CTRL+Shift+e for action and Esc for Exit. Try it and see if it works better or there are still issues. VBSTART Dim wdAp...
by hagchr
Mon Jun 13, 2016 1:38 pm
Forum: Beginners
Topic: Run Msword macros with Macro Scheduler
Replies: 12
Views: 7573

Re: Run Msword macros with Macro Scheduler

Hi, strange for me it seems to work but maybe depends on the text. I just had H3 paragraphs after each other when I tested. You have other text between the H3s? Which version of Word are you using? I need to think a little about it. I also note that CTRL+e was not so good choice as that is used in W...
by hagchr
Mon Jun 13, 2016 8:55 am
Forum: Technical / Scripting
Topic: passing variable to run cmd command
Replies: 3
Views: 2390

Re: passing variable to run cmd command

Another way would have been to define Let>perc=% and then use %perc% instead of % in the formula.
by hagchr
Mon Jun 13, 2016 3:30 am
Forum: Technical / Scripting
Topic: passing variable to run cmd command
Replies: 3
Views: 2390

Re: passing variable to run cmd command

Hi, splitting the line seems to work: Let>vid=TestFilm //Not working Let>res=Run>cmd /k youtube-dl --restrict-filenames -o "P:\youtube\downloads-vid\%(title)s-%(id)s.%(ext)s" "https://youtu.be/%vid%" MDL>res //Working Let>tmpa=Run>cmd /k youtube-dl --restrict-filenames -o "P:\youtube\downloads-vid\%...
by hagchr
Sun Jun 12, 2016 6:14 pm
Forum: Beginners
Topic: Run Msword macros with Macro Scheduler
Replies: 12
Views: 7573

Re: Run Msword macros with Macro Scheduler

Happy to help. It seems you don't have the same selection options when in outline view mode. I changed the code slightly so text will be selected if you press CTRL+e. To exit the script just press Escape. You can play/adjust so it suits you. OnEvent>KEY_DOWN,e,2,SRTExtend OnEvent>KEY_DOWN,VK27,0,SRT...
by hagchr
Sun Jun 12, 2016 5:21 pm
Forum: Beginners
Topic: Run Msword macros with Macro Scheduler
Replies: 12
Views: 7573

Re: Run Msword macros with Macro Scheduler

Have to think if a better way, but one way could be: SetFocus>Document1* Wait>0.2 Press>CTRL Press>ALT SendText>p Release>ALT Release>CTRL Wait>0.1 Press>CTRL Press>Shift Press>Down Release>Shift Release>CTRL Wait>0.1 Press>CTRL Press>ALT SendText>o Release>ALT Release>CTRL
by hagchr
Sun Jun 12, 2016 4:58 pm
Forum: Beginners
Topic: Run Msword macros with Macro Scheduler
Replies: 12
Views: 7573

Re: Run Msword macros with Macro Scheduler

Then something like this should do it:
SetFocus>Document3 - Microsoft Word
Wait>0.2

Press>CTRL
Press>Shift
Press>Down
Release>Shift
Release>CTRL
by hagchr
Sun Jun 12, 2016 4:44 pm
Forum: Beginners
Topic: Run Msword macros with Macro Scheduler
Replies: 12
Views: 7573

Re: Run Msword macros with Macro Scheduler

Hi, do you want to select the whole paragraph or just from your current selection until the end of the paragraph?
by hagchr
Sun Jun 12, 2016 3:56 pm
Forum: Enhancement Suggestions
Topic: Duration of mp3/mp4
Replies: 5
Views: 4796

Re: Duration of mp3/mp4

Just to add in case anyone is new to this. The file you get contains a lot of metadata, in this case only Duration was extracted. For a video you would get something like this (depending on format/make): ExifTool Version Number : 10.19 File Name : P1010131.MP4 Directory : D:/London Dec 2014/DCIM/101...
by hagchr
Sun Jun 12, 2016 3:03 pm
Forum: Enhancement Suggestions
Topic: Duration of mp3/mp4
Replies: 5
Views: 4796

Re: Duration of mp3/mp4

You can eg download/install the free tool ExifTool and then the following would give the duration: http://owl.phy.queensu.ca/~phil/exiftool/index.html#running //Your audio/video file Let>file="C:\Users\...\xxxxxx.m4a" //Temporary file to store result Let>file2=%TEMP_DIR%tmpexif.txt Let>RP_WAIT=1 Run...
by hagchr
Sun Jun 12, 2016 11:00 am
Forum: Scripts and Tips
Topic: Auto press TAB key in VBScript
Replies: 1
Views: 7358

Re: Auto press TAB key in VBScript

Hi, Sorry, I am not sure how to do it in VBS so cannot help you there. In case you have MS then you could do something like the code below. Maybe there are other things one should consider, eg focus etc, but that was not mentioned in the question. Hope it helps, at least it helped me better understa...
by hagchr
Sun Jun 12, 2016 10:30 am
Forum: Beginners
Topic: list certain extensions only
Replies: 5
Views: 4801

Re: list certain extensions only

Hi, just be aware that if you don't have a delimiter between the file groups when you put them together, you may get problem eg with Separate> not separating as you want, possibly showing elements with more than one file in them. Depends on what you are doing later if problem or not.
by hagchr
Fri Jun 10, 2016 3:02 pm
Forum: Enhancement Suggestions
Topic: Keep name on Save As / Duplicate
Replies: 1
Views: 3120

Keep name on Save As / Duplicate

For scripts that have already been saved, it would be nice if using Save As, you get the current name pre-filled in the name box for adjustment, eg to add suffix etc. Also when you duplicate an existing file, it opens the duplicate with no name. Alternative would be to add a copy and name it tex Ori...
by hagchr
Fri Jun 10, 2016 9:15 am
Forum: Technical / Scripting
Topic: SAPI.SpVoice to Greek
Replies: 9
Views: 7585

Re: SAPI.SpVoice to Greek

Code: Select all

VBSTART
Sub Speak(text,speed)
 Dim Talk
 Set Talk = CreateObject("SAPI.SpVoice")
 Talk.Rate=speed
 Talk.Speak text
End Sub
VBEND

Let>VBS_TIMEOUT=60000
//Rate between -10 and 10
VBRun>Speak,Hello Keith,5
by hagchr
Thu Jun 09, 2016 11:06 am
Forum: Beginners
Topic: PivotTable Values problem (VB-related)
Replies: 9
Views: 6962

Re: PivotTable Values problem (VB-related)

Start Excel and the VB Editor (ALT+F11) and then press CTRL+G to open the Immediate Window. In here you can easily get the value of constants, just enter Print and constant and you get the value, eg

Print xlSum
gives -4157

Print xlDataField
gives 4

etc.
Sign up to our newsletter for free automation tips, tricks & discounts