Boston WorkStation's integrated development environment automatically generates a menu of scripts to run, and if you set the WorkStation to its Runtime mode a lot of the development clutter disappears making this something you might consider giving to users to select a script. That's one solution to Mike's problem.
VBA Userforms are another alternative...just add the buttons to the form, re-label them for each script you wish to run and add a command in the Click event for each button that will start each script. Simple and elegant. Rich McNeil Boston Software Systems 866 653 5105 www.bostonworkstation.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bill Palmer Sent: Wednesday, January 26, 2005 10:44 AM To: [email protected]; [EMAIL PROTECTED] Subject: Re: [Talk] VBA Control Arrays I am using BWS 7 also. I use vb.net for development. I don't know if script.vb is used with the vba that is included with BWS as I have always used vb6 or vb.net for development. What about it Rich or Sarah or Thom? Bill Palmer Financial Coordinator, Information Sys Mid-Columbia Medical Center The Dalles, OR 97058 541-296-7417 >>> "KEYS,MIKE" <[EMAIL PROTECTED]> 01/25/05 09:43AM >>> I see where this is tied together in a Bss6.vbp, but I am using BWS 7. Is there something for this version? Mike Keys Interface Engineer/Unix System Admin Decatur Memorial Hospital 2300 N. Edward St. Decatur, IL 62526 Phone: 1-217-876-4575 Fax: 1-217-876-2084 email: [EMAIL PROTECTED] >>> "Bill Palmer" <[EMAIL PROTECTED]> 01/25/2005 11:24:44 AM >>> If you edit the Script.vb file like so: Sub Scripts() If DoScript("Process REG Payroll") Then Main("REG") If DoScript("Process MTH Payroll") Then Main("MTH") End Sub Then the menu of the default form will have the options you specify. Then in your Main routine create the case statement to select which routines will run. Bill Palmer Financial Coordinator, Information Sys Mid-Columbia Medical Center The Dalles, OR 97058 541-296-7417 >>> [EMAIL PROTECTED] 01/25/05 09:03AM >>> Looking for some code to use with form. I want to throw some OptionButton's on a form and then use a 'Select Case' statement to see which control was selected and run the appropriate script. VB has ability to create a control array, VBA does not. Does anyone have a workaround? Mike Keys Interface Engineer/Unix System Admin Decatur Memorial Hospital 2300 N. Edward St. Decatur, IL 62526 Phone: 1-217-876-4575 Fax: 1-217-876-2084 email: [EMAIL PROTECTED]
