>>My form opens the Excel spreadsheet, changes the data and saves it. If I could save it as a gif or jpg or something, I could use a Picture/ActiveX bound control but I don't see how I can do that. Maybe I'm just a neophyte with Excel! Ideally I want to save a range of the spreadsheet as a picture or something to stick on the report (without using any other software).
>>
>>I had another idea of using a General field to link to the spreadsheet but...
>>1. How can I create a General field in a cursor?
>>2. I think this would link or embed the whole spreadsheet and I only want to stick some of it in the report.
>>
>>The plot thickens! Thanks for the help and anything else you can come up with!
>>
>>Sally
>
>Add an OLE/ActiveX control to the report and set it up as a FIELD pointing to MyCursor.MyGen. Then use the following code to create the cursor, add in the spreadsheet and print the report.
>
>

>CREATE CURSOR MyCursor (mygen g)
>APPEND BLANK
>APPEND GENERAL mygen FROM c:\tmp\book1.xls link
>REPORT FORM junk PREVIEW
>

>
>Cathy

Cathy,

Do you know of a way to create a general field in a select stmt when no general field exists in the data? I've done this with character and numerics but not generals.

Also, using append general as above will work but presents the entire spreadsheet. Any way to specify the cells to include in the general field? I suppose I can make the size of the general field on the report match the size of only the portion of the spreadsheet that I want to print (since the printable part starts at the top) but what if I wanted to only print the middle of the spreadsheet? Possible?

Thanks for all your help!

Sally