<?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 Hi, in Product Forum</title>
    <link>https://community.blueprism.com/t5/Product-Forum/Renamed-Worksheet/m-p/72368#M24973</link>
    <description>Hi,
Based on the error you are detailing, the experience I have is you have one of the following problems:
-Tab names for worksheets have a limited character length or 31 - Make sure the input you are using doesn't exceed this. Keep in mind spaces are classed as a character in tab names.
-Tab name are highly restricted for special characters - Make sure you are using simple text Ampersand are allowed but I would using only 1 and the rest basic chars.
Thanks,
James</description>
    <pubDate>Thu, 26 May 2016 15:49:00 GMT</pubDate>
    <dc:creator>jgreaves2</dc:creator>
    <dc:date>2016-05-26T15:49:00Z</dc:date>
    <item>
      <title>Renamed Worksheet</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Renamed-Worksheet/m-p/72367#M24972</link>
      <description>Hi there,

I'm trying to rename a worksheet but i have some errors.
Could you help me please ?

'Here in VBA
    'Sheets(worksheetName).Select
    'Sheets(worksheetName).Name = newName
    'ws.Name = newName

'What i put on BluePrism

'First Try
Dim ws As Object
ws = GetWorkSheet(handle, workbookName, worksheetName)
ws.Select
ws.set(handle, workbookName, newName)
'Error : Internal : Could not execute code stage because exception thrown by code stage: Public member 'set' on type 'Worksheet' not found.


'Second try - Should be worked ? It talks about wrong worksheet name but i have checked
Dim ws As Object
ws = GetWorkSheet(handle, workbookName, worksheetName)
ws.Select
ws.Name = newName

'Internal : Could not execute code stage because exception thrown by code stage: Vous avez tapÃ© un nom de feuille ou de graphique non valide. VÃ©rifiez les points suivants&amp;nbsp;:
€¢ Le nom ne dÃ©passe pas 31&amp;nbsp;caractÃ¨res.
€¢ Le nom ne contient aucun des caractÃ¨res suivants&amp;nbsp;: \ / ? * [ ou ]
€¢ Le champ du nom n'est pas vide.


Thanks,
Regards,
KG</description>
      <pubDate>Thu, 26 May 2016 15:34:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Renamed-Worksheet/m-p/72367#M24972</guid>
      <dc:creator>kevin_guillemie</dc:creator>
      <dc:date>2016-05-26T15:34:00Z</dc:date>
    </item>
    <item>
      <title>Hi,</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Renamed-Worksheet/m-p/72368#M24973</link>
      <description>Hi,
Based on the error you are detailing, the experience I have is you have one of the following problems:
-Tab names for worksheets have a limited character length or 31 - Make sure the input you are using doesn't exceed this. Keep in mind spaces are classed as a character in tab names.
-Tab name are highly restricted for special characters - Make sure you are using simple text Ampersand are allowed but I would using only 1 and the rest basic chars.
Thanks,
James</description>
      <pubDate>Thu, 26 May 2016 15:49:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Renamed-Worksheet/m-p/72368#M24973</guid>
      <dc:creator>jgreaves2</dc:creator>
      <dc:date>2016-05-26T15:49:00Z</dc:date>
    </item>
    <item>
      <title>Hi James,</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Renamed-Worksheet/m-p/72369#M24974</link>
      <description>Hi James,
Thank you for your reply, i have ever checked these details.
worksheetName = ""monClasseur""
new worksheetName = ""monClasseurRenamed""
With regards,
KG</description>
      <pubDate>Thu, 26 May 2016 16:31:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Renamed-Worksheet/m-p/72369#M24974</guid>
      <dc:creator>kevin_guillemie</dc:creator>
      <dc:date>2016-05-26T16:31:00Z</dc:date>
    </item>
    <item>
      <title>Problem solved for me.</title>
      <link>https://community.blueprism.com/t5/Product-Forum/Renamed-Worksheet/m-p/72370#M24975</link>
      <description>Problem solved for me.
 Here the code :
Dim ws As Object
ws = GetWorkSheet(handle, workbookName, worksheetName)
 ws.Select
ws.Name = newName</description>
      <pubDate>Mon, 30 May 2016 18:42:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/Product-Forum/Renamed-Worksheet/m-p/72370#M24975</guid>
      <dc:creator>kevin_guillemie</dc:creator>
      <dc:date>2016-05-30T18:42:00Z</dc:date>
    </item>
  </channel>
</rss>

