Hi all,
I am developing a process where I need to access a folder, 'Folder1' contained within a network drive. Within this folder, there are subfolders by year and then month. I need to be able to access files within the correct folder depending on the current year and month.
However I have found that the dynamic file path I am generating does not work despite being identical to the actual file path I would use if I were to hardcode it.
I am using a config file with the following example file path structure:
L:\Folder1\<YEAR>\<MONTH>\Filename.xlsm
During the process I am using a multi-calculation stage to replace the two text placeholders using FormatDate(Now(), "yyyy") and FormatDate(Now(), "MM. MMMM") to generate e.g. 2024 and 06. June respectively, so the file path becomes:
L:\Folder1\2024\06. June\Filename.xlsm
For some reason the above generated file path does not work despite being identical to the file path retrieved from the Security tab of the properties window for the file. I am at a loss and hoping to get some help!
I have checked for leading/trailing spaces, used Trim() to eliminate these. I have pasted both the generated path and the actual path into a notepad document and compared them character by character. My working theory is that Blue Prism has somehow introduced some kind of special character into the string.
This method is working in other processes with identical logic but not this one. I am posting from mobile so apologies for any formatting issues. Thanks in advance.
