Hello everyone, I recently completed automating an excel file with UI Path. However, the file path contains my name and i would like to make it available for everyone to use the bot. How do i code such that the bot can open the same file whenever any other person uses it:
e.g “C:\Users\Jane.Mwambazi\Reports\Tempo Master\financial Reports v1.0.xlsx”
If we consider that all the users have the same path in their respective machines the syntax for the excel path should be : "C:\Users\"+Environment.UserName+"\Reports\Tempo Master\financial Reports v1.0.xlsx"
Otherwise it would be good if you share the file an you can all access it using the same path, you should be in the same network though.
This might work better, and get the default Users folder path: Environment.GetEnvironmentVariable(“USERPROFILE”)+"\Reports\Tempo Master\financial Reports v1.0.xlsx"