Network Automation Software We are currently migrating this forum
over to our HelpSystems domain. Please
post all new threads in our new
HelpSystems Community Portal.
Post to the HelpSystems Forum
You are not currently logged on. You must be logged on in order to post. Log on
Or Create a new account
AutoMate Discussion
Decrease font size
Increase font size
Topic Title: Password Protect an Excel Workbook
Topic Summary:
Created On: 09/18/2013 06:12 AM
Status: Read Only
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
View similar topics View similar topics
View topic in raw text format. Print this topic.
Answer This question was answered by Leonard Amabile, on Wednesday, September 18, 2013 10:38 AM

Answer:
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.

 09/18/2013 06:12 AM
User is offline View Users Profile Print this message

Author Icon
NormAlbertson
n00b (>6 posts)

Posts: 5
Joined: 09/03/2013

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
 09/18/2013 10:29 AM
User is offline View Users Profile Print this message

Author Icon
Valentineo McGowan
HelpSystems

Posts: 766
Joined: 09/03/2013

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
 09/18/2013 10:34 AM
User is offline View Users Profile Print this message

Author Icon
Leonard Amabile
HelpSystems

Posts: 5454
Joined: 05/15/2007

Answer Answer
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
 09/18/2013 10:37 AM
User is offline View Users Profile Print this message

Author Icon
NormAlbertson
n00b (>6 posts)

Posts: 5
Joined: 09/03/2013

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



 Category Survey
 09/18/2013 10:38 AM
User is offline View Users Profile Print this message

Author Icon
NormAlbertson
n00b (>6 posts)

Posts: 5
Joined: 09/03/2013

I will look into those options. Thank you.



 Category Survey
 07/11/2014 12:11 PM
User is offline View Users Profile Print this message

Author Icon
flowers
Artisan (200-499)

Posts: 259
Joined: 01/08/2009

Hi,

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

Thanks,
Rich

 Category Survey
 07/11/2014 03:44 PM
User is offline View Users Profile Print this message

Author Icon
Alex Escalante
HelpSystems

Posts: 871
Joined: 02/26/2014

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
Statistics
18258 users are registered to the AutoMate Discussion forum.
There are currently 0 users logged in.
The most users ever online was 5551 on 01/08/2018 at 11:11 AM.
There are currently 1428 guests browsing this forum, which makes a total of 1428 users using this forum.

FuseTalk Enterprise Edition v4.0 - © 1999-2020 FuseTalk Inc. All rights reserved.

Sitemap Network Automation Software Blog