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

On Nov 18, 10:17*am, Ratheesh <ratheesh.ramachandh...@gmail.com>
wrote:
> 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

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(E-Mail Removed)
"Ratheesh" <(E-Mail Removed)> wrote in message
news:f757cfd9-e44e-4fb3-b018-(E-Mail Removed)...
> 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

On Nov 18, 8:27*pm, JP <jp2...@earthlink.net> wrote:
> I did a search for "vba rename file" and got several promising hits.
>
> --JP
>
> On Nov 18, 10:17*am, Ratheesh <ratheesh.ramachandh...@gmail.com>
> wrote:
>
>
>
> > 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- Hide quoted text -
>
> - 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.