Search found 1346 matches
- Fri May 03, 2019 10:55 am
- Forum: The Water Cooler
- Topic: Question about GetFileList to work..
- Replies: 4
- Views: 15729
Re: Question about GetFileList to work..
I'll see if I can walk you through how to build this in stages. We can often do this using code samples from the helpfile, and bolting them to what we have already. Let's start with the basic sample from the GetFileList helpfile entry, and adapt it a little. We've adapted it to only look for .jpg fi...
- Thu May 02, 2019 10:36 am
- Forum: Technical / Scripting
- Topic: Excel Trouble
- Replies: 12
- Views: 8209
Re: Excel Trouble
The only ways I can force this error (and the only causes I have ever seen over at the Support Desk) are : 1) If the path and filename in XLGet is incorrect. But if XLOpen is working using that same path, it can't be that. or, 2)If the XL Book Handles in XLGet and XLGetCell don't match - of course I...
- Mon Apr 29, 2019 11:21 pm
- Forum: Technical / Scripting
- Topic: SMTPSendMail with Gmail (SOLVED) - enable "Less Secure Apps"
- Replies: 6
- Views: 16459
SMTPSendMail with Gmail (SOLVED) - enable "Less Secure Apps"
We recently had a customer over at the support desk who just couldn't seem to get Macro Scheduler to send emails via Gmail. Although he was doing everything right, the email never got sent. There were no errors and SMTP_RESULT was always blank - it just didn't work. Here's the code I gave him, which...
- Mon Apr 29, 2019 2:58 pm
- Forum: Technical / Scripting
- Topic: Excel Trouble
- Replies: 12
- Views: 8209
Re: Excel Trouble
XLGet attaches to an existing running instance of Excel. In other words, if that Excel file has been opened by anything other that XLOpen. I was able to replicate this error, so have a good idea of what may be causing it. This is my test code : //Working code let>filename=D:\mjt\files\excel\compare....
- Fri Apr 26, 2019 12:09 pm
- Forum: Technical / Scripting
- Topic: [SOLVED] Launching xlsm from MS encounters errors.
- Replies: 7
- Views: 4298
Re: [SOVLED] Launching xlsm from MS encounters errors.
Aaah, that's great to hear. Thank you for the update.
- Thu Apr 25, 2019 5:11 pm
- Forum: Technical / Scripting
- Topic: [SOLVED] Launching xlsm from MS encounters errors.
- Replies: 7
- Views: 4298
Re: Launching xlsm from GS encouters errors.
Hi, we'd be happy to help. Let's see if we can get to the bottom of it. What is GS? What error are you seeing? Can you share the pertinent part of your code please? The following is the code for opening an xlsm and running an Excel Macro using XLOpen and XLRun //Set up the document path let>filepath...
- Wed Apr 24, 2019 3:36 pm
- Forum: Beginners
- Topic: Simulate Keyboard Shortcut
- Replies: 1
- Views: 2191
Re: Simulate Keyboard Shortcut
Hi,
Try...
Press CTRL
Press Shift
Send>N
Release Shift
Release CTRL
Occasionally this is too fast for some applications, so you can slow it down slightly with...
Press CTRL
Wait>0.05
Press Shift
Wait>0.05
Send>N
Wait>0.05
Release Shift
Wait>0.05
Release CTRL
Try...
Press CTRL
Press Shift
Send>N
Release Shift
Release CTRL
Occasionally this is too fast for some applications, so you can slow it down slightly with...
Press CTRL
Wait>0.05
Press Shift
Wait>0.05
Send>N
Wait>0.05
Release Shift
Wait>0.05
Release CTRL
- Wed Apr 24, 2019 3:14 pm
- Forum: General Discussion
- Topic: Run script with Touch Screen
- Replies: 1
- Views: 4139
Re: Run script with Touch Screen
Just trap the onClick event as normal. It's no different.
- Wed Apr 24, 2019 10:20 am
- Forum: Technical / Scripting
- Topic: Image Recognition Problem
- Replies: 1
- Views: 1621
Re: Image Recognition Problem
That's an interesting one. No, there's no way to ignore orientation. Are you able to capture all of the variations and try to detect all of them? Or are there too many permutations? Or maybe is there a small part of the image which may appear the be the same - for example if there's a unique block o...
- Mon Apr 22, 2019 10:04 am
- Forum: Beginners
- Topic: Copy past to notepad in Repeat block Not working
- Replies: 2
- Views: 2841
Re: Copy past to notepad in Repeat block Not working
Does adding SetFocus make any difference? So you'd have :
WaitWindowOpen>Untitled - Notepad
MoveWindow>Untitled - Notepad,-1834,221
ResizeWindow>Untitled - Notepad,178,636
SetFocus>Untitled - Notepad
Wait>0.200
Press LCTRL
Wait>0.200
Send>v
Wait>0.200
Release LCTRL
Wait>0.500
WaitWindowOpen>Untitled - Notepad
MoveWindow>Untitled - Notepad,-1834,221
ResizeWindow>Untitled - Notepad,178,636
SetFocus>Untitled - Notepad
Wait>0.200
Press LCTRL
Wait>0.200
Send>v
Wait>0.200
Release LCTRL
Wait>0.500
- Thu Apr 18, 2019 9:55 am
- Forum: Beginners
- Topic: Question about a video game
- Replies: 2
- Views: 3254
Re: Question about a video game
I just downloaded it and tried it. I have no idea what I'm supposed to do in Roblox, but I found that this will successfully move and click in the game. I just used it to click through the tutorial popups. Of course your mouse co-ordinates wil be different. Setfocus>Roblox MouseMove>1995,1327 lclick
- Thu Apr 18, 2019 9:41 am
- Forum: Beginners
- Topic: Question about a video game
- Replies: 2
- Views: 3254
Re: Question about a video game
Have you tried making sure to set focus to the window you're trying to control?
- Thu Apr 11, 2019 3:38 pm
- Forum: Technical / Scripting
- Topic: Get an Excel File Name from another Excel File
- Replies: 3
- Views: 2398
Re: Get an Excel File Name from another Excel File
Aaaah, we've all done it!
- Thu Apr 11, 2019 8:15 am
- Forum: Technical / Scripting
- Topic: HTTP_CUSTOM_HEADERS
- Replies: 2
- Views: 2226
Re: HTTP_CUSTOM_HEADERS
Hi Colin,
It's great to hear your issue was resolved.
It's great to hear your issue was resolved.
- Mon Apr 08, 2019 10:02 am
- Forum: Technical / Scripting
- Topic: Image recognition
- Replies: 1
- Views: 1461
Re: Image recognition
Would GetpixelColor or even WaitPixelColor be viable options for this?