VBA - Check for password protection
I have written code to filesearch and then trawl the workbooks for any comments containing a particular string. However when the code is running, if a sheet is password-protected it prompts. Is there any way of checking to see if a file is PP'd without actually trying to open it and therefore getting prompted? code is as below: Set oBook = oExcel.Workbooks.Open(strWkShtPathAndNme, 0, True) CIA, Matt. -- MattShoreson ------------------------------------------------------------------------ MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472 View this thread: http://www.excelforum.com/showthread...hreadid=480862 |
VBA - Check for password protection
Hello Matt, Not to my knowledge. Opening the file is what places it into Excel's Workbook Collection. Until it is in the collection, VBA can't access the object's properties. Add to that password protection is an internal routine that isn't exposed outside of the Workbook. Maybe there is a way using some other language or method, but with VBA the answer is no. Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=480862 |
VBA - Check for password protection
I went into vba propertiers and password protected. Still after f8 puts you
right back into the vba code. No request for password. Is ther something I am missing? Thanks "Leith Ross" wrote: Hello Matt, Not to my knowledge. Opening the file is what places it into Excel's Workbook Collection. Until it is in the collection, VBA can't access the object's properties. Add to that password protection is an internal routine that isn't exposed outside of the Workbook. Maybe there is a way using some other language or method, but with VBA the answer is no. Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=480862 |
VBA - Check for password protection
Hi Curt,
After protecting the project, to activate the protection, save the workbook, close and re-open Excel. --- Regards, Norman "Curt" wrote in message ... I went into vba propertiers and password protected. Still after f8 puts you right back into the vba code. No request for password. Is ther something I am missing? Thanks "Leith Ross" wrote: Hello Matt, Not to my knowledge. Opening the file is what places it into Excel's Workbook Collection. Until it is in the collection, VBA can't access the object's properties. Add to that password protection is an internal routine that isn't exposed outside of the Workbook. Maybe there is a way using some other language or method, but with VBA the answer is no. Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=480862 |
VBA - Check for password protection
Hi Curt,
close and re-open Excel. Should have read: close and re-open the workbook. --- Regards, Norman "Norman Jones" wrote in message ... Hi Curt, After protecting the project, to activate the protection, save the workbook, close and re-open Excel. --- Regards, Norman "Curt" wrote in message ... I went into vba propertiers and password protected. Still after f8 puts you right back into the vba code. No request for password. Is ther something I am missing? Thanks "Leith Ross" wrote: Hello Matt, Not to my knowledge. Opening the file is what places it into Excel's Workbook Collection. Until it is in the collection, VBA can't access the object's properties. Add to that password protection is an internal routine that isn't exposed outside of the Workbook. Maybe there is a way using some other language or method, but with VBA the answer is no. Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=480862 |
VBA - Check for password protection
DUHHH why didn't I think of this. Found out after posting the question.
Thanks for the reply Curt "Norman Jones" wrote: Hi Curt, close and re-open Excel. Should have read: close and re-open the workbook. --- Regards, Norman "Norman Jones" wrote in message ... Hi Curt, After protecting the project, to activate the protection, save the workbook, close and re-open Excel. --- Regards, Norman "Curt" wrote in message ... I went into vba propertiers and password protected. Still after f8 puts you right back into the vba code. No request for password. Is ther something I am missing? Thanks "Leith Ross" wrote: Hello Matt, Not to my knowledge. Opening the file is what places it into Excel's Workbook Collection. Until it is in the collection, VBA can't access the object's properties. Add to that password protection is an internal routine that isn't exposed outside of the Workbook. Maybe there is a way using some other language or method, but with VBA the answer is no. Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=480862 |
VBA - Check for password protection
DUHH ain't I the dummie
Thanks Curt "Norman Jones" wrote: Hi Curt, After protecting the project, to activate the protection, save the workbook, close and re-open Excel. --- Regards, Norman "Curt" wrote in message ... I went into vba propertiers and password protected. Still after f8 puts you right back into the vba code. No request for password. Is ther something I am missing? Thanks "Leith Ross" wrote: Hello Matt, Not to my knowledge. Opening the file is what places it into Excel's Workbook Collection. Until it is in the collection, VBA can't access the object's properties. Add to that password protection is an internal routine that isn't exposed outside of the Workbook. Maybe there is a way using some other language or method, but with VBA the answer is no. Sincerely, Leith Ross -- Leith Ross ------------------------------------------------------------------------ Leith Ross's Profile: http://www.excelforum.com/member.php...o&userid=18465 View this thread: http://www.excelforum.com/showthread...hreadid=480862 |
All times are GMT +1. The time now is 12:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com