Re: CR 8.5 exporting to Excel.

From: Bob Holmes (rholmes_at_REMOVEmmwec.org)
Date: 08/17/04 

Date: Tue, 17 Aug 2004 09:09:18 -0400

Hi Stephen,
    Sorry I didn't get this to you yesterday. Work sort of got in the way.
This little routine will open your spread***, set the protection and then
save it without the user being aware. If someone opens the spread***, it
is already protected. It may not be the cleanest code, but it works. You
may have to add code to check for the protection already being on, if this
is not a brand new file. You might also need to change thing so that you
don't accidentally shut down Excel if the user has another workbook open. 

--
Bob Holmes MCNGP #31
"Stephen" <stephen@stephen.com> wrote in message
news:cfqcj1$k8j$1@hercules.btinternet.com...
> Through code.I use something along the lines of
>
> set crxExportOptions = Report.Exportoptions
> crxExportoptions.FormatType = crEFTExcel70Tabular
> crxExportOptions.destinationtype = crEDTDiskfile
> .
> .
> .
> .
> .
> report.export False
>
> which works nicely to give me my excel file save to the destination, but
> what I really need is for this file to be uneditable,
> i.e. Locked *** as you would do through [ Tools -> protect *** ]  but
I
> want to do this in the code, not manually. So as soon as the user opens
the
> file its protected.
>
> Thanks
> Stephen.
>
>
>
>
> "Bob Holmes" <rholmes@REMOVEmmwec.org> wrote in message
> news:uzE8Hm4gEHA.384@TK2MSFTNGP10.phx.gbl...
> > Hi Stephen,
> >     Do you want to do this manually, or through code?
> >
> > --
> > Bob Holmes MCNGP #31
> > "Stephen" <stephen@stephen.com> wrote in message
> > news:cfq793$88b$1@sparta.btinternet.com...
> > > Hi,
> > >
> > > A quick question regarding exporting a report to Excel.
> > > I have written the code to export my report to excel, and it all works
> > fine,
> > > but now I want to be able to lock the excel *** so that none of the
> data
> > > is editable.
> > > Is this possible? if some one could help it would be appreciated.
> > >
> > > Thanks.
> > > Stephen.
> > >
> > >
> >
> >
>
>