Hi there I am trying to get my code to let them decide if they want to change
the control (which is linked from another workbook) if they say yes it will
open up the other workbook (which works fine) but then I want it to copy the
information from the previous workbook and locate it on the one that has
opened the code I am using is this - does anyone have any pointers?


Sub goToSoa()

Dim soaValue As String

frmYesNo2.Show
If frmYesNo2.rdNo = True Then Exit Sub

If frmYesNo2.rdYes = True Then
soaValue = ActiveCell.Copy
Workbooks.Open Filename:= _
"http://knet/sites/fapas/risk/InformationSecurity/IS
Documents/Plan/Statement of Applicability.xls"

Cells.Find(What:=soaValue, After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False).Activate

Cells.FindNext(After:=ActiveCell).Activate

End If

End Sub