Apply Macro to a specific Workbook

Hi all,

I have the following basic macro:

HTML 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 but rather, it is another workbook which when the macro is run it will be closed.

Can someone help me out ?

Appreciate it a lot

Thanks

Try defining the workbook and worksheet (untested):

Please Login or Register  to view this content.

Thanks Berlan.

It works good if the other workbook is open. However if the other workbook, i.e. 'WorkBook 1' is closed, it doesn't work.

Is there a possible way around it?

Thanks a lot !!