Saving code from templates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an application that creates several Excel 2000 spreadsheets using a template. The template has VBA code for several events (BeforeOpen, BeforePrint, etc) The application automatically saves the spreadsheets but they don't have any of the code that is in the template. Is there any way to save this code in the spreadsheets?
 
Retaining the code is the normal behavior unless you are saving the
worksheet in the xl5/xl95 format which does not support the newer style
events.

Try saving in the xl97/xl2000/xl2002/xl2003 format. (xlworkbooknormal)

--
Regards,
Tom Ogilvy


B Bassick said:
I have an application that creates several Excel 2000 spreadsheets using a
Click to expand...
template. The template has VBA code for several events (BeforeOpen,
BeforePrint, etc) The application automatically saves the spreadsheets but
they don't have any of the code that is in the template. Is there any way
to save this code in the spreadsheets?
 
You must log in or register to reply here.

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

problem opening file thru code 2
using xltm as template 2
writing excel data into word document 1
Showing Spreadsheet creation date from a template. 2
display message box in excel(2003) using VBA word(2003) 0
VB code to open other applications from templates 6
Template opens instead of copy 2
open save as from list 1

Back
Top