Recorded Macro is picking up specfic directory information. Need it more generic

Hi,

I don't know how to write Macro's, only record them. That's my first mistake.

Anyway, I have an Excel Document which has multiple tabs. One of the tabs reads information from other tabs. I have a recorded macro moves this tab into a new workbook. At that point, one of the steps I need to do is break the link to the existing workbook. Data > Edit Links > Break link.

The way the macro records when I do this is:

Please Login or Register  to view this content.

There will only ever be one Excel File this new workbook is linked to, so I need to break the link of any link found. Can I make the above macro more generic, so it will work for any user and from any directory the workbook is saved?

Thanks!