<?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 Hello Pooja,
By default this… in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Calling-macro-with-Parameters/m-p/78641#M30643</link>
    <description>Hello Pooja,
By default this method is not available in MS Excel VBO. You need to extend the VBO for this.
Below are the steps to extend/append the functionality you needed:
Open MS Excel VBO
Duplicate the action call ""Run Macro"" which by default available in VBO
Change the name of action which is newly created
Modify the start parameter for newly created&amp;nbsp;action (Note: This action should also get the input parameter to hold the values)
Double click on code stage and pass the input parameter for the code stage.
Click on Code tab --&amp;gt; modify the code as below:
lets consider, you need pass the 2 variable to macro then
Modify the statement : GetInstance(Handle).Run(Macro_Name,param1,param2)

click on ok - &amp;gt; publish and save the newly created action
Use the newly created action in your process.</description>
    <pubDate>Tue, 30 Oct 2018 11:58:00 GMT</pubDate>
    <dc:creator>VijayDodamani</dc:creator>
    <dc:date>2018-10-30T11:58:00Z</dc:date>
    <item>
      <title>Calling macro with Parameters</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Calling-macro-with-Parameters/m-p/78640#M30642</link>
      <description>Hi,

Usually, its defined &amp;nbsp;"Test(" &amp;amp;[Data3]&amp;amp; [TerminationFile]&amp;amp;[Data3] &amp;amp;"," &amp;amp;[Data3]&amp;amp; [UserList]&amp;amp;[Data3]&amp;amp;")" &amp;nbsp;to call a macro having parameters from BP, where

Data3 = "

terminationFile = File Path

UserList = FilePath

&amp;nbsp;

It calls the params and prints MsgBox, but it further calls Load_Xlxs(terminationFile ,UserList ), it fails, saying: The macro may not be available in this workbook or all macros may be disabled.

&amp;nbsp;

Any Clue?

&amp;nbsp;</description>
      <pubDate>Mon, 17 Sep 2018 13:04:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Calling-macro-with-Parameters/m-p/78640#M30642</guid>
      <dc:creator>PoojaSabharwal</dc:creator>
      <dc:date>2018-09-17T13:04:00Z</dc:date>
    </item>
    <item>
      <title>Hello Pooja,
By default this…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Calling-macro-with-Parameters/m-p/78641#M30643</link>
      <description>Hello Pooja,
By default this method is not available in MS Excel VBO. You need to extend the VBO for this.
Below are the steps to extend/append the functionality you needed:
Open MS Excel VBO
Duplicate the action call ""Run Macro"" which by default available in VBO
Change the name of action which is newly created
Modify the start parameter for newly created&amp;nbsp;action (Note: This action should also get the input parameter to hold the values)
Double click on code stage and pass the input parameter for the code stage.
Click on Code tab --&amp;gt; modify the code as below:
lets consider, you need pass the 2 variable to macro then
Modify the statement : GetInstance(Handle).Run(Macro_Name,param1,param2)

click on ok - &amp;gt; publish and save the newly created action
Use the newly created action in your process.</description>
      <pubDate>Tue, 30 Oct 2018 11:58:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Calling-macro-with-Parameters/m-p/78641#M30643</guid>
      <dc:creator>VijayDodamani</dc:creator>
      <dc:date>2018-10-30T11:58:00Z</dc:date>
    </item>
  </channel>
</rss>

