I'm porting my monster app from 97 to 2000-- the one with the 35+
worksheets, each w/ an embedded word doc.
When I run the 97 version in 2000 and save changes, and then try to open it
in 97, I get a run-time error right off the bat. Excel 2000 has reset the
Word 8 library reference to Word 9. I can uncheck the reference in 97,
close the dialog box, and then open it again and re-select Word 8 -- and
then things are fine! But there's no way in &*% that my users are going to
be able to do this! I'd like to do it programmatically when the workbook
I tried the macro recorder, and only got blanks. Any ideas??