I have a spread sheet that has a command button on it that when clicked
displays a form that contains the contents of a text file.  The text file is
read in to the form on initialization.  I have 70 sheets in the workbook
each of which has the command button, but there is a text file for each
sheet.  I do not want 70 forms that read from 70 text files.  Instead I
would like one form that will look at the current or active sheet then read
the appropriate text file and display the results.

Is this possible?  I have tried several things that just don't seem to work.

   -**** Posted from remarQ, Discussions Start Here(tm) ****-
http://www.*-*-*.com/ 's Discussions & Usenet