| It's not Tiger...
...Panther's "Archive & Install" did the same. The missing file is Library>Scripting Additions>Adobe Unit Types. Without this, double clicking a Photoshop file launches the app. but does not open the file - as you describe. If you can find this file and put it back, it should work, but reinstalling Photoshop is probably a simpler method.
|