Thread: Converting VBA code to COM addin???

I am not familiar with building a COM addin as in the past I have been able to build all my tools in VBA. Does anyone out there have suggestions for converting this code into a form that is able to run in outlook 2003, and 2007? Also I would like to have a button show up on the menu bar that when clicked executes this code

Sub RunMyForm()
  Dim appAccess As Access.Application
  Set appAccess = New Access.Application
  appAccess.Visible = True
  appAccess.Application.OpenCurrentDatabase ("C:\Users\me\Desktop\test.accdb")

End Sub

Still looking for help on this?

Hi RoyUK - that was a question to the poster. :-)

I could give him some tips, but I just wanted to see if he was still needing help.