Read a password to a table in a Macro

[Guest]

I have some tables in my Db that are password protected. I am automating
multiple steps in a Macro and would like to build in a step that reads the
password. Someone had recommened the sendkeys Action in a macro, but that
doesn't work for me. I have tried to set up an Autokeys macro but it doesn't
like the syntax of the password.

I basically want to simulate entering a password for a table in a macro.

Any suggestions.

TIA

Lyric

 

[Guest]

Since I don't use Macros, I am fuzzy on some of the details. If I remember
correctly, I think there is some way to control macro execution based on
conditions, but I haven't a clue how to do that. I only respond to give a
directional suggestion and perhaps if you are more schooled in Macros than I,
it will give you an idea.

You could write a VBA function that accepts and tests the password and
returns True or False, then base what your macro does on that.

 

[Guest]

Since a table cannot be directly password protected can you post the method
you use to simulate protection?