Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Border and line with excel
Message
From
21/10/2011 08:47:03
 
General information
Forum:
Visual FoxPro
Category:
Other
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01526984
Message ID:
01527038
Views:
49
Thank you Mark
No your code work but it gives me only one line it under A1 I have try to look at how I can apply up to certain range but I could not
but there was no error while I was trying to cover horizontally and vertically the range A1:J1
Thank you

local loExcel, oSheet
loExcel = CREATEOBJECT("Excel.Application") && Create the Excel object
opexcel = FULLPATH("inkorder.xls")
loWorkbook = loExcel.workbooks.open("&opexcel") && parameters to open the file from the right directory
loExcel.Visible = .T. && display Excel


xlEdgebottom = 9
xlContinuous = 1
xlThin = 2
xlDiagonaldown=0
xlDiagonalUp=0
xledgeleft=0
xlEdgetop=0
xledgeright=0
xlInsideVeertical=0
xlIsideHorizontal=0
With loExcel.Selection.Borders(xlEdgeBottom)
.LineStyle = xlContinuous
.ColorIndex = 0
.TintAndShade = 0
.Weight = xlThin
EndWith
Previous
Reply
Map
View

Click here to load this message in the networking platform