Change file name from folder using VBA

[Ratheesh]

Hi All -

Please, can anyone help to write a coding for changing the filenames
(all format) from a folder.
i.e,
I am having 2 files in C:\

C:\test.xls
C:\test1.pdf

Can we change these file names using VBA (Excel) as -

C:\changed.xls
C:\changed1.pdf

Thanks a lot in advance.
Ratheesh

 

[JP]

I did a search for "vba rename file" and got several promising hits.

--JP

 

[Don Guillett]

Some combination using DIR to find the filename and NAME to change the name.

 

[Ratheesh]

I did a search for "vba rename file" and got several promising hits.

--JP




- Show quoted text -

Thanks, I had not searched that before in this group...
I know how to take the file names from a folder, but ididnt know how
to rename it....
one more doubt, is there any issue while executing codes in citrix...
i am not getting the proper results while I am running this in my
citrix environment...
Thank You.