ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Import Module to New Workbook (https://www.excelbanter.com/excel-programming/381397-import-module-new-workbook.html)

Z-Excel

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!



All times are GMT +1. The time now is 03:39 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com