<?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 How to  break excel external links in University Forum</title>
    <link>https://community.blueprism.com/t5/University-Forum/How-to-break-excel-external-links/m-p/88239#M1971</link>
    <description>Hi all,&amp;nbsp;&lt;BR /&gt;&lt;SPAN&gt;i'm needing to delete external connections from a workbook after importing a CSV file, has anyone experimented with this?&lt;BR /&gt;&lt;/SPAN&gt;Thanks!&lt;BR /&gt;&lt;BR /&gt;------------------------------&lt;BR /&gt;Luz Benitez&lt;BR /&gt;------------------------------&lt;BR /&gt;</description>
    <pubDate>Thu, 29 Oct 2020 16:48:00 GMT</pubDate>
    <dc:creator>LuzBenitez</dc:creator>
    <dc:date>2020-10-29T16:48:00Z</dc:date>
    <item>
      <title>How to  break excel external links</title>
      <link>https://community.blueprism.com/t5/University-Forum/How-to-break-excel-external-links/m-p/88239#M1971</link>
      <description>Hi all,&amp;nbsp;&lt;BR /&gt;&lt;SPAN&gt;i'm needing to delete external connections from a workbook after importing a CSV file, has anyone experimented with this?&lt;BR /&gt;&lt;/SPAN&gt;Thanks!&lt;BR /&gt;&lt;BR /&gt;------------------------------&lt;BR /&gt;Luz Benitez&lt;BR /&gt;------------------------------&lt;BR /&gt;</description>
      <pubDate>Thu, 29 Oct 2020 16:48:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/University-Forum/How-to-break-excel-external-links/m-p/88239#M1971</guid>
      <dc:creator>LuzBenitez</dc:creator>
      <dc:date>2020-10-29T16:48:00Z</dc:date>
    </item>
    <item>
      <title>RE: How to  break excel external links</title>
      <link>https://community.blueprism.com/t5/University-Forum/How-to-break-excel-external-links/m-p/88240#M1972</link>
      <description>&lt;SPAN&gt;&lt;SPAN&gt;nevermind , it was simple, here is the code that did the trick&lt;BR /&gt;&lt;/SPAN&gt;&lt;/SPAN&gt;&lt;CODE&gt;Dim wb As Object = GetWorkbook(handle, workbookname)
dim conn as Object

for each conn in wb.Connections
      conn.Delete
next conn&lt;/CODE&gt;&lt;BR /&gt;&lt;BR /&gt;------------------------------&lt;BR /&gt;Luz Benitez&lt;BR /&gt;------------------------------&lt;BR /&gt;</description>
      <pubDate>Thu, 29 Oct 2020 23:02:00 GMT</pubDate>
      <guid>https://community.blueprism.com/t5/University-Forum/How-to-break-excel-external-links/m-p/88240#M1972</guid>
      <dc:creator>LuzBenitez</dc:creator>
      <dc:date>2020-10-29T23:02:00Z</dc:date>
    </item>
  </channel>
</rss>

