I’m working on a project where I log into a website and download an excel file over multiple days. However, the excel file downloads using a ‘file’ extension. So, I have to find the file and rename it using a date variable to separate it from future file downloads as they all download with the same filename. Also, I have to add a “.xlxs” file extension so I can open the file and use the data contained in the work book. I’m using the move file activity to rename the file once it’s downloaded. This is where the problem lies. When I go to add text and concatenate my variables with the rest of the file path, the activities run fine and complete without errors. When I go to check the renamed file, the date is not applied to the file name, but the non-variable strings are. I have a startDate and endDate variable which I have verified are displaying a string properly using a message box. The activities complete without error, the file is renamed, and my variables are not applied. How do I go about adding variables to my file name so they are displayed correctly when I use move file to rename them?
Thanks for your time!