Excel Automation

[graveyard]

Hi people. may i know how do i use common object model (automation) to set password programmatically for excel files without opening them? I am dealing with 50 files so its too much to open every one and set password manually. And i cant use the same file over and over again as these files were exported automatically to excel spreadsheets which means each file will be overwritten from time to time

as such i cant have macro embedded in the file as those will be overwritten too. Was wondering if there is a way to set different password to each file which will be put on a FTP server (as these will contain sensitive data, password is imperative to prevent unauthorised access).

Appreciate if someone could shed some light - thanks!

 

[Weaver]

Welcome to the board.

I don't know about adding a password without opening the file, but you could open it in the background and resave it with a password added.

PS I'm assuming the password would be the same in each case, although that wouldn't necessarily make it impossible if they were different, just harder to manage.

 

[graveyard]

Welcome to the board.

I don't know about adding a password without opening the file, but you could open it in the background and resave it with a password added.

PS I'm assuming the password would be the same in each case, although that wouldn't necessarily make it impossible if they were different, just harder to manage.

hi weaver, thank you. its nice joining the board here. ive w workaround for this by exporting the excel files via macro to folders with restricted access on a shared drive.

Thanks for your reply!!