Another question, Why do I get a 1426 error from Office2000 using the "copy to (cFile) type xl5".
I also get a 1429 error when using "oWkBk=oExcel.workbooks.OPEN(cFile)" (the same cFile)
Office97 works fine.
Chuck
Extreme Programming = Plan -> Design -> Code -> Test