Issue with backslash in text data item

[NiallFee]

Hi I want to store the filepath C:\Users\a123456\Desktop\test.xlsm in a text data item that will then be written to a text box in SAP. I know that Blue Prism treats the backslash as an escape character so I have tried using forward slashes instead. However, when I do this, SAP returns a warning via Excel that the file is not in the same format as specified by the file extension. SAP/Excel seems to have an issue with the forward slashes as this is the only scenario that returns this warning. If (outside of Blue Prism) I manually navigate to the file or type in the path it works fine. Is there any other way to store the filepath with backslashes so that SAP can use it correctly? Thanks

[Anonymous]

Hi Niallfee, Kindly share which version of blue prism you are using? try to store the file path in Environment variable and it will work. Also, make a action to send keys using Global Send Keys.

[NiallFee]

Hi It's BP version 4.2.35.0 I have worked around the problem by recording a SAP script to populate the edit box and running that within the object. Thanks