This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I have a situation which I am not sure if I can achieve it?
I used a directory tool to search the document I need, which generated a fullpath link, I then want it to outpout into another path address which I used a formula tool to replace some of the string in the original fullpath.
Now when I use output tool to export the file into the new path link address I created, it doesnt seems to do so.
I assume I missed something during the process.
The purpose of this was that we have a excel file that need to manually saved as into the latest month folder when we come to beginning of every month, it is same folder like a master excel files.
And we trying to make this automatically so it can saved in the new month folder when we created.
Is it possible to achieve this automatic process?
Please also see the attachment for the process I created and sorry I can show all the details due to the link is actual within the company.
1), directory, select and filter tool are fine to me as I managed to get the file i need, but I and 2 excel file called "worksheet1" in 2 different folder. although the content are the same still interest how to get the exact path one. Then till macro it does not return?
2) within the macro it works fine but if i connect it with the filter tool, there are error.
3) how can the excel files automatic save to the latest month folder without me manually select a location to save?