Search found 25 matches

by Trevor Hughes
Mon Feb 12, 2024 10:29 pm
Forum: Technical / Scripting
Topic: Microsoft Access (Office 365) connection string
Replies: 1
Views: 414

Microsoft Access (Office 365) connection string

Hello We have recently upgraded to Office 365 and since this change I have been unable to query my Access database and I receive the following error message: Line 8 - No valid connection The connection string I have been using successfully prior to the change is: DBConnect>Provider=Microsoft.ACE.OLE...
by Trevor Hughes
Wed Jan 23, 2019 6:43 pm
Forum: Technical / Scripting
Topic: How to find the name of a file in a folder
Replies: 4
Views: 3398

How to find the name of a file in a folder

Hello I am currently using the following to get a list of files in a folder to use in my script: GetFileList>c:\Temp\*.*,files Separate>files,;,file_names ArraySort>file_names This works well in giving me the full path to the file. However I want to use a variable to store just the filename (without...
by Trevor Hughes
Wed Sep 06, 2017 10:42 pm
Forum: Technical / Scripting
Topic: Click to the left of an image in an image array
Replies: 2
Views: 2095

Re: Click to the left of an image in an image array

Thanks Marcus

Had to be something simple.

I appreciate you assistance. You have a great product.

Kind regards
Trevor
by Trevor Hughes
Tue Sep 05, 2017 10:15 pm
Forum: Technical / Scripting
Topic: Click to the left of an image in an image array
Replies: 2
Views: 2095

Click to the left of an image in an image array

Hello I want to be able to click to the left (180 pixels) of an image array. The image will appear multiple times and in every instance I want to de-select the item. I have tried the following but this gives me an error: MouseMove>XArr_%k%-180,YArr_%k% I'm sure that it is a simple fix but all the th...
by Trevor Hughes
Mon Sep 04, 2017 9:10 pm
Forum: Technical / Scripting
Topic: Find text on a web page
Replies: 3
Views: 3454

Re: Find text on a web page

Thank you for the help with this. I think that the CTRL F would be the best option for my situation.

I appreciate the help.
by Trevor Hughes
Thu Aug 31, 2017 11:31 pm
Forum: Technical / Scripting
Topic: Find text on a web page
Replies: 3
Views: 3454

Find text on a web page

Hello I was wondering if it was possible to find text on a web page where the text was on a part of the page that was not on screen. I am filling out various fields on a web page that requires me to scroll, so some fields are not on screen. If there is a way to do this I would appreciate any guidanc...
by Trevor Hughes
Thu Feb 23, 2017 8:12 pm
Forum: Technical / Scripting
Topic: How do I get logging to work
Replies: 12
Views: 11104

Re: How do I get logging to work

Thank you for the comments on this question. For clarity from my perspective, for a number of reasons I always run scripts with the Script Editor open. This is because I am using Macro Scheduler to test our applications which can be very flakey. If I want to use logging I would need to compile the s...
by Trevor Hughes
Wed Feb 22, 2017 8:42 pm
Forum: Technical / Scripting
Topic: How do I get logging to work
Replies: 12
Views: 11104

How do I get logging to work

Hello I want to enable logging for my scripts, however I cannot figure out how to do this. I've gone to the Logging tab and specified a log file eg. C:\Logging\ScriptName.txt However this does not appear to do anything. I cannot find any info on how to do this. If some-one could provide to guidance ...
by Trevor Hughes
Sat Aug 13, 2016 11:48 pm
Forum: Technical / Scripting
Topic: XMLParse - extracting values within tags
Replies: 2
Views: 3378

Re: XMLParse - extracting values within tags

Thank you very much for the help.

Your suggestion worked great. This will be extremeley helpful. I now have a much better understanding of what the code is doing.
by Trevor Hughes
Fri Aug 12, 2016 4:11 am
Forum: Technical / Scripting
Topic: XMLParse - extracting values within tags
Replies: 2
Views: 3378

XMLParse - extracting values within tags

Hello I want to be able to extract some values within the tags of an XML string. I am trying to achieve this by copying the contents of the XML file onto the Clipboard, using GetClipBoard to place the string into a variable and trying to use XMLParse to extract the value TG0508I10-SOV. (<reqresp:Cus...
by Trevor Hughes
Tue Feb 16, 2016 7:08 pm
Forum: Technical / Scripting
Topic: No Default Value
Replies: 2
Views: 2714

No Default Value

Hello I am experiencing a problem with a query referenced by a script I am running. The error is: Error in: B2B Lodgement Line: 10 - Parameter [Forms]![Goods]![Test environment] has no default value This relates to a Microsoft Access query which is referencing a field on a form. DBQuery>GoodsTesting...
by Trevor Hughes
Fri Aug 14, 2015 2:19 am
Forum: Technical / Scripting
Topic: How can I paste a value from the clipboard into a SOAP proje
Replies: 2
Views: 2688

Re: How can I paste a value from the clipboard into a SOAP p

Hello

Thank you for the advice. Your suggestion is perfect. I will give it a go.

Thank you very much for the help.

Kind regards
Trevor
by Trevor Hughes
Wed Aug 12, 2015 10:24 pm
Forum: Technical / Scripting
Topic: How can I paste a value from the clipboard into a SOAP proje
Replies: 2
Views: 2688

How can I paste a value from the clipboard into a SOAP proje

This question relates to the previous topic: "How to locate a string within XML tags " Firstly thank you very much for the help provided with the previous topic mentioned above. The previous topic provided a solution to extracting a string from within an XML tag and placing this on the clipboard. I ...
by Trevor Hughes
Tue Aug 11, 2015 11:00 pm
Forum: Technical / Scripting
Topic: How to locate a string within XML tags
Replies: 7
Views: 5007

Re: How to locate a string within XML tags

I now have the value within the XML tag extracted to the clipboard, thanks to the help provided. The next step is to paste this value with the Authentication tag of another soap script (see below). Can someone help me with this. Doing it manually I would open the other SOAP project, generate the MAC...
by Trevor Hughes
Sun Aug 09, 2015 9:51 pm
Forum: Technical / Scripting
Topic: How to locate a string within XML tags
Replies: 7
Views: 5007

Re: How to locate a string within XML tags

Hello Just a follow on question. The script I'm hoping to build will have the SOAP project on screen and therefore what I would like to do is to locate the string within the XML Tags. Given the solutions kindly provided, I'm not sure how to apply these to an on-screen file rather than calling the XM...
Sign up to our newsletter for free automation tips, tricks & discounts