Re: Excel programming -- Thank you very much!

Hi Tom,
Thank you very much for your help. I'll try to use the
macro recorder.
Thanks,
jenny
>-----Original Message-----
>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.ht
ml#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: Macro fails in Pie Chart - Can Microsoft / MVP please comment
    ... I just checked this on the latest SP of Excel 2003, ... I cannot speak for Microsoft, but this is the kind of thing that I ... The macro recorder produces code which at best is inefficient, ...
    (microsoft.public.excel.charting)
  • Re: Setting line width in chart
    ... It _is_ possible to change the border widths via points in Excel 2007. ... Someone wanted a macro written and they found the xlThin style too thin and the xlMedium style too thick. ... It's a little hard to discover this since if you do it through the GUI, the macro recorder does not record the command. ... Jon Peltier, Microsoft Excel MVP ...
    (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)
  • Re: How to do an Access Database Query in Excel
    ... Thanks once again Jamie, not much knowledge of Access and I can find my way ... around Excel code. ... StoreNo, SalesDate, Item, MenuLookupName, Sold and these are all taken from ... > Just like the macro recorder writes awful code, ...
    (microsoft.public.excel.programming)