HI,
There is a code in an excel file which is in the following folder="C:\CALCULATIONS\FIRST".
When i copy-paste the "FIRST" folder the new path of that pasted folder is as followes="C:\CALCULATIONS\FIRST - Copy"Please Login or Register to view this content.
but Here, the only barrier is that the file path in the code always remains constant .
For eg:
After pasting was expected to be changed toPlease Login or Register to view this content.
But the name of that "FIRST" folder stays as it is, instead of changing to "FIRST - Copy"Please Login or Register to view this content.
Please anyone enlighten me in this matter.
Thank you
Bookmarks