Recent content by AndyB

Hi Yes I was reading through this earlier but it looks like we wont be able to use winSCP so hopefully I will find another way around it Thanks for the reply

Hi Did you ever locate an answer to this question? We have been asked within the business and never used it before

Hi VJ In all honesty we have been using Blue Prism for a lot of years and some things such as the loading of files has never really been an issue so has not been changed for many years, before I even joined the team. It is only recently we seem to be getting stakeholders adding files to folders...

Hi VJ Sorry for the delay I have been out of office so haven't been checking. We don't get the issue when loading the file, it opens no problem but after this we tend to move the file to an archive folder. It is at this point we have the issue as it cannot be moved and therefore next time...

Hi all Has anyone written a code stage that can check to see if an Excel workbook is open with another user within the business We have recently received input files from within the business which they have left open in error and caused us to be unable to move the file from the folder once...

I have used this below and it seems to work Dim excel as Object = CreateObject("Excel.Application") excel.Visible = True excel.DisplayAlerts = False excel.EnableEvents = True 'false = prevent macros, true = enable macros handle = GetHandle(excel) Dim xlBook as object =...

Sorry I have no experience with code stages so I have tried to add some of the code in those links but I can not get it to work It also seemed to me that most of the VBA was for closing the Excel and the issue I have is while opening, would the VBA still be the same?

Hi VJR I have the same issue with the contains links popup. I originally built it launching excel and adding my filename as a command line parameter so that I could direct drive those popups which worked fine while stepping through the stages however when the process ran it would not connect...