No announcements
Found 2103899 threads
-
3 VotesPowershell script to skip a password protected excel workbook from search string and relocating to server
I keen and started learning Powershell, i started from basic script, but as i mentioned in this trialing post, my intention for ...Answered | 11 Replies | 5928 Views | Created by Mohammed_Jaz - Wednesday, November 22, 2017 4:36 AM | Last reply by jrv - Monday, November 27, 2017 3:02 PM
-
0 Votes
Password on Excel Workbook
Hi MarkPorto, Microsoft has added password protection capability to many features in Office programs to help prevent unauthorized access to important information.Answered | 1 Replies | 652 Views | Created by MarkPorto - Saturday, August 22, 2015 5:33 PM | Last reply by Emi Zhang - Monday, August 24, 2015 3:23 AM -
1 Votes
Using Powershell to protect specific Cells in Excel
Do very little in PowerShell, Remember that Excel was automated well before scripting started to be used with Excel.Answered | 6 Replies | 2430 Views | Created by Dufkess - Monday, November 10, 2014 4:48 PM | Last reply by jrv - Tuesday, November 11, 2014 3:18 PM -
1 Votes
Script to search directory for password protected office documents
" } #Or use below code: if ( $doc.ProtectionType -ne -1 ) { Write-Host ($doc.Name + " is password-protected.Answered | 1 Replies | 4949 Views | Created by SpongeBob10 - Tuesday, October 1, 2013 4:19 PM | Last reply by Yan Li_ - Wednesday, October 2, 2013 8:46 AM -
8 Votes
PS script to find for string in Excelworkbook and move to other location
Few of the user have password protected their Worksheet, is their a way to skip for password protected workbook and continue ...Answered | 25 Replies | 1980 Views | Created by Mohammed_Jaz - Saturday, November 11, 2017 2:53 PM | Last reply by Mohammed_Jaz - Friday, December 1, 2017 3:29 PM -
0 Votes
Powershell to append data to excel workbook
I just wanted to know how I can append to the excel workbook. not asking to re-write the script.Answered | 7 Replies | 12846 Views | Created by dedwards99 - Tuesday, March 6, 2018 7:53 PM | Last reply by jrv - Tuesday, March 6, 2018 10:57 PM -
0 Votes
Open Password protected excel using Excel Services
Hi, Workbooks, worksheets, or ranges with protection, and workbooks that have Information Rights Management (IRM) are not supported.Answered | 1 Replies | 758 Views | Created by Kratzzz - Tuesday, December 4, 2018 5:08 PM | Last reply by Lee__li - Wednesday, December 5, 2018 3:39 AM -
0 Votes
Load data from password protected Excel sheet into SQL server Table using SSIS
Hi Sanjay, According to your description, you want to load data from a password protected Excel sheet located on SharePoint to SQL ...Answered | 2 Replies | 6476 Views | Created by Sanjay557 - Tuesday, December 1, 2015 5:28 PM | Last reply by Katherine Xiong - Wednesday, December 2, 2015 3:52 AM -
0 Votes
Password protect worksheet in Excel 2010
So go to File -- Info -- and then click on Protect Workbook to get that drop-down.Answered | 1 Replies | 3316 Views | Created by behpour - Saturday, December 29, 2012 9:01 PM | Last reply by Chris DeCarlo - Sunday, December 30, 2012 8:05 AM -
1 Votes
Adding a workbook to Excel with Powershell is trying to open Outlook.
I found that if I make the add sheet command like below instead of the one from my original post that I do not see a process for outlook initialize.Answered | 2 Replies | 8616 Views | Created by JustinS00 - Sunday, October 16, 2011 11:05 PM | Last reply by JustinS00 - Monday, October 17, 2011 1:47 AM -
0 Votes
Store password in Powershell script
you can store the password, encrypted, within the script.Answered | 3 Replies | 4541 Views | Created by CesarTabares - Tuesday, April 12, 2016 10:44 AM | Last reply by Xecros - Tuesday, April 12, 2016 5:30 PM -
0 Votes
Importing Password protected worksheets & workbook in power query to consolidate data
In Power BI you can use an R (or Python) script as a workaround.Answered | 2 Replies | 3205 Views | Created by Jahn Shrestha - Tuesday, October 30, 2018 9:47 AM | Last reply by Imke Feldmann - Saturday, November 3, 2018 7:14 AM -
0 Votes
Password protected Excell subscription from reporting services
3) still in the same stored procedure execute a VBS script that uses the Excel interop to open the excel file and "save as" with a ...Answered | 2 Replies | 5287 Views | Created by David Hills - Tuesday, January 31, 2012 4:46 PM | Last reply by tonyzoc - Monday, May 6, 2013 7:17 PM -
1 Votes
Embed VBA (Excel macro) in Powershell script
Hi Steve, sure there is a way to do this in PowerShell.Answered | 2 Replies | 7879 Views | Created by Steve Graves - Thursday, August 20, 2015 6:48 AM | Last reply by jrv - Thursday, August 20, 2015 11:20 AM -
0 Votes
excel 2010 protect with password
Hi Just Google something like this : "excel 2010 password recovery tool" and you should fine something.Answered | 4 Replies | 1046 Views | Created by Neo-Support - Wednesday, December 24, 2014 10:08 AM | Last reply by - Saturday, January 7, 2017 6:44 AM -
97 Votes
Password Removal Excel 2010
" OK - YES File - Info - Permissions - Protect Workbook - Encrypt with Password - Clear dots from box - OK Save ...Answered | 66 Replies | 516938 Views | Created by gymmbo - Friday, June 18, 2010 10:03 PM | Last reply by jonrink - Tuesday, November 5, 2019 6:15 AM -
0 Votes
Script to update password for protected servers on untrusted domain
As we are only updating/changing the password for a local account you can use command NET USER <username> <password>.Answered | 2 Replies | 5772 Views | Created by DenverTechGuy - Thursday, February 16, 2012 4:15 PM | Last reply by Wilson Souza - Tuesday, March 6, 2012 2:56 AM -
0 Votes
Excel Query connection string same workbook
I searched many forums and the VBA available are very long.Answered | 5 Replies | 4777 Views | Created by Maneesh Agrawal - Saturday, May 7, 2016 8:48 AM | Last reply by Emi Zhang - Tuesday, May 10, 2016 7:53 AM -
1 Votes
PowerShell - Searching Excel and replacing text
Your script remove the whole "SMTP:JOHN.SMITH@AA.COM" instead of only the "SMTP".Answered | 4 Replies | 15880 Views | Created by gazzamon - Tuesday, February 18, 2014 8:54 PM | Last reply by damup1988 - Wednesday, May 15, 2019 7:09 AM -
0 Votes
Cannot open password protected Excel 2016 file.
Hi, Microsoft has added password protection capability to many features in Office programs to help prevent unauthorized access to important information.Answered | 2 Replies | 1907 Views | Created by Grangerider - Friday, May 25, 2018 11:19 PM | Last reply by Emi Zhang - Monday, May 28, 2018 5:48 AM - Items 1 to 20 of 2103899 Next ›
No announcements
