G
Guest
I'm trying to automate a process involving Access and a linked Excel
spreadsheet that is protected with a password. My approach is to build a
batch file that will open an Excel (2003) spreadsheet and execute a macro
that unprotects the sheet, saves and closes it thereby allowing the batch
file to run the Access code (which updates the spreadsheet file), and finally
run another Excel macro to protect and save the changed Excel file.
Can this be done with command line switches / options? Am I asking the
impossible? Is there a betterway? Thanks.
spreadsheet that is protected with a password. My approach is to build a
batch file that will open an Excel (2003) spreadsheet and execute a macro
that unprotects the sheet, saves and closes it thereby allowing the batch
file to run the Access code (which updates the spreadsheet file), and finally
run another Excel macro to protect and save the changed Excel file.
Can this be done with command line switches / options? Am I asking the
impossible? Is there a betterway? Thanks.