Hello
If I understand your question correctly, you want to format the excel gridlines so that when you print the excel sheet, you can see the individual cells.
You can do that by first selecting the area of interest by using
Excel_WorksheetRange. After selecting the area , you would get the handle of the boders collection by using
Excel_BordersItem and then set the property of the linestyle and weight of the line accordingly.
The VB help for the borders collection should describe the properties of the object. Here is a link to the help.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/off2000/html/xlobjBorders.asp
I hope this helps
Bilal Durrani
NI
Bilal Durrani
NI
