getting macro installed in each new workbook

J

Jeff C

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
 
J

Jeff C

--
Jeff C
Live Well .. Be Happy In All You Do


Norman Jones said:
Hi Jeff.

See Chip Pearson at:

Programming The VBA Editor
http://www.cpearson.com/excel/vbe.aspx
Click to expand...

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.
 
N

Norman Jones

Hi Jeff,


============
See Chip Pearson at:

Programming The VBA Editor
http://www.cpearson.com/excel/vbe.aspx
Click to expand...

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
 
T

Tim Zych

Can you leave a blank workbook template with a macro on the network and
start with that? Instead of creating it, copy it.
 
J

Jeff C

--
Jeff C
Live Well .. Be Happy In All You Do


Tim Zych said:
Can you leave a blank workbook template with a macro on the network and
start with that? Instead of creating it, copy it.
Click to expand...

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Save As and new workbook new name used in existing code 8
Opening a list of Excel files and run a macro in each 17
Copy cell value from one worksheet to matching worksheet in another workbook 4
Copy Worksheets To New Workbook 2
run macro in another workbook - error 1004 7
Save each sheet of multi-sheet workbook as a single-sheet workbook 3
VBA code for pasting links -- modifying RDB code for summary workbook 10
Macro to open file and copy information from worksheet 1

Top