Save worksheet as workbook but with 'save as' feature

Hi guys,

I have the following excel code that saves my worksheet as a pdf file and now I am trying to find a way to modify the code so it saves the worksheet not as a pdf file but as another excel workbook and also if possible, could you please write a separate code to email the saved worksheet to other people?

- is it possible to add the feature to save the workbook manually so I can choose the location where I want to save the file?

- I believe the code for 'page setup' can be removed? since I want to save the entire worksheet as workbook?

Please Login or Register  to view this content.

I'd also like to use the range "A1" as a save as filename destination in the code.

Any help?

Much appreciated in advance.

Jin

You could try

Please Login or Register  to view this content.

Instead of using "Sheets(1).Copy" you could use "ActiveSheet.Copy" i.e. the sheet you are working with at the moment.

Alf