Help getting value from closed workbook with GetValue function without asking for password

[catalystsystems]

I am trying to get a value from a close workbook using this function

Please Login or Register  to view this content.

The workbook this function references is Microsoft password protected and the user is prompted to enter the password when the last line in the code runs. Is there a way to programmatically provide the password or bypass prompt for password.

[Winon]

Hello catalystsystems,

Unfortunately, your request falls within the scope of our Forum Rules;

Your post does not comply with Rule 11 of our Forum RULES.

Don't post questions regarding breaking or bypassing any security measure. Such posts will be deleted, and repeat offenders will be banned. This includes posting of links to sites that offer software, code or services to do this or posting of code to remove passwords

I suspect that this Thread will be Closed

Regards.

[FDibbins]

catalystsystems do you have the password for that file?

[Winon]

@ FDibbins,

Hey there my Friend. so nice to see you back in action! Hope things are much better with you now.

Take care!

[FDibbins]

Hi boetman. Yup, still keeping the kop active, good to see you again, my friend

[catalystsystems]

Thank you for your reply and clarification. My intent is not to bypass security measures but I certainly understand the need for this rule.

[FDibbins]

So if yo dont have the password for this file, I will close this thread now. PM me if you do have the PW, and I will re-open it for you

[FDibbins]

It seems that OP dos have the PW for this file (told me in PM), so I am going to re-open this file for them. If they dont want to post the PW in the thread, they can either change it to something else, or PM the PW to whoever will be assisting them

[catalystsystems]

Thanks for your help. The password for all of my database files is "catalyst".

When I open a protected workbook I can include the password, which works great. But opening other database workbooks is taking time and keeps the screen flashing even when Screen Updating is off. I am trying the GetValue function as a workaround.

Is there a way to provide the password in the code I'm using for the GetValue function? Or is this even the best way to data from a workbook I am using as a database?

[Zer0Cool]

Not with GetValue, as far as I can tell it wont even work if the sheet in the file is hidden. The sheet in the other file has to be able to be "activated" for the GetValue to work, which isnt possible if the file is password protected.

Another method may be trying an ADO stream to get the data, with that you should be able to pass the password to unlock the file and pull what you need. Its certainly a more complex approach. I havent used ADO for years, so I wouldnt be able to explain how. May want to research using ADO to do this.