title: Error when Trying to use Try-Catch blocks within excel VBA to get inner exceptions
body: <p>I am working through excel and VBA. I am trying to get the inner exception from an automation exception, but to start off I need to get try catch blocks working in the first place. It looks like I've exactly replicated the syntax from the microsoft documentation. Here is the code:</p>
  
  <pre><code>Try
      Set sm = CreateObject("SpectrumManager.Application")
  Catch ex As Exception
      MsgBox ("Can't Create Object") 'placeholder
      'I want to get the inner exception from ex here
  End Try
  </code></pre>
  
  <p>The error message at End Try is this: "Expected: If or Select or Sub or Function or Property or Type or With or Enum or end of statement"
  The error message at the Catch is this: "Expected: end of statement"</p>
  
  <p>What am I doing wrong? thanks for the help in advance.
  edit: I realize now that vba does not support try-catch blocks. That leads me to the question, is there any way to get an inner exception from the original exception that was sent? Or is that information lost when it is converted into a vba Error?</p>