.net4.0

This has been driving me nuts all day and hopefully someone here knows a solution. Using VB2010, .NET v4.0 framework, have a reference to the "Microsoft Excel12.0 Object Library" set (working with Excel 2007) and have the Microsoft.Office.Interop imported and all of my other code to format an...