 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Programming / May 2008getting macro installed in each new workbook
I have a function that creates new custom workbooks for each client and distributes them across a network. How can I get a macro automatically placed in the OnOpen event of each new workbook when it is generated? The workbooks are generated from the transferspreadsheet function in Access using Win XP Pro and Office 2003. Thanks in advance  SignatureJeff C Live Well .. Be Happy In All You Do Hi Jeff. See Chip Pearson at: Programming The VBA Editor http://www.cpearson.com/excel/vbe.aspx --- Regards. Norman >I have a function that creates new custom workbooks for each client and > distributes them across a network. [quoted text clipped - 7 lines] > > Thanks in advance SignatureJeff C Live Well .. Be Happy In All You Do > Hi Jeff. > > See Chip Pearson at: > > Programming The VBA Editor > http://www.cpearson.com/excel/vbe.aspx Thanks for the reference Norman but once each of the new workbooks is created I am not opening any of them. I was hoping to find something that could cause a macro/function to be automatically placed in each new workbook that is created. I am not sure which of Chip Pearson's solutions to use. > --- > Regards. [quoted text clipped - 11 lines] > > > > Thanks in advance Hi Jeff, ============ > See Chip Pearson at: > > Programming The VBA Editor > http://www.cpearson.com/excel/vbe.aspx Thanks for the reference Norman but once each of the new workbooks is created I am not opening any of them. I was hoping to find something that could cause a macro/function to be automatically placed in each new workbook that is created. I am not sure which of Chip Pearson's solutions to use. ============ At the suggested link, see Chip's section entitled: Creating An Event Procedure --- Regards. Norman Can you leave a blank workbook template with a macro on the network and start with that? Instead of creating it, copy it. SignatureTim Zych www.higherdata.com Compare data in workbooks and find differences with Workbook Compare A free, powerful, flexible Excel utility >I have a function that creates new custom workbooks for each client and > distributes them across a network. [quoted text clipped - 7 lines] > > Thanks in advance SignatureJeff C Live Well .. Be Happy In All You Do > Can you leave a blank workbook template with a macro on the network and > start with that? Instead of creating it, copy it. In this case I am not able to do that, I was hoping that there was a way to leave a function/macro some way in the particular system where the process was running so that every new workbook created by that system would include the macro. > >I have a function that creates new custom workbooks for each client and > > distributes them across a network. [quoted text clipped - 7 lines] > > > > Thanks in advance |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.