<?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 Thanks for that tip, John. in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Get-Last-saved-user-Excel/m-p/84805#M35894</link>
    <description>Thanks for that tip, John. With a macro , Yes, i would be able to get the last user with something like :
Function LastAuthor()
LastAuthor = ActiveWorkbook.BuiltinDocumentProperties(""Last Author"")
End Function 
I would have to then have the macro for each excel sheet to use it. But since I have a dynamically generated excel file without the macro enabled in it,  and there will be thousands of different csv/Excel files to work on, we cannot create the macro for each of the files.
So the question would be, if it was a text file(instead of Excel), how would i get the last saved user each time?
Thanks</description>
    <pubDate>Wed, 25 Oct 2017 21:28:00 GMT</pubDate>
    <dc:creator>JosephJohn</dc:creator>
    <dc:date>2017-10-25T21:28:00Z</dc:date>
    <item>
      <title>Get  - Last saved user - Excel</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Get-Last-saved-user-Excel/m-p/84803#M35892</link>
      <description>How to get the last saved user from an Excel Sheet? Is there a way that BP can extract this value?

The Utility File management - gives all the details except this. Any ideas are welcome!

Thanks,</description>
      <pubDate>Tue, 24 Oct 2017 20:45:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Get-Last-saved-user-Excel/m-p/84803#M35892</guid>
      <dc:creator>JosephJohn</dc:creator>
      <dc:date>2017-10-24T20:45:00Z</dc:date>
    </item>
    <item>
      <title>BP uses the Excel VBA API, so</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Get-Last-saved-user-Excel/m-p/84804#M35893</link>
      <description>BP uses the Excel VBA API, so you need to first research how a macro would do it. Then it's a case of transcribing the macro code into VB.Net.</description>
      <pubDate>Wed, 25 Oct 2017 13:25:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Get-Last-saved-user-Excel/m-p/84804#M35893</guid>
      <dc:creator>John__Carter</dc:creator>
      <dc:date>2017-10-25T13:25:00Z</dc:date>
    </item>
    <item>
      <title>Thanks for that tip, John.</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Get-Last-saved-user-Excel/m-p/84805#M35894</link>
      <description>Thanks for that tip, John. With a macro , Yes, i would be able to get the last user with something like :
Function LastAuthor()
LastAuthor = ActiveWorkbook.BuiltinDocumentProperties(""Last Author"")
End Function 
I would have to then have the macro for each excel sheet to use it. But since I have a dynamically generated excel file without the macro enabled in it,  and there will be thousands of different csv/Excel files to work on, we cannot create the macro for each of the files.
So the question would be, if it was a text file(instead of Excel), how would i get the last saved user each time?
Thanks</description>
      <pubDate>Wed, 25 Oct 2017 21:28:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Get-Last-saved-user-Excel/m-p/84805#M35894</guid>
      <dc:creator>JosephJohn</dc:creator>
      <dc:date>2017-10-25T21:28:00Z</dc:date>
    </item>
  </channel>
</rss>

