Rename and Replace File names

[Potholes]

Good afternoon to one and all


Over the last couple of weeks I have been lucky enough to enlist the aid of Jindon and Mohan1980 with some codes, that section is now completed, and on advise of a forum Admin I wish to start a new thread.

I have a EXCEL spreadsheet that looks at 27 different .CSV files and one of the files is the device_details.csv the codes that have been written for me extract certain data from this 200+ Meg file, the first of these 2 codes generates a file call " device_details_RK#R.csv". then the second code then generates a file called "device_details_RK#R_Extract.csv"

Once all these 2 codes have run what would like to do if possible is to rename the original source file "device_details.csv" to say eg: "device_details_org.csv" then rename "device_details_RK#R_Extract.csv" to "device_details.csv".

I will attach a cut down version of "device_details_RK#R_Extract.csv" file also the second code.

Any assistance will be truly appreciated, Thank You in advance

Peter

Please Login or Register  to view this content.

[Kaper]

Try:

Please Login or Register  to view this content.

[Potholes]

Good evening Kaper

Thank you for your reply

When I run this code

Please Login or Register  to view this content.

I get an error message on the first line highlighted in yellow.


If it is of any help just to clarify

In the directory I have the following files

"device_details.csv"
"device_details_RK#R.csv"
"device_details_RK#R_Extract.csv"


It is the "device_details.csv" saved as "device_details_ORG.csv"

and the "device_details_RK#R_Extract.csv" saved as "device_details.csv"



Peter

[Kaper]

OK, so let's see if filenames and paths are assigned properly.

Please Login or Register  to view this content.

The next point is may be there already exists "device_details_org.csv" in the folder? if yes, then of course rename will fail here, old versin of _org shall be deleted first (for instance with

Please Login or Register  to view this content.

PS. Still Good Morning here :-) (11:49 AM)

[Potholes]

Hi

I an getting a message box which is confusing me ATM, when I run the code and it is NOT renaming


"device_details.csv" <<<<<<<<<<<<<<<<<<<<<<<<<<<< To "device_details_ORG.csv"
"device_details_RK#R.csv" <<<<<<<<<<<<< Leave alone naming wise
"device_details_RK#R_Extract.csv"<<<<<<<<<<<<<<<<<<<<<<<<<<<< To "device_details.csv"

Please Login or Register  to view this content.

[mohan.r1980]

May be

Please Login or Register  to view this content.

[Potholes]

Good evening sir

Is it possible to remove the popup box showing what is what files should be.

[mohan.r1980]

Hi Peter,

Is it possible to remove the popup box showing what is what files should be.

are you try #6??

[Potholes]

This is my entire code

Please Login or Register  to view this content.

[mohan.r1980]

Hi Peter

Delete below line from your code

Please Login or Register  to view this content.

[Potholes]

Thank you

Off to bed now TTFN

Thanks to you and Kaper

[AliGW]

For the benefit of those who don't understand, TTFN means "ta ta (goodbye) for now".