Unanswered: How do i run a macro in a different, PW protected database in VB?
If anyone can help I'd be very grateful!! There are two databases involved - the datasource and calculations database and the recipient db. I need to run all the queries and macros in the first and then put the results into a table in the second - which is password protected. I can't take the password off because I don't want other users to be able to access the db (it's the back end to a different piece of software). I have all the macros and queries written and am opening the 2nd db using the shell command... but I haven't a clue how to write the pw into it