I have been developing VBA Office tools for a few years and am starting to move to VB using VB 2005 Express. I will have several questions over the next few weeks as I try to get educated on the language and the development environment. To begin:
If I include a reference to Microsoft's COM interface to Excel, and subsequently program objects in that namespace, what happens when I deploy the application? In other words, what will happen when the application runs on another machine? Will the reference hold, or will the user experience a run-time error? Is it standard practice to use early binding for Office automation, as I am attempting to do, or do programmers normally create objects as needed, given the uncertainty of the host environment? These may seem like stupid questions, but bear with me, I'm just getting started.
Thanks in advance,