Hi, got a problem with the propogation of password properties to saved
versions of a report template. I have made a report available to our
user community and applied an open file password protection so that
only the selected few can open the report. That's all fine and dandy
but part of the report functionality is to generate various value
pasted versions of the report with different file names that can be
distributed to the world at large, without the direct link to a
restricted data source that exists in the template. The macro uses the
template to loop through a number of different scenarios, changing the
report view in each instance; this version is then saved with a unique
file name to a common directory. However, it appears that on every
loop, the open file password is called; in addition, the saved versions
all retain the password protection which is not what I want to happen,
they should be available to whoever they are sent to. Is there a way to
avoid this?