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 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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.