<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Macro Explanation in Application Development and Automation Discussions</title>
    <link>https://community.sap.com/t5/application-development-and-automation-discussions/macro-explanation/m-p/3586159#M863476</link>
    <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Dear Experts,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Can anyone explain below macro.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;DEFINE get_value.&lt;/P&gt;&lt;P&gt;  call method of excel 'Cells' = cell&lt;/P&gt;&lt;P&gt;    EXPORTING&lt;/P&gt;&lt;P&gt;      #1 = &amp;amp;1 "v_rcount&lt;/P&gt;&lt;P&gt;      #2 = &amp;amp;2. "2&lt;/P&gt;&lt;P&gt;  get property of cell 'Value' = &amp;amp;3. " value from the table .&lt;/P&gt;&lt;P&gt;  if not &amp;amp;3 is initial and  &amp;amp;4  = 'T'. "e_file&lt;/P&gt;&lt;P&gt;    &amp;amp;4 = 'F'.&lt;/P&gt;&lt;P&gt;  endif.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;END-OF-DEFINITION.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I never used Macros, Please explain in detail.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;&lt;P&gt;Cris&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
    <pubDate>Fri, 21 Mar 2008 15:27:09 GMT</pubDate>
    <dc:creator>HariMaradana</dc:creator>
    <dc:date>2008-03-21T15:27:09Z</dc:date>
    <item>
      <title>Macro Explanation</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/macro-explanation/m-p/3586159#M863476</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Dear Experts,&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Can anyone explain below macro.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;DEFINE get_value.&lt;/P&gt;&lt;P&gt;  call method of excel 'Cells' = cell&lt;/P&gt;&lt;P&gt;    EXPORTING&lt;/P&gt;&lt;P&gt;      #1 = &amp;amp;1 "v_rcount&lt;/P&gt;&lt;P&gt;      #2 = &amp;amp;2. "2&lt;/P&gt;&lt;P&gt;  get property of cell 'Value' = &amp;amp;3. " value from the table .&lt;/P&gt;&lt;P&gt;  if not &amp;amp;3 is initial and  &amp;amp;4  = 'T'. "e_file&lt;/P&gt;&lt;P&gt;    &amp;amp;4 = 'F'.&lt;/P&gt;&lt;P&gt;  endif.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;END-OF-DEFINITION.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;I never used Macros, Please explain in detail.&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Thanks&lt;/P&gt;&lt;P&gt;Cris&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 21 Mar 2008 15:27:09 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/macro-explanation/m-p/3586159#M863476</guid>
      <dc:creator>HariMaradana</dc:creator>
      <dc:date>2008-03-21T15:27:09Z</dc:date>
    </item>
    <item>
      <title>Re: Macro Explanation</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/macro-explanation/m-p/3586160#M863477</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Hello Cris&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Macros are used to "abbreviate" coding. The repetitive part of the coding is defined in the macro. Below is and example of filling the itab of excluded functions for an ALV toolbar:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;PRE&gt;&lt;CODE&gt;
DATA: lt_excltab   TYPE ui_functions.

  APPEND cl_gui_alv_grid=&amp;gt;mc_func_loc_info TO lt_excltab.
  APPEND cl_gui_alv_grid=&amp;gt;mc_func_loc_graph TO lt_excltab.
  APPEND cl_gui_alv_grid=&amp;gt;...                          TO lt_excltab.
...
&lt;/CODE&gt;&lt;/PRE&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Use of macro:&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;PRE&gt;&lt;CODE&gt;
DEFINE mac_exclude_function.
  APPEND &amp;amp;1 TO lt_excltab.
END-OF-DEFINITON.


mac_exclude_function: cl_gui_alv_grid=&amp;gt;mc_func_loc_info,
                      cl_gui_alv_grid=&amp;gt;mc_func_loc_graph,
                                  ...
&lt;/CODE&gt;&lt;/PRE&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Regards&lt;/P&gt;&lt;P&gt;  Uwe&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 21 Mar 2008 19:51:44 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/macro-explanation/m-p/3586160#M863477</guid>
      <dc:creator>uwe_schieferstein</dc:creator>
      <dc:date>2008-03-21T19:51:44Z</dc:date>
    </item>
    <item>
      <title>Re: Macro Explanation</title>
      <link>https://community.sap.com/t5/application-development-and-automation-discussions/macro-explanation/m-p/3586161#M863478</link>
      <description>&lt;HTML&gt;&lt;HEAD&gt;&lt;/HEAD&gt;&lt;BODY&gt;&lt;P&gt;Thank you very much....&lt;/P&gt;&lt;P&gt;&lt;/P&gt;&lt;P&gt;Have a  good weekend..&lt;/P&gt;&lt;P&gt;Cris&lt;/P&gt;&lt;/BODY&gt;&lt;/HTML&gt;</description>
      <pubDate>Fri, 21 Mar 2008 22:01:45 GMT</pubDate>
      <guid>https://community.sap.com/t5/application-development-and-automation-discussions/macro-explanation/m-p/3586161#M863478</guid>
      <dc:creator>HariMaradana</dc:creator>
      <dc:date>2008-03-21T22:01:45Z</dc:date>
    </item>
  </channel>
</rss>

