Has anyone experienced the joy of opening .xls file that worked fine in 2000, in Excel 2007, only to find they have a modal, seemingly unavoidable, unprogrammable dialog box block?
This is somehat of a reet PITA if you are automating opening a few thousand files looking for something and closing. And each one throws up this message, on open, but before the on open event, which doesn’t seem to accept sendkeys (or at least how could you program them?). And appears with no warning, and doesn’t seem to be a testable state (eg ready mode, edit mode, point mode, blocking the user for fun mode).
Anyone else seen this?
Anyone got a fix or workaround? (to allow the automation to continue, and to open the file, and close without saving changes)
I’m pretty sure I saw this years ago too, possibly with a 97 to 2003 move? I think in this current case the files were previously edited in 2000. I’d like to imagine that if I found a workaround last time around, a. I’d remember, and b. I’d know which dusty laptop to fire up and search. But I don’t, Have you got any ideas?