View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Sly101 Sly101 is offline
external usenet poster
 
Posts: 2
Default save worksheet then email the saved worksheet

Hi, what I'm looking for is a macro that will save a worksheet as a new
workbook with whatever customer name in a cell in this said worksheet and
then email the new workbook, all by on click. I'm trying to keep this sheet
as dummy proof as possible.
Thanks