Re: Excel programming

Excel has a macro recorder. Turn on the macro recorder and build the chart
manually. then turn off the recorder and look at the recorded code. This
will give you some insights into the objects and methods of Excel (which is
the primary knowledge you lack if you have done VBA in Access). Do this
with other actions you might do in excel. Note that the recorded code will
echo what you do manually in terms of recording select and selection. In
most cases, in code you write you would not use select and selection, but
just refer to the object directly without selecting.

John gave you some good book references. If you want sample code, you can
checkout the MS Knowledgebase
http://support.microsoft.com

some examples:

http://support.microsoft.com/default.aspx?scid=kb;en-us;157940&Product=xlw
XL97: How To Create a Dynamic Chart Using Visual Basic

http://support.microsoft.com/default.aspx?scid=kb;en-us;213780&Product=xlw
XL2000: How to Use Visual Basic to Create a Dynamic Chart

http://support.microsoft.com/default.aspx?scid=kb;en-us;146055&Product=xlw
Using Visual Basic to Create a Chart Using a Dynamic Range

and MSDN

http://msdn.microsoft.com

Of course you can also get help right here.

for charting examples see:
John Peltier's site
http://peltiertech.com/Excel/ChartsHowTo/QuickChartVBA.html#VBAcharts

--
Regards,
Tom Ogilvy

"Jenny G." <anonymous@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1ab901c53726$1cc90c30$a601280a@xxxxxxxxxx
> Hi Everyone,
> I've worked with Access programing for a while, but now I
> need to use Excel VBA to automate some data analysis with
> some charts on the report. I am not sure where to start.
> Can anyone suggest what book I should buy to get the
> Excel programing knowledge? Or is there any Excel
> automation examples that I can learn from? Thanks for any
> suggestions?
> Jenny


.

Relevant Pages

  • Re: Macro fails in Pie Chart - Can Microsoft / MVP please comment
    ... I just checked this on the latest SP of Excel 2003, ... The macro recorder produces code which at best is inefficient, ... record the macro but just create the chart ...
    (microsoft.public.excel.charting)
  • Re: Help in making a simle column/line chart in excel using vb6
    ... Here is some recorded code, which creates an embedded column chart, adds ... dim xlApp as Excel.Application ... Jon Peltier, Microsoft Excel MVP ...
    (microsoft.public.excel.charting)
  • Re: Excel programming -- Thank you very much!
    ... >Excel has a macro recorder. ... How To Create a Dynamic Chart Using Visual Basic ...
    (microsoft.public.excel.programming)
  • Re: Modifying an Excel Chart in VB - DOM question
    ... I assume you have access to Excel. ... The type of chart is given by the ChartType property of the Chart class. ... In addition to Excel's tools (macro recorder and object browser), ... > charts are all out of whack, and I need to recreate them. ...
    (microsoft.public.excel.programming)
  • Error trying to set the name of series in a chart.
    ... I have a chart in a worksheet, the chart is a stacked column chart with 6 ... recorder and try to run the recorded code I get the Following error: ... series and the sixth series with no problems but data series 2-5 all ... I am using excel 2000 on windows xp pro. ...
    (microsoft.public.excel.programming)