How do you use a variable to set a password on an excel file? - VisualCron - Forum

Community forum

Sarastro
2017-01-13T14:59:01Z
Is it possible to create a password protected excel file using a password obtained from a visualcron variable?

I am using the 'Excel- Create' task and would like to create a file with a password that is supplied by a customer on a text file. I can read the contents of the text file but cannot use it to create the password. Help appreciated.
Support
2017-01-16T08:45:37Z
What do you mean you cannot use it to create a password? If you read with File read Task you can use {TASK(PrevTask|StdOut)} in follow up Set Excel Task.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Sarastro
2017-01-16T11:58:30Z
Originally Posted by: Support 

What do you mean you cannot use it to create a password? If you read with File read Task you can use {TASK(PrevTask|StdOut)} in follow up Set Excel Task.



Thanks for replying Henrik. I am able to read the password using READ FILE task but unable to get the follow-up task i.e. EXCEL - SET or CREATE tasks to accept the variable {TASK(PrevTask|StdOut)} as the password. I have attached a screenshot to better explain the problem. What am I doing wrong?

capture_2017-01-16_11-56-08.jpg
Support
2017-01-16T14:43:25Z
Thanks, it seems to be a bug. Please test this version:

http://www.visualcron.co....aspx?g=posts&t=7049 
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Sarastro
2017-01-17T10:11:25Z
Originally Posted by: Support 

Thanks, it seems to be a bug. Please test this version:

http://www.visualcron.co....aspx?g=posts&t=7049 



I have tested version 8.2.4. and received an error message (see attached image).

capture_2017-01-17_10-01-30.jpg
Support
2017-01-17T18:54:01Z
Originally Posted by: Sarastro 

Originally Posted by: Support 

Thanks, it seems to be a bug. Please test this version:

http://www.visualcron.co....aspx?g=posts&t=7049 



I have tested version 8.2.4. and received an error message (see attached image).

capture_2017-01-17_10-01-30.jpg



I think the problem is that previously, the Excel sheet was saved with the Variable as password. Now when loading we use the Variable value - so the problem is that password is wrong now.

I think the stored password is now {TASK(PrevTask|StdOut)} and not the value in that Variable. I suggest opening the Excel file with Excel to confirm this.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Sarastro
2017-01-18T11:50:49Z
Hi Henrik!

Your advice was correct. I deleted the existing EXCEL - CREATE task and re-created it again.
It now works brilliantly!!

Thank you for your patience and help
😁
Support
2017-01-20T09:39:07Z
Great, thanks for the report!
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Scroll to Top