delete csv file with same name as xls file

[stevekirk]

hi ,

i download csv files daily and transfer the data to an xls file and mofify the data then save the xls file with the same name as the CSV file

this is the code that i use to save the new Xls file with the same name.

can you please look at the code i use and could ot be modified to delete the CSV File

thanks
steve

Please Login or Register  to view this content.

[thisisgerald]

Hi stevekirk,

I guess there is nothing wrong in your code.
That code only makes a copy of CSV file with a ".xls" extension and does not delete your CSV file.
All you need is a an additional code to delete your CSV file.

Regards,
thisisgerald

[Andy Pope]

Please Login or Register  to view this content.

[stevekirk]

hi andy,

i am getting an error cannot find file, it ssems it is not seeing the CSV

Steve

[Andy Pope]

Is the csv in the same folder as the newly saved workbook? where ever sPath is referring too.

[stevekirk]

yes ,

same folder etc

[stevekirk]

Andy,

this is the code i am using , hope it helps, albeit all over the place

Please Login or Register  to view this content.

[Andy Pope]

Try this code, it will report the file it is trying to delete if it is not found.

Please Login or Register  to view this content.

Confirm the folder location and filename are correct.