Search:

Thank you so much genius, it worked like a charm..... :)

Hi Westconn,
Thank you so much for the code, actually I need a slight modification, if the range A:A contains any alphabets (not only DMT2), it should shift 2 cells right, could you please...

Hi Westconn,
sorry, its my mistake, i have attached the new file file again, please check with this one.
161793

Hi westconn,
Thanks for looking my request, testing1.zip is working, please use it

Hi Friends,
I need a help, actually i have list of data in a excel sheet, which contains some alphabets in the A:A column, those cells need to shifted two cells right as shown in attached...

its OK for me, if it deletes all the deleted items from the bin, chris code delPaperBin is perfectly works for that one.

Hi friends,
i got the below code from online, i just used to called delPaperBin code given in chris.
but public sub is not working, could some one please help me on this .

Public Sub...

Thank you all for providing the codes & spending your valuable time,
i was out of town for few days, sorry for the late reply, i will check the codes now & revert.

Hi Friends,
i need a VBA to delete emails permanently(shift+delete) with the subject line starts with "Automatic reply: xxxx" actually in place of xxxx, it may be any name, but my...

Hi Friends,
I have a list of datas in sheet2 & its has to be copied to sheet 1(as shown in sample file.xlsm) & then call the macro1(this macro will check the webpage,based on that...

Hi Westconn,
Thank you so much for your responce, i have completed it.

Hi Friends,
I have a code, which i got from online, the purpose of code is to fetch all the files names & its paths with hyperlink, now i need the code to be edited for fetching only folder...

hi westconn,
i am getting error at the line as show in sceenshot,
i am using the following path in the cell a1
F:\testing\$dfdf\_ _R_ DFSVSDFDF.docx

please check it159091

hi westconn,
now error message appearing as "object variable or with block variable not set"
please help

hi Westconn,
could you please help me on that above mentioned threat

hi vbfbryce,
Thanks for your reply,i removed extra next as you mentioned & tried, now error not appears but the removal of first special characters in each folders & files is not...

Hi Westconn,
it showing error as (compile errr: Next without for)
please guide me

hi Westconn,
i am sorry, i tried but i cant, please help, i tried like below

Sub Firstchar_rename_study()

Dim fso As FileSystemObject, pth As Object
Dim newName As String...

Hi westconn,
the code which u have is working well, i am using it, I agree your point,
i am new to VBA, so i am not able to convert it for removing only first special...

Hi Westconn,
Thank you so much, it helped me too a lot.
one thing to be mentioned its working fine in Local drives, but its not working in servers,
could you please help out on...

Hi Westconn,
Much appreciated!!! Amazing work done by you.
It worked like a charm :) Tons of thanks to you!!

Hi Friends,
i am using the below code, which is even renaming the folders in Network drives, but its not renaming the sub folders & its files, so could anyone help me to fix this program, as...

Hi Friends,
i have a macro, which it will fetch all the folders,subfolder & files into an excel & it will remove all special characters.
I need a help on rename the folder,subfolder...