Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for
- SS&C Blue Prism Community
- Get Creative
- Product Ideas
- Excel VBO - Extended Version 2.0 - Save As with Pa...
Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Email to a Friend
- Printer Friendly Page
- Report Inappropriate Content
martin_reuter
Level 4
Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Email to a Friend
- Printer Friendly Page
- Report Inappropriate Content
12-08-20
03:11 PM
Status:
New
In Excel VBO a slight change would allow the application of password to workbooks, when saving them. Currently a pwd can only be used, if the original file contains one already.
Module: Save Workbook As
1. Add as new input parameter in the Start stage: i_pw_WbkPwd
2. Add the same in the code stage as input parameter PWD
3. In the code of the code stage change:
wb.saveas(filename)
to
wb.saveas(filename,,PWD)
That's it...
Kind Regards
Martin Reuter
PS: this would mean that we can use the standard version and do not have to customize it for ourselves... Thank you.
Module: Save Workbook As
1. Add as new input parameter in the Start stage: i_pw_WbkPwd
2. Add the same in the code stage as input parameter PWD
3. In the code of the code stage change:
wb.saveas(filename)
to
wb.saveas(filename,,PWD)
That's it...
Kind Regards
Martin Reuter
PS: this would mean that we can use the standard version and do not have to customize it for ourselves... Thank you.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Idea Statuses
- New 830
- Duplicate 76
- Needs More Info 51
- Reviewed 214
- Under Consideration 151
- Not Planned 83
- Planned 54
- Planned-Later 21
- Planned-Next 6
- Planned-Now 11
- Delivered 136
