<div>
try <br />
<br />
Workbooks.Open Filename:=&quot;Full Path Name&quot;, Password:=&quot;Apassword&quot;, &nbsp;_ WriteResPassword:=&quot;Apasswo<wbr />rd&quot;
</div>


try

Workbooks.Open Filename:="Full Path Name", Password:="Apassword",  _ WriteResPassword:="Apassword"

<div>
I also need to copy and paste special a specific range from this closed workbook and paste the values into my active worksheet.
</div>


I also need to copy and paste special a specific range from this closed workbook and paste the values into my active worksheet.

<div>
Note that this does not use copy/paste - in VBA it's nearly always better just to assign the values from one range to another. &nbsp;Copy/paste can be useful if you need to take formats as well, but generally is an unnecessary overhead.
</div>


Note that this does not use copy/paste - in VBA it's nearly always better just to assign the values from one range to another.  Copy/paste can be useful if you need to take formats as well, but generally is an unnecessary overhead.

<div>
Thanks Andrew! Much appreciated!
</div>


<div>
<div class="content wysiwyg-content">
I need to get some data from this range in my closed workbook that is password protected:<br />
<br />
M22:O29<br />
<br />
How can I retrieve this data and paste special (values) into my active workbook into range A2:C9?
</div>
</div>


I need to get some data from this range in my closed workbook that is password protected:

M22:O29

How can I retrieve this data and paste special (values) into my active workbook into range A2:C9?

Get data from closed workbook that is password protected

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