I am copying a sheet to paste into a new workbook. The Sheet contains formula and numbers so I figured that a xlPasteFormulas should work. However the number data gets pasted across fine but the formula get pasted along with their path.
I.e. ='Add Detail Client Delivery-Bmth'!C6
is copied an becomes:
='C:\Documents and Settings\JP\Desktop\Test\[Weekly Metric Template 04_02_2007 Bournemouth.xls]Add Detail Client Delivery-Main'!$C$6
Here is the basic code i'm using:
Set Nws = Sheets(shtName) Set WwB = Workbooks.Open(Filename:=SiteFile & Day_Str$ & Sitenamefull & ".xls") Set Ws = WwB.Worksheets(14) With Ws.Cells.Copy End With Nws.Cells.PasteSpecial xlPasteFormulas
How can I make it copy the formula without the file path?