I'm having trouble opening the Common Dialog Box in Excel VBA. It works fine in Access, and I have all the same references [including Microsoft Common Dialog Control 6.0 (SP-3)] and the same code [CommonDialog.ShowOpen, etc.]. CommonDialog appears in the Object Browser. When I type the code it comes up with the proper caps as though it's all recognized. But when I try to run the code, I get the error "Object required." Any ideas? I'm also getting an error when I use EOF on a file object, even though I can read the file just fine. The error is "Object doesn't support this property or method." I hate it when VBA plays these games with me... -Tim
[Non-text portions of this message have been removed]
