Search found 328 matches
- Tue Sep 03, 2013 7:07 am
- Forum: Beginners
- Topic: String help
- Replies: 3
- Views: 5169
Small adjustment to cover either of "-", ":", or " ". Since you are new to RegEx, it is very powerful, but you have to be careful how you structure them so you don't get wrong results. The code below would work well for simple strings, starting with the ID. (If you have longer strings with several "...
- Thu Jun 13, 2013 3:04 pm
- Forum: Beginners
- Topic: Print web page to PDF
- Replies: 9
- Views: 13502
Sometimes I have had problem with hidden windows that could confuse what is in focus. Both SetFocus and WaitWindowOpen have the choice to look for visible windows. Not sure if that is an issue here. I have updated my previous code (below) and it works on my machine without any problem. Day>dd Month>...
- Wed Jun 05, 2013 9:39 pm
- Forum: Beginners
- Topic: Print web page to PDF
- Replies: 9
- Views: 13502
Hi, I also print to pdf regularly and then to simplify and make my macros more robust I usually set "Adobe PDF" as the default printer. Then it is automatically pre-selected and there is no need for the image recognition. Then for your case it would just be a simple macro like below. (alternatively ...
- Sun Jul 17, 2011 7:40 pm
- Forum: Beginners
- Topic: How to select and "SORT" Excel column with keystro
- Replies: 16
- Views: 20721
- Sun Jul 17, 2011 3:40 pm
- Forum: Beginners
- Topic: How to select and "SORT" Excel column with keystro
- Replies: 16
- Views: 20721
Hi, I am not sure which version of Excel you are using but eg in Excel 2010 you could select a cell in the column you want to sort and then access SORT through the key combinations ALT+A+SA (ascending) ALT+A+SD (descending) (ie you press ALT then can access the menus and submenues through letter com...
- Wed Jan 26, 2011 9:02 am
- Forum: Technical / Scripting
- Topic: MouseMoveRel x,y as variable?
- Replies: 5
- Views: 5760
Hi! One way would be to split the text in two parts and feed them to the mousemove function. Let>blahblahXY="123, 321" Let>delim1=, Let>delim2=" Separate>blahblahXY,delim1,arrItems StringReplace>arrItems_1,delim2,,arrItems_1 StringReplace>arrItems_2,delim2,,arrItems_2 Trim>arrItems_1,arrItems_1 Trim...
- Wed Oct 27, 2010 7:47 pm
- Forum: Technical / Scripting
- Topic: Issue with Command Locator in v12.1.0
- Replies: 0
- Views: 3123
Issue with Command Locator in v12.1.0
There seems to be an issue with the help text when you move over commands using the Command Locator. (I see no help text and the old text box still hangs for some time even when I change and move over a different topic, resulting in a "snake" of text boxes).
- Tue Oct 19, 2010 3:13 pm
- Forum: Technical / Scripting
- Topic: Problems with Excel
- Replies: 8
- Views: 7874
- Tue Oct 19, 2010 9:25 am
- Forum: Technical / Scripting
- Topic: Problems with Excel
- Replies: 8
- Views: 7874
Not sure of your code, I tried a simple example where I have the file name (with path and proper extension) in one cell in excel and then copy it to the clipboard, then GetClipBoard>test wait>.2 RTrim>test,test wait>.2 ExecuteFile>test And it works fine on my machine (also tried different file types).
- Thu Oct 07, 2010 10:03 am
- Forum: Technical / Scripting
- Topic: open csv file in Excel and AutoFit via MS & VBScript
- Replies: 3
- Views: 12809
Hi jpuziano, For me it works if I add the following to your code: Set xlBook = xlBook.sheets("Exceltest") (ie to add a reference to the sheet in addition to the workbook. Sheet name seems to be the same as the CSV name file). Sub OpenExcelFile(filename) Set xlApp = CreateObject("Excel.Application") ...
- Sun Jul 25, 2010 9:04 pm
- Forum: Beginners
- Topic: MS and iMacros
- Replies: 1
- Views: 4133
MS and iMacros
After changing the path it all works fine.
VBEval>RuniMacros("mjtnet.iim"),res
VBEval>RuniMacros("mjtnet.iim"),res
- Sun Jul 25, 2010 3:37 pm
- Forum: Beginners
- Topic: MS and iMacros
- Replies: 1
- Views: 4133
MS and iMacros
Hi, I have a question but not sure if the problem relates to MS or iMacros (I am using MS Pro 12.0.5 and iMacros 7) I am trying the simple MS example they show on their web page (http://wiki.imacros.net/Macro_Scheduler) (see below). When I run the iMacros script (in iMacros) it returns: "Windows Aut...
- Mon Jul 05, 2010 8:06 am
- Forum: Technical / Scripting
- Topic: Capture adress in bar of Win Internet Explorer
- Replies: 5
- Views: 5603
Capture adress in bar of Win Internet Explorer
Maybe you can use the shortcut ALT+D to select the address bar, ie.
Press ALT
SendText>D
Release ALT
Then copy to clipboard etc.
Press ALT
SendText>D
Release ALT
Then copy to clipboard etc.