<div>
I was actually thinking of calling Excel objects and unprotect the file from Access.<br />
<br />
If I include Microsoft Excel Object Library in my VBE References I could do it, I just don't know how.<br />
The command I want to trigger is:<br />
ActiveWorkbook.Unprotect Password:=&quot;blablabla&quot;<br />
<br />
How do I specify the workbook to be called?<br />
<br />

</div>


I was actually thinking of calling Excel objects and unprotect the file from Access.

If I include Microsoft Excel Object Library in my VBE References I could do it, I just don't know how.
The command I want to trigger is:
ActiveWorkbook.Unprotect Password:="blablabla"

How do I specify the workbook to be called?



<div>
That would be a great new question.<br />
<br />
You can add Excel references to your Access VBA coding. &nbsp;So, when you have an Active worksheet, you can use <br />

<div class="indent">
ActiveWorkbook.Unprotect Password:=&quot;blablabla&quot;
</div>
Yes, this would apply when opening an existing workbook.<br />
The export would use ActiveWorkbook.Protect<br />
<br />
Thank you for the grading and accepting my answer.
</div>


That would be a great new question.

You can add Excel references to your Access VBA coding.  So, when you have an Active worksheet, you can use

ActiveWorkbook.Unprotect Password:="blablabla"
Yes, this would apply when opening an existing workbook.
The export would use ActiveWorkbook.Protect

Thank you for the grading and accepting my answer.

<div>
<div class="content wysiwyg-content">
I have an Access DB that transfers data to an Excel file through the following code:<br />
DoCmd.TransferSpreadsheet acExport, 8, &quot;zLOA_List&quot;, &quot;C:\WFReports_CG.xls&quot;, True, &quot;&quot;<br />
<br />
I have recently protected the workbook and when execute the code above I get &quot;could not decrypt the file&quot;<br />
<br />
Is there a way to unprotect the file from Access?<br />

</div>
</div>


I have an Access DB that transfers data to an Excel file through the following code:
DoCmd.TransferSpreadsheet acExport, 8, "zLOA_List", "C:\WFReports_CG.xls", True, ""

I have recently protected the workbook and when execute the code above I get "could not decrypt the file"

Is there a way to unprotect the file from Access?


Unprotect Excel File from Access

Microsoft Office is an integrated suite of applications that includes Outlook, Word, Excel, Access, PowerPoint, Visio and InfoPath, along with a number of tools to assist in making the individual components work together. Coding within and between the projects is done in Visual Basic for Applications, known as VBA.

Microsoft Office

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.