Try
For the customer feild
if the Service Visit Report MASTER.xls is opened
![]()
"Selection.Copy Windows("Service Visit Report MASTER.xls").Activate Range("B16:E16").Select Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _ xlNone, SkipBlanks:=False, Transpose:=False"
Bookmarks