End up with SaveAs dialog

[Lost Paul]

Hi,

I'm putting together a template where a user enters data.
Then after a number of steps, I would like the SaveAs dialog box to open and stop there.

Is this doable?

[HansV]

Will the user enter data directly into the workbook, or through input boxes or a userform?

[Lost Paul]

Data will be copied direct from another spreadsheet, direct into a specific sheet in the template.

[HansV]

Do you copy using VBA code? Or will the user copy the data?

[Lost Paul]

The copy paste will be manual.
Followed by(using VBA)
* filtering
* further copy/paste into a 'working' sheet (for other users)
* hiding (or deleting) import sheet
It's at this point I want the SaveAs to appear to the initial user/importer

[HansV]

Aha - if you already have a macro, add the following line between the part where you hide or delete the sheet and End Sub:

Code: Select all

    Application.Dialogs(xlDialogSaveAs).Show

[Lost Paul]

Thank - exactly what I needed.

Cheers