Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
VBA for Excel in VFP Program
Message
From
17/03/2000 13:51:49
Rich Lieblich
Infosys Technologies, Inc.
Fanwood, New Jersey, United States
 
 
To
17/03/2000 13:13:51
General information
Forum:
Visual FoxPro
Category:
ActiveX controls in VFP
Miscellaneous
Thread ID:
00347127
Message ID:
00347200
Views:
26
David,

Perfect. Worked like a charm... thank you! Got another one, since you are obviously an Excel VBA maven <s>.....

Is there a simpler way to display the grid lines than the following???

ExcelObj.Cells.Select
ExcelObj.Selection.Borders(7).LineStyle=1 && Edge Left - continuous line
ExcelObj.Selection.Borders(7).Weight=2 && thin line (thick='4')
ExcelObj.Selection.Borders(8).LineStyle=1 && Edge Top
ExcelObj.Selection.Borders(8).Weight=2
ExcelObj.Selection.Borders(9).LineStyle=1 && Edge Bottom
ExcelObj.Selection.Borders(9).Weight=2
ExcelObj.Selection.Borders(10).LineStyle=1 && Edge Right
ExcelObj.Selection.Borders(10).Weight=2
ExcelObj.Selection.Borders(11).LineStyle=1 && Inside Vertical
ExcelObj.Selection.Borders(11).Weight=2
ExcelObj.Selection.Borders(12).LineStyle=1 && Inside Horizontal
ExcelObj.Selection.Borders(12).Weight=2

This also has the added problem of printing the entire spreadsheet rather than rows that are actually populated!

Thanks.... Rich Lieblich
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform