Add column to different worksheet
<p>I want to add a dynamic column into a different workbook.</p>

<p>Say I'm working in 1st Excel file and I want to add a column in 2nd Excel file.</p>

<p>My code is adding the column into the 1st Excel file.</p>

<pre><code>Sub insertColumn()
Range("B1").EntireColumn.Insert
End Sub
</code></pre>

<p>I also tried using</p>

<pre><code>Woorkbook("newfile.xls").Worksheets("sheet1"). Range("B1").EntireColumn.Insert
</code></pre>