Search found 10 matches

by ibatey
Fri Feb 07, 2020 6:55 pm
Forum: Technical / Scripting
Topic: Excel Trouble
Replies: 12
Views: 10530

Re: Excel Trouble

Did you ever get to the bottom of this.

I have a script that ussed to work fine, but is now giving an
'Invalid Variant Operation Error'
on anXLOpen line
by ibatey
Tue Jun 19, 2018 5:19 pm
Forum: Technical / Scripting
Topic: UIClick not working
Replies: 1
Views: 1912

UIClick not working

Hi Apologies if this is an obvious one. I am automating a transaction in Sage Accounts. First step is to click on a menu item to bring up the relevant sub-menu. I identified the relevant element using the Findobject wizard and set it to click the element. It inserted the code: SetFocus>Sage 50 Accou...
by ibatey
Sun Jun 17, 2018 2:23 pm
Forum: Technical / Scripting
Topic: Trying to capture xml returned from POST
Replies: 2
Views: 2315

Re: Trying to capture xml returned from POST

Hmmm... I tried that before I posted, and the IEGetAllText didn't seem to work either. That was what I'd first supposed. I was also sure I had the right screen/instance of IE, but I'll have another try when I get some free time in case I made some error. In the end, I got round it by calling the web...
by ibatey
Wed Jun 13, 2018 8:11 pm
Forum: Technical / Scripting
Topic: Trying to capture xml returned from POST
Replies: 2
Views: 2315

Trying to capture xml returned from POST

Hi I have a script which reads an Excel File and enters the details into a webservice Form, which makes a Post Request to a Webservice. This works fine and I get a second IE window opening up with the Webservice Reply. (as per attached picture) xmlReturned.png I've not been able to find a way to use...
by ibatey
Sun Jun 11, 2017 9:44 pm
Forum: The Water Cooler
Topic: Other browsers support?
Replies: 3
Views: 18557

Re: Other browsers support?

Thanks Marcus, I understand all that... and use MS whenever I'm in the IE world. I guess from your reply that the Chrome world is not going to be supported any time soon. Unfortunately I'm at the mercy of clients who refuse to use IE (sometime because of prejudice, sometimes for technical reasons wi...
by ibatey
Tue Jun 06, 2017 3:16 pm
Forum: The Water Cooler
Topic: Other browsers support?
Replies: 3
Views: 18557

Other browsers support?

With the gradual decline? of IE and the advent of Sway, is there any view as to supporting other browsers than IE?

I have a couple of projects where the only acceptable browser is Chrome (Due to incompatibility of other applications with IE) and cant use Macro Scheduler because of it.
by ibatey
Thu Jan 14, 2016 3:14 pm
Forum: Technical / Scripting
Topic: Advice on using Create EXE from command line
Replies: 2
Views: 3626

Re: Advice on using Create EXE from command line

Aah..
Works perfectly now... didn't think to concatenate the parameters like that, but it makes sense once explained.

Thanks
by ibatey
Fri Jan 08, 2016 10:13 pm
Forum: Technical / Scripting
Topic: Advice on using Create EXE from command line
Replies: 2
Views: 3626

Advice on using Create EXE from command line

I'm sure I had this working in the past , but now have a problem. I'm trying to compile an EXE from the command line using the following script: Let>script=D:\ibatey\Desktop\IDMB_Quicklinks_v6.scp Let>exefilename=Quicklinkskoldffg.exe Let>oOutput=D:\ibatey\Desktop Let>oicon=D:\ibatey\Pictures\QL_Log...
by ibatey
Fri Dec 18, 2015 4:28 pm
Forum: Beginners
Topic: Using non-Modal dialog in subroutine
Replies: 3
Views: 5298

Re: Using non-Modal dialog in subroutine

Thanks... that's pretty much the conclusion I had come to... Just wanted an opinion from someone who's been using Macro scheduler for more than a few days.

Thanks again.
by ibatey
Thu Dec 17, 2015 9:34 pm
Forum: Beginners
Topic: Using non-Modal dialog in subroutine
Replies: 3
Views: 5298

Using non-Modal dialog in subroutine

Apologies if this is answered elsewhere, but I've trawled the boards and can't find the answer. I have a small non-modal dialog that I would normally call from a subroutine (for MA read Macro>). I can make this work well if it is in a main script OR by using an include file in the main script. (whic...
Sign up to our newsletter for free automation tips, tricks & discounts