# Importing password-protected xlsx

**URL:** <https://community.easymorph.com/t/importing-password-protected-xlsx/373>\
**Category:** General Q&A\
**Created:** [December 13, 2017, 9:50am UTC](https://community.easymorph.com/t/importing-password-protected-xlsx/373 "2017-12-13T09:50:47Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![dgudkov](https://community.easymorph.com/user_avatar/community.easymorph.com/dgudkov/32/5_2.png) [@dgudkov](https://community.easymorph.com/u/dgudkov)\
**Post date:** [December 14, 2017, 1:47am UTC](https://community.easymorph.com/t/importing-password-protected-xlsx/373/2 "2017-12-14T01:47:24Z")

</div>

Apparently, EasyMorph can't load password-protected Excel workbooks at this point.

I did a bit of research -- it's possible to remove/disable the password using a VBA macro. The macro can reside in another workbook, which gets executed from the command line [[hint](https://stackoverflow.com/questions/2050505/way-to-run-excel-macros-from-command-line-or-batch-file)].

Alternatively, this can be done using a PowerShell script, something like that ( **not tested!** ):

```
$excel = new-object -comobject excel.application
$workbook = $excel.workbooks.open("C:\myfile.xls",0,$False,1,"password")
$workbook.Password = ""
$workbook.save()
$workbook.close()
$excel.quit()

```

In v3.7 there is the PowerShell transformation that can be used for running PowerShell commands. Or simply run a script from command line using "RunProgram" and PowerShell executable.

Once the password is removed the workbook can be loaded in EasyMorph in a regular way.

---

_[View the full topic](https://community.easymorph.com/t/importing-password-protected-xlsx/373)._