Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Paste in Excel sheet
Message
From
06/04/2007 10:06:24
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Other
Title:
Paste in Excel sheet
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01212959
Message ID:
01212959
Views:
58
#define true .t.
#define false .f.
#define msotextorientationhorizontal 1

local oexcel as excel.application
oexcel = createobject([Excel.Application])
oexcel.workbooks.add()

with oexcel
for each losheet in .activeworkbook.sheets
losheet.activate
losheet.range('A1').select
losheet.range("A2").value ="Boris"
losheet.shapes.addtextbox(msotextorientationhorizontal, 100, 100, 103.5, 15).select
&& Here in this textbox1, I want to add value of "A2" i.e. Boris
endfor
endwith
oexcel.visible=.t.

Please help
Next
Reply
Map
View

Click here to load this message in the networking platform