View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Z-Excel Z-Excel is offline
external usenet poster
 
Posts: 1
Default Import Module to New Workbook

Hi,

I am hoping that some one can help me with this excel issue. I have a
module set up to copy one of my worksheets with in a workbook and save
it as a separate workbook (the name of the newly saved workbook is
determined by the date and one of the textbox.value within a user form
tied with the worksheet). I need to have this particular module be
saved with the new workbook as well. So I thought I could export the
module and then enter some code to import it when I am saving this
worksheet. Is this possible? Can I transfer the module with the sheet?
Please Help!