Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding a cell on a workbook that I have opened
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding a Workbook based on a Cell information in another Workbook | Excel Worksheet Functions | |||
How can I get the value of a cell in a un-opened workbook ? | Excel Programming | |||
Opening a workbook if not opened, going to it if already opened | Excel Programming | |||
Opening a workbook if not opened, going to it if already opened | Excel Programming | |||
How to see if the opened workbook is opened by another user ? | Excel Programming |