Posts by SUBHASHn

Thank you @gijsmo...will try and let you know.

Regards,

Subhash

True... Appreciate if you can change it as per the requirement...

Thanks in advance

The macro ran successfully but there is no data in that particular file where I added the code...

And in the column A the data is around 80k rows

Hi Carim,

Thanks for your quick response.

I have the excel file in "D:\Test\Final.xlsx"

Can you change the above code to open that file and add the new column with the requested format .

Regards,

Subhash

Hi ,

I used the below code to get the file names in a folder and pasting them into new workbook called "Final" .But the problem is it is listing all the file names present in that particular folder,here I need only the .pdf files from the folder to be listed.

Any changes to the code will be much appreciated.

Sub FetchFileNames()
Dim FSO As Object
Set FSO = CreateObject("Scripting.FileSystemObject")
Set folder1 = FSO.GetFolder("D:\Test\Select\Temp\").Files
FolderPath_1 = "D:\Test\Select\Temp\"
Workbooks.Add
Set Movenamelist = ActiveWorkbook
For Each fil In folder1
Movenamelist.Activate
Range("A100000").End(xlUp).Offset(1, 0).Value = fil
ActiveCell.Offset(1, 0).Select
Next
ActiveWorkbook.SaveAs Filename:="D:\Test\Select\Temp\Final.xlsx"
End Sub

Regards,

Subhash

Hi,

I have an excel with list names in column A as below

DEM_1000987645__Adam sela_Retailerlist_200098.pdf

SEM_1000987435__Joe Dien _Rmprocruitlist_200038.pdf

I want the same names in column B in this pattern

DEM_1000987645__1000987645_Adam sela_Retailerlist_200098.pdf

SEM_1000987435__1000987435_Joe Dien _Rmprocruitlist_200038.pdf

The 10 digit code number need to be repeated twice

Kindly help me to develop a macro for the above scenario

Regards,

Subhash

Thank [email protected] will try and let you know ?

Hi I have a excel file with two columns

A B

Folder Names. Rename to

123.pdf. Abc.pdf

124.pdf. Gdh.pdf

578.pdf. ADT.pdf

329.pdf. Hji.pdf

For this I have written a macro as shown below but it taking 40mins for renaming 40k files with this code any changes to the code to make it faster would be appreciated.

I don't disagree...It's strange... Thank You both?

Yes macro finished running at 2090

It is stopped near 2090 cell...in total I have 65k cells in the A column

To save the workbook what should be the line of code before End sub?

Here I am opening the actual file from seperate macro file...the error is highlighted here

Hi again, the actual data is in column B and I changed 7 to 2 and g2:g to b2:b but Iam getting this error.

it should be like this

Here it is adding+1 to all the cells

Hi dangelor it adding add " _" for all the cells...it should only add it to the duplicates..In the below I have highlighted the duplicate with yellow which is correct if there is no duplicate it should keep the same

Hi @ dangelor thanks for the code if there is any duplicate it has to add _1.pdf,_2.pdf to it...in the above code it is adding A11.pdf,A22.pdf it should be like A1_1.pdf and A2_2.pdf

One last question @ Mumps will it impact the code if there is some data in column A?