| .NET DotNet Forum Index » VB.NET Forum (Visual Basic .NET) » convert Excel into vb... |
|
Page 1 of 1 |
|
| Author |
Message |
| cmdolcet69... |
 Posted: Sun Nov 01, 2009 3:35 pm |
|
|
|
Guest
|
How can I convert this code into vb code?
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.Axes(xlCategory).Select
With Selection.Border
.Weight = xlHairline
.LineStyle = xlAutomatic
End With
With Selection
.MajorTickMark = xlOutside
.MinorTickMark = xlNone
.TickLabelPosition = xlLow
End With |
|
|
| Back to top |
|
|
|
| DIOS... |
| Posted: Sun Nov 01, 2009 4:27 pm |
|
|
|
Guest
|
On Nov 1, 7:35 pm, cmdolcet69 <colin_dolce... at (no spam) hotmail.com> wrote:
Quote: How can I convert this code into vb code?
ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.Axes(xlCategory).Select
With Selection.Border
.Weight = xlHairline
.LineStyle = xlAutomatic
End With
With Selection
.MajorTickMark = xlOutside
.MinorTickMark = xlNone
.TickLabelPosition = xlLow
End With
that is VB6 code just call the correct Excel objects to initialize. Go
to www.planet-source-code.com and look up Excel. besides this
newsgroup is for .NET, not classic vb.
AGP |
|
|
| Back to top |
|
|
|
|
