title: Error when try Excel VBA code to change source of pivot table
body: <p>I came up with this code and all of my files are in a shared folder:</p>
  
  <pre class="lang-vb prettyprint-override"><code>ActiveSheet.PivotTables("pivottable1").ChangePivotCache_
  ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase,_
  SourceData:=ActiveWorkbook.Path &amp; "\" &amp; "[" &amp; ActiveWorkbook.Name &amp; "]" &amp;_
  Sheets("RawPDTBKK").Name &amp; "!" &amp;_
  Sheets("RawPDTBKK").Range("a1").CurrentRegion.Address)
  </code></pre>
  
  <p>But, it is turn out that Excel VBA does not allow me to put &amp; "\" &amp;. 
  Is there any way to fix this?</p>