I have created a task that creates a new Excel workbook, writes the contents of a dataset to the workbook, closes the workbook, then emails the workbook as an attachment. This workbook will contain sensitive information that needs to be password protected before sending.

I can find lots of topics regarding opening password protected workbooks, but have not found one regarding creating a password protected workbook.

Any suggestions?

Category Survey

NormalAlbertson,

I would suggest opening Excel going to the help feature and typing 'password'. Irregardless of the version of Microsoft Office being used there will be detailed steps on how to password protect a workbook.

Category Survey

-------------------------

Valentineo McGowan | Technical Consultant
AutoMate | Division of HelpSystems
HelpSystems, LLC | T: +1 213.738.6966 | F: +1.213.738.7665

Hi Norm,

AM9 does not have the ability to add a password to an Excel spreadsheet. Our upcoming release of v10 will have that functionality. In the meantime, you can use our Interactivity actions/activities to add the password through Excel or you can use our Compression action to compress and password protect the file.

Category Survey AutoMate 9 version: Windows version:

-------------------------

Leonard Amabile | Director, Cross Platform Support
AutoMate | InterMapper | Skybot | Divisions of HelpSystems
T: +1.213.738.1700 | F: +1.213.738.7665

So there is no function in Automate 9 to password protect the workbook?

Category Survey

I will look into those options. Thank you.

Category Survey

Hi,

On the flip side, how could I open a password protected XLSX using Automate?

Thanks,
Rich

Category Survey

Hello Flowers,

Unfortunately in 9 there is no way to password protect Excel Sheets. This is something that will be available in version 10.

If you get prompted to enter a password, we can use interactivity to enter that password into the password field.

Category Survey

-------------------------

Alex Escalante | Support Analyst
AutoMate | Division of HelpSystems
HelpSystems, LLC | T: +1.213.738.1700 | F: +1.213.738.7665

Edited: 07/11/2014 at 03:53 PM by Alex Escalante