Category: Macro
-
How to fix CLSID {00024500-0000-0000-C000-000000000046} error when using excel component in background code?
We have a windows Service application which uses Excel Application Object. It used to work on some machines but not all, the error which I am getting is: Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80070005. After some struggling I found a solution and it works,…
-
How to display negative time in excel cell
While working with excel application I found that if we find difference between 2 times is negative then excel doesn’t display time, it shows “##########” instead of values. For positive difference we don’t have any issue. There are 2 ways to handle this, using 1904 date system and other using custom formula. To change the…
-
remove duplicate values from a excel cell
Microsoft Excel is used by everyone in the world for all data related things, some time we have duplicate cell contents in rows or in columns. To remove these duplicate values from the sheet we already have a feature “Remove Duplicates” in latest version of the excel application. But if we have some duplicate values…