VBA to copy formula from source to destination workbook without source workbook name

[baleshst]

hi,

I have written a code to copy formula from source to destination workbook

Source workbook: Data for Budget FY18.xls

When VBA copies the cell from above source to destination workbook

the destination workbook gets the following formula.

=C13*$D$5*'[Budget With GST v2.xlsb]BUDGET'!B$212

Is there a way the above highlighted source file name is not included in the destination workbook.

 

[vletm]

Yes ... if You source workbook do not have link to other workbook.