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

[bdicarlo1]

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:

    ActiveWorkbook.BreakLink Name:= _
        "C:\Users\BD1541\Documents\Estimation Team - CMPM Actuals\Estimation Database - Output Reports\Consolidated Actuals-TCP Analysis with MOM Spread.xlsm" _
        , Type:=xlExcelLinks

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!