EXPORT A TABLE IN *.xlsx FORMAT WITH PASSWORD PROTECTION

[Shafique]

HI EVERYONE....
I want to Export an Access Database table on OneDrive Folder Online Into an Excel format file.
So i want to protect the file's data with Password protection. I exported a table with help a Macro command as i want but it Visible and Available to everyone.
.
.
.
.
Is there any solution to Export hidden and protected Access Database Table.

 

[welshgasman]

Set it's hidden attribute?

comanndline to hide files - Google Search

 

[Shafique]

Set it's hidden attribute?

comanndline to hide files - Google Search

this link showing different types of results.

 

[welshgasman]

this link showing different types of results.

In what way?

 

[jdellasala]

Maybe instead of trying to export the data to an Excel file, you could try using Power Query and do the protection right within the Excel file where you could enable/disable it as needed.

 

[Shafique]

Maybe instead of trying to export the data to an Excel file, you could try using Power Query and do the protection right within the Excel file where you could enable/disable it as needed.

where is power query? how can i use it