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