trystanhuwwilliams1
Programmer
Hello,
Is it possible to send a password from Access to Excel? I have a log-on form in access which opens individual Excel FlexiTime workbooks when the user logs on with their password. All the workbooks are further protected by a system password to prevent backdoor access.
My current log-on form is an excel spreadsheet which allows me to supply the password through VB:-
I now want this log-on form to be in Access, but I can't seem to get around the problem of the system password.
I'd appreciate any suggestions,
Thank you
Is it possible to send a password from Access to Excel? I have a log-on form in access which opens individual Excel FlexiTime workbooks when the user logs on with their password. All the workbooks are further protected by a system password to prevent backdoor access.
My current log-on form is an excel spreadsheet which allows me to supply the password through VB:-
Code:
mypath=[path of workbook]
ChDir ("O:\")
Workbooks.Open mypath, , , , "Password"
ActiveWorkbook.RunAutoMacros xlAutoOpen
I now want this log-on form to be in Access, but I can't seem to get around the problem of the system password.
I'd appreciate any suggestions,
Thank you