Posted on 1998-08-30
Private Sub Form_Activate()
openexcel = Shell("c:\Program Files\Microsoft Office\Office\excel c:\my documents\the worksheet.XLS", 1)
This command will not work because long filenames and spaces between the folder "my documents" and "The worksheet.xls" I know that if I type in the dos name "Mydocu~1" it will work, but I need to have this set to a variable, instead of hard code. Is there a function that will convert these so the computer will know how to open?