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...

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...

Thanks Marcus

Had to be something simple.

I appreciate you assistance. You have a great product.

Kind regards
Trevor

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...

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.

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...

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...

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 ...

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.

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...

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...

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

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 ...

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...

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...