title: lists and arrays in VBA
body: <p>I am extremely new at writing in VB.NET, and I did not even realise that there was a significant difference between VB.NET and VBA. I have been writing my application in Visual Studio, but I realised that I will need to port it over to VBA in Outlook, and there are some syntax issues that I need to deal with. I have already searched, but I cannot find any sort of definitive reference (like the msdn) for VBA or even VB6, which from what I hear is much closer to VBA than VB.NET.</p>
  
  <p>I will include the relevant sections of code here. If anyone needs more context, please let me know--I can post the whole thing, it's not that long. I would like to keep this post as simple as possible, though.</p>
  
  <pre><code>Dim DateToday As String = String.Format("0:{yyyy/MM/dd}", DateTime.Now)
  Dim Computers As New SortedList()
  Dim disabledList As New List(Of String)
  '\\ four additional lists
  Dim compArray As Array
  
  ...
  
  Computers.Add(ComputerName, ErrorState)
  </code></pre>
  
  <p>The new lists and sorted list give Expected: End of Statement at the parenthesis after List. The array gives Expected: identifier at Array. The string DateToday gives an expected end of statement at the equals sign. The attempt to add to the sorted list gives an Expected: =. </p>
  
  <p>I have been working with VB.NET for maybe two or three days, and I have never worked with VBA or VB6 before, so I just do not have the experience required to know where to go from here. If any of you would be willing to help me out, I would really appreciate it!</p>