<div>
<pre><code id="code-20-40633507-1">Sub macro9()
Dim wb As Workbook, wb1 As Workbook

Set wb = ThisWorkbook

Set wb1 = Workbooks.Open(Range(&quot;F7&quot;).Value)

    Sheets(&quot;CV&quot;).Select
    Cells.Select
    Range(&quot;A17&quot;).Activate
    Selection.Copy
    
    wb.Activate</code></pre>
<br />
You can use the following code...<br />
<br />
Saurabh...
</div>


Sub macro9()
Dim wb As Workbook, wb1 As Workbook

Set wb = ThisWorkbook

Set wb1 = Workbooks.Open(Range("F7").Value)

    Sheets("CV").Select
    Cells.Select
    Range("A17").Activate
    Selection.Copy
    
    wb.Activate


You can use the following code...

Saurabh...

<div>
You don't actually need to select or activate anything to copy ranges. What is the full purpose of the macro?
</div>


You don't actually need to select or activate anything to copy ranges. What is the full purpose of the macro?

<div>
<div class="content wysiwyg-content">
Hi Guys, I have an Excel Macro which opens a spreadsheet in the Cell &quot;F7&quot;, then copies and pastes to another spreadsheet. See the code below. However, when I go Windows -&gt; (so to return to the spreadsheet) how do I adapt &nbsp;it in the code? <br />
<br />
Sub Macro9()<br />
<br />
&nbsp; &nbsp; Workbooks.Open Filename:=Range(&quot;F7&quot;)<br />
<br />
&nbsp; &nbsp; Sheets(&quot;CV&quot;).Select<br />
&nbsp; &nbsp; Cells.Select<br />
&nbsp; &nbsp; Range(&quot;A17&quot;).Activate<br />
&nbsp; &nbsp; Selection.Copy<br />
&nbsp; &nbsp; Windows(&quot;01 - EMEA Mortgages Reporting Pack - Jan 15 (B) Test.xlsm&quot;).Activat
</div>
</div>


Hi Guys, I have an Excel Macro which opens a spreadsheet in the Cell "F7", then copies and pastes to another spreadsheet. See the code below. However, when I go Windows -> (so to return to the spreadsheet) how do I adapt  it in the code? 

Sub Macro9()

    Workbooks.Open Filename:=Range("F7")

    Sheets("CV").Select
    Cells.Select
    Range("A17").Activate
    Selection.Copy
    Windows("01 - EMEA Mortgages Reporting Pack - Jan 15 (B) Test.xlsm").Activat

How to switch between windows in Excel when the path is referenced in a Excel cell?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.

Microsoft Excel

A spreadsheet is an interactive computer application program for organization, analysis and storage of data in tabular form. Spreadsheets developed as computerized simulations of paper accounting worksheets. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array may contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.

Spreadsheets

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.