I have tried to set up an application on a server that is using microsoft excel interop. When trying to do the installation I get errors relating to entry points. I installed Office on the server to test whether it is related to libraries. The installation worked but I cannot leave office on the server.
Does anyone know what libraries or other factors I need to include or be aware of when installing excel interop as part of a VB installation
To use interop, you need to install the software. You cannot just copy some DLLs.
What are you trying to do? Read Excel file? Create some?
To read simple files, check http://emoreau.com/Entries/Articles/2013/07/A-free-LINQ-to-Excel-and-CSV-provider.aspx
The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.
For most people, the WrapPanel seems like a magic when they switch from WinForms to WPF. Most of us will think that the code that is used to write a control like that would be difficult. However, most of the work is done by the WPF engine, and the W…
More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel.
Part 1 of this series discussed basic error handling code using VBA.