| |
| |
|
softwarecatch.com
|
|
|
|
Corel WordPerfect 7 Macro Programming Example
Case study: She does this by entering calculations into either a real calculator and transcribing the answer, or the Microsoft calculator and copying then pasting the result into the document. Doing this affects her productivity as this process increases the time taken to complete work and wastes time in correcting inevitable errors that occur. Proposal: Feasibility study: User Requirements: The user requires the ability to select the following options for formatting the output:
1) Displaying a sum in standard numbers or currency. Specification: Purposes of using macro: Calculate the sum of any numerical data specified by the user. Data to be embedded in macro: Any numerical data entered by the user. Use of macro: Accelerate processing of data therefore increasing productivity, by cutting out the additional keystrokes needed to run the calculation manually. Solution: Design of the system Typical configurations required: Method of input: Method of output: To VDU at the point of input data. Using this specification I have written an algorithm that makes effective use of the resources available in Corel WordPerfect 7. Algorithm for applications software macro: The solution to the algorithm stated above in the form of a macro that meets all the requirements identified in the analysis is as follows: Macro script: If (?DocBlank) Condition executed if document blank // Go to subroutine oninput go(oninput) endif // Select data block left of insertion point Selectwordprevious () // Condition executed if no data found If (?SelectedText="") // Go to subroutine error go(error) endif // Convert selected data block to a table Tableconvertfrom (type: tabularcolumns!) // Set default table style TableCellNumberFormat (FormatType: General!) // Turn off Update associated charts option Tableupdateassociatedcharts (state: off!) // Insert an equal sign left of data block Type (text: "=") Tablecalculate () // Calculate formula values in the table // If formula syntax is invalid go to else If(?CellFormula) // Display menu dialog box DialogShow(5001;"WordPerfect") // Condition executed if user presses cancel If(MacroDialogResult = 2) // Revert the last operations Undo(1) // Move insertion point to end of data bock PosWordNext () // Go to subroutine end Go(end) Endif // Condition executed if currency is defined If(currency) // Specify format data as currency [Ł00.00] TableCellNumberFormat (FormatType: Currency!) TableCellNumberNegativeNumber (NegDisplayType: Minus!) Endif // Condition executed if negatives defined If(negatives) // Specify negative format [(9)] Tablecellnumbernegativenumber (negdisplaytype: parentheses!) Endif // Specify commas are not used TableCellNumberUseCommas (State: No!) // Condition executed if commas defined If(commas) // Specify format data using commas [2,000] TableCellNumberUseCommas (State: Yes!) Endif // Select the table. Tableselecton (selectionmode: table!) // Select all cells in the current table Selecttable () // Delete table convert contents to document Tabledeletetable (delwhat: converttotabs!) // Move insertion point to end of data bock PosWordNext () // Go to subroutine end Go(end) // If formula syntax is invalid then Else endif // Identify the subroutine error Label(error) // Display error message box in event of invalid formula MessageBox (; "AUTOMATH UNABLE TO COMPLY"; "Invalid data exists in formula. Sequence terminated."; IconStop!) // Delete table convert contents to document Tabledeletetable (delwhat: converttotabs!) // Delete character right of the insertion point DeleteCharNext () // Go to subroutine end Go(end) // Identify subroutine oninput. Label(oninput) // Display error message box in event of blank document MessageBox (; "AUTOMATH UNABLE TO COMPLY"; "No input provided! Sequence terminated."; IconStop!) // Identify the subroutine end Label (end) // End macro Quit //==================================================== Implementation: The following tests were performed to confirm that the macro meets all of the requirements under real conditions. Tests to be applied: Test # one of basic macro: 1) Find an individual that knows nothing about this macro. 2) Observation of this individual doing the following: [a] Easily using the instructions. [b] Load Corel WordPerfect 7. [c] Enter valid numerical data. [d] Access the macro file. [e] Run the macro. [f] Repeat steps [c] to [e] using all possible combinations of the options. Ideally, the individual should be able to do the above with no assistance. 3) Observation of the macro running as intended in all conditions. Basic test conditions: Valid Input: Output: Invalid Input: output: [a] 5-5 0 [a][nothing] Error [b] 2+2 4 [b] qwerty Error [c] 2-4 -2 [c] 2gh+32 Error [d] 100*200 20000 [d] !"Ł$% Error [e] 50/1 50 [e] 1+4-1$ Error [f] 1+2-3*4/5 0.6 [f] one*two Error [g] 12345 Ł12,345.00 [g] a1-d3 Error (??) Test # two of debugged version: 1) Release the software on the LINK bulletin board system (run by Legalease) for evaluation by it's users. (the LINK is a special network for lawyers who often need maths functions in written work). 2) Collect commentary from the people willing to help. 3) Investigate and implement any changes or revisions necessary. Maintenance: I am the website administrator of the Wandle industrial museum (http://www.wandle.org). Established in 1983 by local people to ensure that the history of the valley was no longer neglected but enhanced awareness its heritage for the use and benefits of the community.
MORE RESOURCES:
Google News |
|
|
|
RELATED ARTICLES
Microsoft Great Plains customization - Freight Forwarding/Transportation industry example Microsoft Business Solutions Great Plains version 8.5, 8. Microsoft CRM Implementation - US Market Lessons Microsoft CRM is CRM answer from Microsoft Business Solutions. If you compare it to other traditional CRM applications, such as Siebel - you will see that Microsoft CRM does use all the resent Microsoft technologies, that means that Microsoft targets its CRM to Windows market exclusively, plus this means that Microsoft CRM is more difficult in its installation. What is Fleet Maintenance Management? Fleet Maintenance Management is a critical position in any company that has a number of commercial vehicles. The individual responsible for the management and maintenance of fleet vehicles performs a variety of functions. How to Tell You Have Spyware, Ad-ware or Viruses Usually, the easiest way to tell you have spyware is because your PC is running at a reduced speed. The other way to check is to hit CTRL+ALT+DELETE and hit task manager (if you have windows service pack 2. netstat - Linux Command to Display Networking Information In linux, one of great commands for finding out information about your network connections is "netstat". It provides you interface information, statistics, connections, and a lot of other really great information about your computer. Bridging the Gap between Paper and Data The cornerstone of successful automated office systems is the ability to convert printed information into electronic data. Document processing applications need to capture and index data accurately and efficiently to bridge that gap. Collaboration Software: Index of Collaboration Software Technologies Collaboration SoftwareCollaboration Software, also known as group collaboration software or groupware, is software which allows cooperation on a business document between multiple parties on multiple computers. Collaboration software also allows the integration and merging of document changes and versions on a business document. Story Development Software: Good or Evil? In the early days of the personal computer, we're talking the mid-'80s here, there was speculation that someday books would all be writen by computers. It sounded a little too science-fictiony for most writers. Groupware and Version History: Collaboration Series #1 This article is the first of a series of articles exploring specific aspects of groupware. The brief informational articles in this series discuss some of the technologies associated with groupware, as well as some of the characteristics of groupware. Microsoft Great Plains Distribution, Barcoding, Consignment - overview for consultant Microsoft Great Plains - ERM from Microsoft Business Solutions and formerly Great Plains Software is pretty generic with its standard set of modules: GL, BR, AR, AP, IV, SOP, POP and US Payroll. However, having about twelve years of implementation and customization history - Great Plains Dynamics, Dynamics C/S+, eEnterprise being Great Plains Dexterity written application has been and still is attractive core platform for third party software development companies to write vertical and horizontal modules, written as well in Great Plains Dexterity. Lotus Domino: Reports and Connectors - Crystal Reports, XML, ODBC/JDBC, OLE Lotus Notes Domino is very efficient in electronic document workflow automation. Unfortunately the electronic document workflow can not replace paper documents completely. Does Microsoft have any real competition? Does Microsoft Have any Real Competition? Copyright (c) 2003 Gregory S. Diehl In a word, yes. C++ Function Templates C++ Function templates are those functions which can handle different data types without separate code for each of them. For a similar operation on several kinds of data types, a programmer need not write different versions by overloading a function. Adware, What Is It? Adware is a type of Spyware program that displays some kind of banner advertising as you're surfing the Internet. Most of the time, you will pick these programs up if you download other programs such as freeware, shareware, and file-sharing programs. Microsoft Great Plains - Typical Problems And Fixes - Overview For IT Administrators How to delete the user? This is the first problem you encounter - when user shuts down the computer - Great Plains doesn't have the command to log off the user and when user tries to login the next day - she gets error message that user is already logged on. The fix: Microsoft SQL Server - open SQL Query Analyzer, switch to DYNAMICS database and run the following script: DELETE ACTIVITY WHERE USERID='KATHY'. Dreamweaver vs FrontPage There are two major WYSIWYG(What You See Is What You Get) editors available for beginners. These are: Microsoft FrontPage and Macromedia Dreamweaver. What You Should Know About Installing Screensavers Do you remember that frustrating feeling when you find an interesting screensaver and can't install it on your computer? This article will help you to never have it again.Back to when Windows 95 started to find its home on many computers there was just half a dozen of screensavers preinstalled with the system. Scrap Booking Online: Word Perfect or Corel Graphics Suite? Scrapbooks are very popular these days. I think that almost everyone wanted to capture family histories and stories in any which way they can. Internet Faxing Service Review The Internet is reshaping every form of communications medium, and faxing is no exception. The latest twist: Internet faxing services that let you send messages to any fax machine from any Web browser or email, and others that give you a "personal fax phone number," then forward any documents sent there to your e-mail inbox. Spyware Definitions List The adware and spyware definitions list is very long. But the definitions listed below are the most common ones.
|
|
Powered By: Free Work At Home Business Opportunity! |
| © 2006 |
