Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Picture in excel 2007
Message
From
24/05/2011 07:39:53
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Picture in excel 2007
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01511559
Message ID:
01511559
Views:
97
this is my code

tmpsheet=Getobject('','excel.sheet')
xlapp=tmpsheet.Application
xlapp.Visible=.T.
xlapp.workbooks.Open(Fullpath(filename_))
bcsheet=xlapp.activesheet

** some code **

Lpicture=('\büro\bmp\'+alltrim(model)+'.jpg')

bcsheet.Range(A5).Select

bcsheet.PictureS.Insert(Lpicture).Select


*******************************

my problems are

1, the picture gets inserted but not at A5,
2, how do i resize the picture

thanks
Next
Reply
Map
View

Click here to load this message in the networking platform