Assignment 10, dynamic naming and opening document

power-user
#1

Hi,

I’m having a problem for assignment 10. So what I want to do is:

Create an excel, works
Save and name the excel with todays date and current time, works (“ExcelFile 20190108 14:39.xlsx”)
Open the excel, problem!

I need to make RPAE understand that it needs to open the excel file not based on a permanent name, but on the name based on the date and time. Since the date and time and hence name of the file will be different every time it’s run.

#2

You can create a new filename using Constant value action

#3

Thanks for the reply Ashapkina! It turns out the formula was correct, but the problem was that RPA Express can’t open files from our cloudbased user disk. I need to test it further and try to figure it out.

1 Like
#4

Try specifying the full path to the shared file, like:

\\server-name\share-name\directory

#5

@ErikW did you manage to solve this issue?

#6

Hi, managed to make it work thanks.

1 Like
#7

Glad you made it work.

Did the above suggestion help you or did you find another solution?

#8

It worked out by writing H:\ manually.

1 Like