title: Open folder through excel VBA in specific size
body: <p>Goodafternoon all,</p>
  
  <p>Currently programming a small dashboard, when one of the buttons is clicked, it will go to another tab and open a folder/windows from the server. Problem is, it depends on previously opened windows how big the size of the folder will be on the screen. I would like to have this static (for example, when opening a folder through windows explorer, it should take up no more than 25% of the screen). Have looked around, but with the "activewindow" function, I reduce the size of the excel file, while I just want to reduce the size of the folder.</p>
  
  <pre><code>Sub OpenFolderABB()
  Dim MyFolder As String
  MyFolder = "\\CAG\Project OEM\ABC"
  </code></pre>
  
  <p>This part goes fine. Then I either have this line, but I can't give the exact size (except for vb"normal/minimal/maximize"Focus, which either fills the entire screen, picks up the last used size or just shows it in the taskbar)    </p>
  
  <pre><code>Call Shell("explorer.exe" &amp; " " &amp; "\\CAG\Project OEM\ABC")
  </code></pre>
  
  <p>Or this line (which gives me the error that MyFolder is not an object)</p>
  
  <pre><code>ActiveWorkbook.FollowHyperlink MyFolder, vbNormalFocus
      With MyFolder
          .WindowState = xlNormal
          .Height = 75
          .Width = 125
          .ScrollColumn = 1
          .ScrollRow = 1
      End With
  </code></pre>
  
  <p>And it ends with opening the other sheet. (this of course works)</p>
  
  <pre><code>Sheets("ABC").Activate
  End Sub
  </code></pre>
  
  <p>Thanks in advance :)</p>