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
Search found 10 matches
- Fri Feb 07, 2020 6:55 pm
- Forum: Technical / Scripting
- Topic: Excel Trouble
- Replies: 12
- Views: 10530
- 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...
- 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...
- 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...
- 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...
- 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.
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.
- 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
Works perfectly now... didn't think to concatenate the parameters like that, but it makes sense once explained.
Thanks
- 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...
- 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.
Thanks again.
- 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...