Hi,
I am currently experiencing an issue, where my application is generating an excel document which is not always standard (for eg WorkFile_20180118.xlsx). So a part of the name of the file being opened on screen changes.
I'm trying to get Blue Prism to attach to this temporary open document to read information and then close the open excel session.
However, in attaching, and then showing functions in the Excel VBO, I cannot specify a wildcard, for eg WorkFile_*.xlsx to grab the open document. When I also try to show what is currently attached, Blue Prism opens a blank new excel document.
Is there something I am missing, or is it somehow possible for BP to attach to an externally opened excel file with a name that constantly changes?
Any suggestions are welcome.
Thanks
I am currently experiencing an issue, where my application is generating an excel document which is not always standard (for eg WorkFile_20180118.xlsx). So a part of the name of the file being opened on screen changes.
I'm trying to get Blue Prism to attach to this temporary open document to read information and then close the open excel session.
However, in attaching, and then showing functions in the Excel VBO, I cannot specify a wildcard, for eg WorkFile_*.xlsx to grab the open document. When I also try to show what is currently attached, Blue Prism opens a blank new excel document.
Is there something I am missing, or is it somehow possible for BP to attach to an externally opened excel file with a name that constantly changes?
Any suggestions are welcome.
Thanks