andy_dyer
Registered User.
- Local time
- Today, 16:03
- Joined
- Jul 2, 2003
- Messages
- 806
Previous Problem
Present Problem
At present i run a macro to export a query to excel and run excel so that i can see it.
I now have a password set on the spreadsheet.
I had the brainwave to try and send keys to allow this action to still work smoothly...
With this I now have an error...
"Can't decrypt file"
I sometimes get multiple openings of excel and lots of weird behaviour...
I would happily stop using a macro for this if this would help as long as someone can help me with the code needed for the above actions.
Basically I need the export to work smoothly with the password being entered... while anyone just trying to access the spreadsheet not going through the database (which is also password protected) would need the password.
Is this possible??
Present Problem
At present i run a macro to export a query to excel and run excel so that i can see it.
I now have a password set on the spreadsheet.
I had the brainwave to try and send keys to allow this action to still work smoothly...
With this I now have an error...
"Can't decrypt file"
I sometimes get multiple openings of excel and lots of weird behaviour...
I would happily stop using a macro for this if this would help as long as someone can help me with the code needed for the above actions.
Basically I need the export to work smoothly with the password being entered... while anyone just trying to access the spreadsheet not going through the database (which is also password protected) would need the password.
Is this possible??
