Save as excel file?

[zhshqzyc]

Hi, in my code. Currently after running my code, the windows reminded me "save file yes or no something". It will overwrite the original file. But I want to keep the original one. I want to save it as a new file.
How to modify the code?

Dim folderPath As String

' Indicate extension and retrieve a file

Please Login or Register  to view this content.

Thanks

[zhshqzyc]

What is wrong?

Please Login or Register  to view this content.

[zhshqzyc]

Here but I don't know what is wrong?

Please Login or Register  to view this content.

[shg]

Please Login or Register  to view this content.