B
BAC
Office 2007
I have an Excel Workbook that reads from an ODBC database and completes 5
worksheets within the workbook based on the data returned and saves the
completed workbook under a new file name (original remains in tact)
Users then add/modify data based on their needs.
For a while we had users 'reusing' forms that created problems when they
forgot to change some data item that related to the earlier form, so our
solution was to remove the event handler code for the data retrieval. This
worked fine in Office 2003, but now, in 2007 changing the code destroys the
digital signature.
I've been advised that I may be able to programmatically "re-sign" the file
after deleteing the event handler, but I have not been able to find any info
about that in the KB or anywhere else.
Is that possible? And, if so, Anyone know where I can find sample code to do
it?
tia
BAC
I have an Excel Workbook that reads from an ODBC database and completes 5
worksheets within the workbook based on the data returned and saves the
completed workbook under a new file name (original remains in tact)
Users then add/modify data based on their needs.
For a while we had users 'reusing' forms that created problems when they
forgot to change some data item that related to the earlier form, so our
solution was to remove the event handler code for the data retrieval. This
worked fine in Office 2003, but now, in 2007 changing the code destroys the
digital signature.
I've been advised that I may be able to programmatically "re-sign" the file
after deleteing the event handler, but I have not been able to find any info
about that in the KB or anywhere else.
Is that possible? And, if so, Anyone know where I can find sample code to do
it?
tia
BAC