View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default Embedding VBA in New Workbook

http://www.cpearson.com/excel/vbe.htm
Chip Pearson's page on working with code using code.
--
Regards,
Tom Ogilvy

"Patrick" wrote in message
...
Yes, I held that option as a fall-back plan. I was hoping to learn a new
trick today :) ...always looking to increase my skill set. Thanks for

the
reply, Bernie!

"Bernie Deitrick" wrote:

Patrick,

Use a template file for the "seperate workbook" that you open, modify by
adding data, and then save as under an apprpriate name. The file should
have all the code, buttons, etc., and will greatly simplify the task.

HTH,
Bernie
MS Excel MVP