title: Excel: opening workbook
body: <pre><code>Private Sub CommandButton1_Click()
          ...
          Set wb = Workbooks.Open(Filename:="C:\book1.xls")
          If MsgBox("Please Review the Transmittal sheet, if satisfied click Yes to send,  No to cancel." &amp; vbCrLf &amp; "Transmittal Number: " &amp; Transm, vbYesNo) = vbNo Then
          ...
  End Sub
  </code></pre>
  
  <p>The problem is this, I trying to open a workbook from within another workbook.  The second workbook opens but only to a certain point – the screen is white as if it’s waiting for something to complete.</p>
  
  <p>My code moves to the next line with the msgbox prompt, once I select either yes or no and the sub routine is completed the second workbook then opens completely showing its data.  It doesn’t open properly when called within the sub routine, not under the sub routine is executed completely</p>
  
  <p>Any ideas why?</p>
  
  <p>Over all I’m trying to figure out a solution for the following scenario.  User opens the excel workbook, clicks on a button on the sheet that opens a user form.  The user selects some information in combo box and based on those selections the excel sheet is filled out with relative data.  Once filled the user clicks on a button to generate a report based on the information in the excel workbook.  Before it’s sent, the user must check and confirm that the data is correct on the excel workbook, so they are prompted with a msgbox asking them to do this – click yes if data is correct, no if not.  But with the msgbox and user form, they can’t access the excel workbook.  My thoughts on this was to open a new workbook and copy the data from the current workbook allowing the user to view it that way.  Maybe you have a better way of doing this.</p>
  
  <p>Please note that the original code is not mine so I’m only fixing bugs, this particular bug is that the user can’t focus on the excel worksheet because of the user form and msgbox. </p>
  
  <p>Jim</p>