Hope you will be able to help me with this problem. The problem that I have is that I have two .xsl files that are uploaded to the same specified folder at 4pm everyday. The file names are the same apart from the end digits specifying the date they were uploaded.
I want to create a macro that when pressed makes a copy of the two recently uploaded .xsl files in the folder and paste them in the same folder, with the same names but instead of .xls I need it to be transformed to a .csv file.
I beleive this will be fairly simple but unfortunately I do not have much experience with working with marcros.
Please can someone help me with this problem by giving me sample code to solve it.
Many thanks for your help