Office Interops. See this thread on EXCEL / VB.Net stuff too.
Hi, not sure if this is the correct forum, but here goes:
My VS2005 VB application uses excel interop 11.0 library to communicate with excel 2003.
In the publish settings I have interop.dll as a required prerequisite (auto).
The problem I'm having is that some users naturally have different versions of excel & I'm not sure how to get over this. The application will not run without the assemblies - it gives an error:
"The application requires that assembly ...interop excel version 11.0.0.0 be installed in the GAC first".
Where they have excel 2003 it's a simple matter of running O2003PIA.msi, but I now have users with 2002 & 2007.
Can I change the publish settings to include the dlls? Will this then install on the users machine? Will it allow communication with excel?
