I have a file that generates a report automatic using the Aut
pen macro and the scheduler .. at 6 am the file open and imports data from other files and generates report, then, the report is auto save as a file with at date code added. Problem ... when the file is rename it still contain the Aut
pen macro. I have several people that need to use the data from the report but it runs the macro when opened ... I know to hold the shift key when opening the file but others fail to remember .... can I add a macro when saving to strip the Aut
pen from the newly created file????


