Apply Macro to a specific Workbook

[Keibri]

Hi all,

I have the following basic macro:

<code style="margin: 0px; padding: 0px; font-style: inherit; font-weight: inherit;">
Sub RemoveDuplicates()
Cells.RemoveDuplicates Columns:=Array(1)
End Sub
</code>

basically it's a simple macro which removes duplicates.

I would like to edit this macro so as when it is run it will be applied on a particular workbook, say "Workbook 1". However "Workbook 1" is not the active workbook. Rather, it is another workbook, which when the macro is run it will be closed.

The macro should remove the duplicates of "Workbook 1", even though "Workbook 1" is closed (not active).

I had posted the original query in another forum but would really appreciate if someone can guide me further. Kindly find original post in the link below:
Apply Macro to a specific Workbook



Can someone help me out

?

Appreciate it a lot

Thanks

 

[JoeMo]

The macro can be expanded to open workbook 1, remove duplicates, save workbook 1 and then close it. Is that what you want?

 

[My Aswer Is This]

That's something new for me. Never knew this simply function existed. Now to figure out how it's working exactly.

 

[Keibri]

Yeah, I think I managed to find a way around it, just like JoeMo indicated:

[/FONT][/COLOR]Sub RemoveDuplicates()


    Workbooks.Open "C:\Users\User\Documents\Workbook 1.xlsm"
    
    Workbooks("Workbook 1").Sheets("Sheet1").Cells.RemoveDuplicates Columns:=Array(1)
    
    ActiveWorkbook.Save
    Workbooks("Workbook 1.xlsm").Close
End Sub

Thanks a lot for your idea !!!

Cheers