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?
End up with SaveAs dialog
-
- Administrator
- Posts: 78536
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: End up with SaveAs dialog
Will the user enter data directly into the workbook, or through input boxes or a userform?
Best wishes,
Hans
Hans
-
- StarLounger
- Posts: 93
- Joined: 10 Oct 2019, 09:43
Re: End up with SaveAs dialog
Data will be copied direct from another spreadsheet, direct into a specific sheet in the template.
-
- Administrator
- Posts: 78536
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: End up with SaveAs dialog
Do you copy using VBA code? Or will the user copy the data?
Best wishes,
Hans
Hans
-
- StarLounger
- Posts: 93
- Joined: 10 Oct 2019, 09:43
Re: End up with SaveAs dialog
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
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
-
- Administrator
- Posts: 78536
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: End up with SaveAs dialog
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
Best wishes,
Hans
Hans
-
- StarLounger
- Posts: 93
- Joined: 10 Oct 2019, 09:43
Re: End up with SaveAs dialog
Thank - exactly what I needed.
Cheers
Cheers