Change file name from folder using VBA

  • Thread starter Thread starter Ratheesh
  • Start date Start date
R

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
 
I did a search for "vba rename file" and got several promising hits.

--JP




- Show quoted text -
Click to expand...

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.
 
Back
Top