By "writes macros that simply will not work" do you mean they don't
work as recorded (and pasted into Rb) or that they don't work after
being 'translated' into Rb? I suspect the former.
The command you include: Excel.ActiveSheet.Shapes("Chart
1").IncrementTop 90.0
should work provided you establish a valid connection to an Excel
instance. So,
dim oleExcel as OLEObject
oleExcel = new ExcelApplication
oleExcel.ActiveSheet.Shapes("Chart 1").IncrementTop 90.0
Should work.
What all the "use the VBA documentation" references mean, is that
after you have a valid object all the commands come straight out of
VBA, so you should be able to use the Object Browser to determine the
other objects and commands you need/want.
On Jun 30, 2005, at 13:13, Ruth Watkins wrote:
I am searching for documentation or examples of how to change the
ChartType (-4101) to other chart types. I would also like to find
documentation for commands similar to Excel.ActiveSheet.Shapes
("Chart 1").IncrementTop 90.0
in order to move the graph left or right on the page. And, I would
like to find documentation or examples to change chart title,
series, legend, and category values.
The reference manual says to use the help for VBA in EXCEL, but my
EXCEL in Office 10 on XP writes macros that simply will not work in
RB. All the examples I have found are written for Visual Basic, and
I don't know the proper syntax to make them work in RB. There must
be RB documentation or examples somewhere that can help me learn
how to do this.
--
David Glass - Gray Matter Computing
graymattercomputing.com - corepos.com
559-303-4915
Apple Certified Help Desk Specialist
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
|