After issuing the above command (with a table already open), I can open Excel and ^V the data with each column placed appropriately. Notice the use of blanks/commas in place of the ommited first and second parameters. In the SamplesSolutions application that comes with Visual FoxPro, there is a good example of the use of the Microsoft Rich Text Format (RTF) ActiveX control. Put body composition device next to computer you will be using. This example puts all records in the currently selected alias onto the Windows clipboard: Before appt., get clipboard ready with PT Assessment sheet (fill out top right. Use the nFormat of 3 to separate fields by tabs this seems to work the best when pasting into Excel. _VFP.DataToClip(cAlias or nArea, nNumofRecs, nFormat)Īll of these are optional the default is the current work area/alias, all of the records, and fields separated by spaces. ![]() Having started this thread with a narrow view due to lack of knowledge, your contributions have given me other VFP Commands etc to pursue which will help me expand my knowledge base. This program (VFP.exe) was initially aimed at immunoassay data which exhibit. ![]() copying to/retrieving from clipboard, capturing of screen or any window. You probably already know that you can assign a text string to _CLIPTEXT to place text onto (or read text from) the Windows clipboard.īut what if you wanted to put record data, especially for more than one record? For example, you want to put some summary data that you compiled using SELECT.GROUP BY onto the Windows clipboard so that the user could paste it onto a spreadsheet or word processing program.ĭataToClip to the rescue! This is a method of the VFP application object, so we'll need to prepend the _VFP object reference to any calls to it. Although I've chosen Atlopes option for my application, I do appreciate your contributions. Visual FoxPro class to access Gdi+, for earlier versions starting from VFP6.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |