Exchanging Data

Last update:
June 25, 1997

How do I bring a Microsoft Word text to Pragma 5?

1. Save the MS Word text as a text file (.TXT) and in Pragma 5 make a small verb that reads the file into a noun (use the verbs DOS OPEN READ, DOS READ and DOS CLOSE READ).
   
2. Highlight the text you need in MS Word and then copy it to the clipboard. In Pragma 5, make a small verb that reads the contents of the clipboard into a noun (use the verb PASTE FROM CLIPBOARD).

I want to export a lot of data into an Excel spreadsheet. How do I do it?

1. Create a form with a grid. Fill the grid with your data in the same way you want Excel to display the data.
2. In an event (Pushbutton pushed?) run the verb GRID SELECT CELLS to select all the cells you want to copy. Then immediately run the verb GRID COPY SELECTION CLIPBOARD and the verb GRID ENABLE MULTIPLE SELECTION (FALSE). Your data will be in the Windows clipboard.
3. Paste the contents of the Windows clipboard into Excel.

lip_faq.gif
faq_5.htm