View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Barb Reinhardt Barb Reinhardt is offline
external usenet poster
 
Posts: 3,355
Default Auto insert a vb module to a new workbook -riv

You may be able to find something here

http://www.cpearson.com/excel/vbe.aspx

--
HTH,
Barb Reinhardt



"Rivers" wrote:

Hi all me again lol

im looking everywhere for this but cant find it anywhere so was wondering if
it was possible.

i have a workbook that gets used every week when im done filling in
information i have a macro that copies the first three worksheets puts them
into a new workbook then attaches the new workbook onto an email this is fine
it works perfectly.

however im trying to create an auto open for the new workbook i tried
installing the auto open on the worksheet itself but this does not work was
wondering if i could auto install a module from the folder location and then
save the workbook.

is this possible?

rivers