I have macro that i use to email by curent workbook. But when i email the attachment comes as book1. I want it to state the name of the Excel file. Below is the coding
HTML Code:
I have macro that i use to email by curent workbook. But when i email the attachment comes as book1. I want it to state the name of the Excel file. Below is the coding
HTML Code:
anyone ???
Hi, buwa84,
you copy the first sheet to a new workbook where the name in Book1. In order to change that name you would need to save the newly created workbook or maybe go a different way and delete all other sheets form the workbook, send the workbook and then directly close without saving. And I doubt that FullName which includes the drive and the folder to the workbook shoulöd be part of the new name.
Another problem appears with my version which won´t allow me to have 2 workbooks with the same name open.
Ciao,
Holger
Use Code-Tags for showing your code: [code] Your Code here [/code]
Please mark your question Solved if there has been offered a solution that works fine for you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks