Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Programmatic transfer of graphic from Xcel to VFP table.
Message
From
05/07/2000 03:10:30
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Programmatic transfer of graphic from Xcel to VFP table.
Miscellaneous
Thread ID:
00388237
Message ID:
00388237
Views:
65
I have an excel workbook that has a few graphic objects linked to cells.

I can manually grab these objects with cut'n paste special and place them into general fields without trouble. The dialog allows me to copy the graphics as metafiles - which VFP seems to deal with in some native way (rather than associating them with the original app that created them). The manual method works well, and I'm able to create forms and reports that display the graphics as desired.

Now I need to be able to do this programmatically.

Using the VB editor help files, I've gleaned enough knowledge about excel objects to be able to find the Worksheet.OLEOBJECTs that I'm interested in, but I'm still not sure how to copy them to general fields, since the APPEND GENERAL doesn't seem rich enough to specify objects as the source of the append.

And I cannot figure out how to programmatically copy the object as a picture metafile - which seems like a good way to store it.

Help!
"The Iron Fish: The water is cold...but the fish don't mind"
...Jay Jenks, boyhood chum
Next
Reply
Map
View

Click here to load this message in the networking platform