+ Reply to Thread
Results 1 to 1 of 1

Help emailing a sheet that has a dynamic name.

  1. #1
    Forum Contributor
    Join Date
    02-16-2008
    Location
    Mansfield, TX
    Posts
    324

    Help emailing a sheet that has a dynamic name.

    Hello, I have put together a database program where a user imports several excel files, then clicks a button to extract several cells to a new sheet within the workbook that is then emailed. All of this is done by clicking three buttons on the top of one of the sheets. My problem lies in emailing the new sheet as it will be named something different everytime it is created. What I need help with is how do I get the code below to email the sheet that has just been created when there may be several sheets in the workbook? Would it be easier to modify the macro that creates the new sheet, then adds the control button and assigns it to the correct macro?

    I am using the code below to email the active sheet.

    Please Login or Register  to view this content.
    This is the code I am using to create the new sheet.

    Please Login or Register  to view this content.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1