Hi All,
I have a access table that i need to export to a specific excel file and over write data to the same excel sheet without changing name to it. In addition i also need a code to password protect the excel file.
Presently i do a action macro which exports data and over writes but the password protection piece is missing. If some one can provide VBA code to password protect the excel file alone also is welcomed