title: How to open a particular Chrome profile in VBA
body: <p>I have two profiles for Chrome that I regularly use simultaneously, and I open up a lot of URLs with macros in Excel. I might be switching between the two Chrome windows, using one for miscellaneous stuff, and the other for opening all the links in Excel. When I open the URLs in Excel, I have it configured so that it will open only in Chrome, but it will always open the URL in my active Chrome window. I would like to be able to specify which profile it opens in. Is this possible?</p>
  
  <p>The shortcut for my extra Chrome profile targets chrome like this: </p>
  
  <blockquote>
    <p>"C:\Program Files (x86)\Google\Chrome\Application\chrome.exe"
    --profile-directory="Profile 1"</p>
  </blockquote>
  
  <p>But I haven't found a way to specify this in the Shell command:</p>
  
  <pre><code>Dim CheckLast As Long
    CheckLast = Worksheets("Work").Range("G" &amp; Rows.Count).End(xlUp).Offset(1).Row
  
  myStr = "http://" &amp; Worksheets("Work").Cells(CheckLast, "C").Value
  Shell "C:\Program Files (x86)\Google\Chrome\Application\chrome.exe " &amp; myStr
  </code></pre>