[AccessD] Securing an Excel file programmatically from Access

Bucher, Dave Dave.Bucher at state.mn.us
Wed Apr 2 16:26:57 CST 2003


Hi Everyone-

Great praise to all you gurus who I've garnered much from in the past.

Using Access97 and Excel97 ... I'm using DoCmd.OutputTo in Access to output
reports in .xls format and programatically send (twice a month) to a client
outside our network.  The problem is, our network is secure and client's
isn't, so the folks enforcing the big bad fed privacy laws don't want to let
us send things with the push of a button!  Talk about trying to keep good
gov't. down!

Does anyone have code to secure the newly (OutputTo) created Excel worksheet
after it has been created prior to sending?

Thanks much!

Dave Bucher
Information Technology Specialist
Children's Research, Planning and Evaluation

"Launch your boat, oh blessed youth, and flee at full speed from every form
of culture."--Epicurus



More information about the AccessD mailing list