Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel file is selected
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01136176
Message ID:
01136201
Vues:
15
I'm getting "Unable to set the LineStyle property of the Border class" error.

What is wrong in this code?
** Now apply borders to each header cell
	lcRange = "A" + alltrim(str(m.lnLines + 2)) + ":" + ;
		m.lcEnd + alltrim(str(m.lnLines + 2))

	with loSheet.range(m.lcRange)
		with .borders(xlEdgeLeft)
			.LineStyle = xlContinuous
			.Weight = xlThin
			.ColorIndex = xlAutomatic
		endwith
		with .borders(xlEdgeTop)
			.LineStyle = xlContinuous
			.Weight = xlThin
			.ColorIndex = xlAutomatic
		endwith
		with .borders(xlEdgeBottom)
			.LineStyle = xlContinuous
			.Weight = xlThin
			.ColorIndex = xlAutomatic
		endwith
		with .borders(xlEdgeRight)
			.LineStyle = xlContinuous
			.Weight = xlThin
			.ColorIndex = xlAutomatic
		endwith
		with .borders(xlInsideVertical)
			.LineStyle = xlContinuous
			.Weight = xlThin
			.ColorIndex = xlAutomatic
		endwith
		with .borders(xlInsideHorizontal)
			.LineStyle = xlContinuous
			.Weight = xlThin
			.ColorIndex = xlAutomatic
		endwith
	endwith
>Naomi,
>
>Not only those; there are also Diagonals....
>However, some settings are defaults, and then you may omit to code them
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform