Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
getting 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 -- Jeff C Live Well .. Be Happy In All You Do |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
getting macro installed in each new workbook
Hi Jeff.
See Chip Pearson at: Programming The VBA Editor http://www.cpearson.com/excel/vbe.aspx --- Regards. Norman "Jeff C" wrote in message ... 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 -- Jeff C Live Well .. Be Happy In All You Do |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
getting macro installed in each new workbook
-- Jeff C Live Well .. Be Happy In All You Do "Norman Jones" wrote: 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. Norman "Jeff C" wrote in message ... 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 -- Jeff C Live Well .. Be Happy In All You Do |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
getting macro installed in each new workbook
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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
getting macro installed in each new workbook
Can you leave a blank workbook template with a macro on the network and
start with that? Instead of creating it, copy it. -- Tim Zych www.higherdata.com Compare data in workbooks and find differences with Workbook Compare A free, powerful, flexible Excel utility "Jeff C" wrote in message ... 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 -- Jeff C Live Well .. Be Happy In All You Do |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
getting macro installed in each new workbook
-- Jeff C Live Well .. Be Happy In All You Do "Tim Zych" wrote: 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. -- Tim Zych www.higherdata.com Compare data in workbooks and find differences with Workbook Compare A free, powerful, flexible Excel utility "Jeff C" wrote in message ... 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 -- Jeff C Live Well .. Be Happy In All You Do |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Installed Vista, now I can't find how to send workbook via email | Excel Discussion (Misc queries) | |||
Missing Excel Workbook Template - with VSTO SE installed | Excel Programming | |||
Macro Speed and Virus Scanner Installed. | Excel Programming | |||
Running a macro to protect a workbook on a already protected workbook UNprotects the workbook ?? | Excel Programming | |||
Macro crashes if printer not installed | Excel Programming |