Export to Excel & protect

  • Thread starter Thread starter Joe
  • Start date Start date
J

Joe

I had wriiten a query to export data to a Excel file.

How can I protect the Excel file that need to fill in password when amend
the data (just like [Protection] function in Excel) ?

thanks.

Joe
 
Joe said:
I had wriiten a query to export data to a Excel file.

How can I protect the Excel file that need to fill in password when amend
the data (just like [Protection] function in Excel) ?
Click to expand...

You must use the Excel objects for this e.g. using automation or the
Excel UI itself. Note that adding a workbook password will cause the
data to become encrypted. There is no way to decrypt the data when
subsequently querying the workbook using Jet (e.g. via MS Access).
Similarly, there is no way for Jet to encrypt the data.

Jamie.

--
 
Back
Top