A
Andrew
Hello,
For the past two years, I've been using a purchase order generator
which I made in Excel VBA. The main file is a template with two
sheets. Sheet 1 is the purchase order, and sheet 2 is a list of all
my contacts. Sheet 1 has two buttons, one to update my contact list
and one to create a PO and save it to a specified folder... So, when I
hit the button to update the contacts, I get a dialog box which asks
for name, address, etc. On that dialog box there is another button
which is supposed to update the contact list and then save the entire
file as the new template. So, of course the new template will have
all of the VBA code. This system worked well for 2 years is Excel
2003. Last week I updated to Excel 2007 and when I updated my contact
page, the resulting template was saved but all of the VBA code was
gone. So, essentially the template is destroyed. I tried this again
with another copy of the file and the same thing happened.
Can someone explain to me why Excel 2007 is erasing my VBA code? And
what can I do to prevent this?
thanks
For the past two years, I've been using a purchase order generator
which I made in Excel VBA. The main file is a template with two
sheets. Sheet 1 is the purchase order, and sheet 2 is a list of all
my contacts. Sheet 1 has two buttons, one to update my contact list
and one to create a PO and save it to a specified folder... So, when I
hit the button to update the contacts, I get a dialog box which asks
for name, address, etc. On that dialog box there is another button
which is supposed to update the contact list and then save the entire
file as the new template. So, of course the new template will have
all of the VBA code. This system worked well for 2 years is Excel
2003. Last week I updated to Excel 2007 and when I updated my contact
page, the resulting template was saved but all of the VBA code was
gone. So, essentially the template is destroyed. I tried this again
with another copy of the file and the same thing happened.
Can someone explain to me why Excel 2007 is erasing my VBA code? And
what can I do to prevent this?
thanks