title: Macro (VBA) in Excel is failing on colleagues PC but works on mine when colleague is logged in
body: <p>I'm developing VBA tools to automate a series of long winded administration tasks, the code runs fine in the following circumstances.</p>
  
  <ul>
  <li>When I am logged into my PC</li>
  <li>When my colleague is logged into my PC</li>
  <li>When I am logged into my colleagues PC</li>
  </ul>
  
  <p>However it fails to complete correctly, when my colleague runs it on her PC.</p>
  
  <p>The specific area it is failing in is:</p>
  
  <pre><code>'creates 2 dims for location of the two files that need opening based on the critera set on the home page
  
  Dim newdata As String
  newdata = Range("f11").Value
  Dim olddata As String
  olddata = Range("f12").Value
  Dim fileextension As String
  fileextension = Range("f14").Value
  
  Dim fulllocationolddata As String
  fulllocationolddata = Range("f13") &amp; olddata &amp; fileextension
  
  Dim fulllocationnewdata As String
  fulllocationnewdata = Range("f13") &amp; newdata &amp; fileextension
  
  
  'open file containing OLDDATA c&amp;p previous days data to the conversion tool
  'then shuts the old data workbook
  
    Workbooks.Open Filename:=fulllocationolddata
    Workbooks(olddata).Activate
    Worksheets("sheet1").Select
    Range("A1").CurrentRegion.Copy
  
    Workbooks("Stockfile Conversion Tool.xlsm").Activate
    Sheets("OLD STOCK").Activate
    Range("A3").Select
    Selection.PasteSpecial
  
      Workbooks(olddata).Activate
      Worksheets("sheet1").Select
  
    Workbooks(olddata).Close SaveChanges:=False
  </code></pre>
  
  <p>The final line (Workbooks(olddata).Close SaveChanges:=False) does not shut the workbook, then later in the macro I open another workbook of the same name but as it's already open it just activates the window and the rest of the code falls apart.</p>
  
  <p>If anyone has any ideas where I'm going wrong it would be appreciated.</p>
  
  <p>Thanks in advance for your assistance</p>
  
  <p>Plan303</p>