<?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 Always experiement with the… in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Use-VBA-Code-WeekdayName-WeekDay/m-p/79787#M31621</link>
    <description>Always experiement with the functions available in a calculation stage before you create bespoke code stages.&amp;nbsp; There is a FormatDate function where you can use the ""dddd"" as the format to get the full day as text.</description>
    <pubDate>Mon, 05 Mar 2018 19:30:00 GMT</pubDate>
    <dc:creator>Denis__Dennehy</dc:creator>
    <dc:date>2018-03-05T19:30:00Z</dc:date>
    <item>
      <title>Use VBA Code - WeekdayName &amp; WeekDay</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Use-VBA-Code-WeekdayName-WeekDay/m-p/79786#M31620</link>
      <description>Hello,

I want to use this VBA Code Stage in RPA:

GetWeekDay = WeekdayName(Weekday(Date, vbMonday), True)

but I got this errormessages:

Weekday and WeekdayName is not declared.

&amp;nbsp;

In Excel VBA this Code Stage works&amp;nbsp;well!

I would be happy about your help :)

&amp;nbsp;

&amp;nbsp;</description>
      <pubDate>Mon, 05 Mar 2018 14:54:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Use-VBA-Code-WeekdayName-WeekDay/m-p/79786#M31620</guid>
      <dc:creator>HannesTHEISL</dc:creator>
      <dc:date>2018-03-05T14:54:00Z</dc:date>
    </item>
    <item>
      <title>Always experiement with the…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Use-VBA-Code-WeekdayName-WeekDay/m-p/79787#M31621</link>
      <description>Always experiement with the functions available in a calculation stage before you create bespoke code stages.&amp;nbsp; There is a FormatDate function where you can use the ""dddd"" as the format to get the full day as text.</description>
      <pubDate>Mon, 05 Mar 2018 19:30:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Use-VBA-Code-WeekdayName-WeekDay/m-p/79787#M31621</guid>
      <dc:creator>Denis__Dennehy</dc:creator>
      <dc:date>2018-03-05T19:30:00Z</dc:date>
    </item>
    <item>
      <title>VBA is not the same as VB…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Use-VBA-Code-WeekdayName-WeekDay/m-p/79788#M31622</link>
      <description>VBA is not the same as VB.Net and you can't simply paste from an Excel macro into a BP code stage. The two languages are similar but they are not the same, and an explanation on how to rewrite VBA as VB.Net is beyond the scope of this forum I'm afraid.</description>
      <pubDate>Tue, 06 Mar 2018 13:56:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Use-VBA-Code-WeekdayName-WeekDay/m-p/79788#M31622</guid>
      <dc:creator>John__Carter</dc:creator>
      <dc:date>2018-03-06T13:56:00Z</dc:date>
    </item>
    <item>
      <title>Visual Basic functions are…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Use-VBA-Code-WeekdayName-WeekDay/m-p/79789#M31623</link>
      <description>Visual Basic functions are not included&amp;nbsp;by default even though you are using VB.NET
You can go to the 'Code Options' section by double-clicking the box in the Initialise page of your object. Then import Microsoft.VisualBasic namespace, and voila, you have Visual Basic functions.
It is 5th on my list of Namespace Imports in the image
&amp;nbsp;
&amp;nbsp;
&amp;nbsp;</description>
      <pubDate>Tue, 06 Mar 2018 14:36:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Use-VBA-Code-WeekdayName-WeekDay/m-p/79789#M31623</guid>
      <dc:creator>Anton__Hosang</dc:creator>
      <dc:date>2018-03-06T14:36:00Z</dc:date>
    </item>
    <item>
      <title>I recommend strongly against…</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Use-VBA-Code-WeekdayName-WeekDay/m-p/79790#M31624</link>
      <description>I recommend strongly against using&amp;nbsp;code stages where what you want to do can be done in a calculation stage.&amp;nbsp; For Enterprise RPA you should be moving away from creating bespoke scripting code as much as you can - your solution may be supported in future by someone with less coding experience than yourself.&amp;nbsp; &amp;nbsp;Many clients have selected Blue Prism because it is more of a business tool that in most scenarios will not require coding.
What Theisl wants to do is perfectly easy to figure out using the calculation stage expression builder - so there is no need for code&amp;nbsp;FormatDate([Weekday], ""dddd"")=""Monday</description>
      <pubDate>Tue, 06 Mar 2018 16:55:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Use-VBA-Code-WeekdayName-WeekDay/m-p/79790#M31624</guid>
      <dc:creator>Denis__Dennehy</dc:creator>
      <dc:date>2018-03-06T16:55:00Z</dc:date>
    </item>
  </channel>
</rss>

