Mark Simms
marksimms at verizon.net
Sun Jan 1 12:34:53 CST 2012
Interestingly Charlotte I had to use the VBE.VBPROJECT object in Excel to set references. Excel 2010's VBE is exhibiting the same p-code corruption behavior as Access 2010. So I had to create my own "eatbloat"....export all of the modules and forms, delete em, recompile, close, open again, import all of the VBA source, re-establish 12 references, recompile. > To make it work in a 2002/2003 version, you had to reference the VBE > library and use its methods because you can't use DAO or ADO and VBA to...