Exporting a worksheet

[cs0rpc]

Hi there,

I am after some code to achieve the following. Can anyone be kind enough to help out:

1. Open dialogue box
2. Set save path and filename
3. Move pre-defined worksheet to new file ' these will be set by worksheet name within the code (worksheet name is already hard-coded within earlier code so is not at risk of changing)
4. Save file as filename and to path defined in step 2
5. Close saved file
6. Delete pre-defined worksheet
7. Confirm export to user



Thanks,

Rob.

[AlphaFrog]

Change the sheet name to suit.

Please Login or Register  to view this content.

[cs0rpc]

Thanks! That's really useful.

Would you be able to expand a little as to how I would achieve copying two sheets from the source, both to the same destination?


Thanks,

Rob.

[cs0rpc]

Thanks! That's really useful.

Would you be able to expand a little as to how I would achieve copying two sheets from the source, both to the same destination?


Thanks,

Rob.

[AlphaFrog]

Change this...
With Sheets("Sheet1")

To something like this...
With Sheets(Array("Sheet1", "Sheet2"))