Solved: Automatically Save As when file opens

[agnesz]

Is there any way I can have vba in a file which automatically, once a file is opened, it prompts the user to Save As???

[mdmackillop]

Put this in ThisWorkbook module.

Private Sub Workbook_Open()
Application.Dialogs(xlDialogSaveAs).Show
End Sub

[agnesz]

works like a charm!
thank you