Make a workbook from a sheet and name it the same as the original workbook + (email)

**fuadramsey** · 06-25-2018, 06:07 PM

I want to email a worksheet as a attachment. I found a macro that does this, but I want to change the name of the workbook to be the same as the original workbook with "email" added to the name.

The macro below does this but saves the new workbook as the sheet name, which I do not want. Please advise! Thanks!

Please Login or Register  to view this content.

**Logit** · 06-25-2018, 07:23 PM

.

Please Login or Register  to view this content.

Make a workbook from a sheet and name it the same as the original workbook + (email)

LinkBack

Thread Tools

Rate This Thread

Display

Make a workbook from a sheet and name it the same as the original workbook + (email)

Re: Make a workbook from a sheet and name it the same as the original workbook + (email)

Thread Information

Users Browsing this Thread

Similar Threads

open worksheet in a different workbook based on cell name in original workbook

[SOLVED] Macro to unlock sheet, copy to new workbook, then re-lock original sheet

Create new Workbook based on my sheet8 from original workbook as .xls if statement (2007)

[SOLVED] Save Active Sheet As New Workbook in same folder of the original workbook

Saving workbook as notepad using cell data for filename & retaining original workbook name

loop through a column on a workbook copying data on each row to another workbook, then copy data back to the original workbook

How do i include the original workbook in the email message creat.

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions