When you install Wine, it should create a configuration directory under your home directory, probably called .wine. The wine config file, along with fake ASCII Windows registry files, are saved in there. The one called
config is the Wine config.
If you open it up in your favorite editor, there should be a group of lines at the top that define the disk drives you want Wine to use. (I forget exactly what it looks like, but it's pretty recognizable). Point the
D: drive to your CDRom, such as /mnt/cdrom, in order to get the CDrom to work under Wine. (I think you also need to edit the device name to point in the correct place, i.e. /dev/hdb or whatever it is)
As for the DLL error... if I remember correctly, Wine looks in its fake-windows (or real-windows, if you are running it from a real Windows partition) /windows/system directory for any DLLs. If they aren't there, it checks in a few other places, such as your home directory, and the current directory that you're running Wine from. If you can find the DLL in question and copy it to one of those places, it may fix that problem.
Be aware that MS Office 97 is not too likely to work in Wine, especially such an old version. You can get a newer version from the
Wine Homepage. You may want to look into
Crossover Office (commercial program, about $50) if you really need to run Office, or
OpenOffice if you want a native Linux office suite that is at least as good as MS Office (and is interoperable with MS Office, for the most part).