Resolved: Method ‘Sheets’ of object ‘_Global’ failed

We have a complex macro enabled spreadsheet. Today we got a ticket from the business user that Excel is throwing error “Method ‘Sheets’ of object ‘_Global’ failed.”. I searched online but could not find the straight forward answer. None of the online discussion was giving the root cause of the error and everyone was discussing… Read More »

Execute Package Task fails even though the package executed successfully

We have parent and child SSIS packages. Both the packages are using environment variable configuration to get the confuguration database and sql configuration to get the further configuration property. Both the packages have sql authentication and package protection level is “EncryptSensitiveWithUserKey”. Both the packages run as expected in development environment but when moved to QA,… Read More »

The value violated the integrity constraints for the column

If you happen to get an error “The value violated the integrity constraints for the column”, it means that it tried to insert null value into the non nullable column in the database. If the source is table or in any other easily verifiable format, you can visually look at it. If the source is… Read More »

Restore missing button and drop down controls in Excel

Have you ever faced a situation where suddenly all the buttons, drop downs and various controls are missing from your Excel spreadsheet? Well, it’s not gone but it is hidden. Here is the setting to make the controls visible. Go to File > Options > Advanced > Display options for this workbook > For objects,… Read More »

How to use plain old JavaScript file into Node.js as a module

If you want to use your plain old JavaScript file into Node.js, you need to create a module which is nothing but a fancy wrapper around your JavaScript file and then you can use all the functions of your JavaScript object into Node.js. Environment Windows 7 (64 bit) Node.js 4.4.2 (64 bit) Path already contains… Read More »

How to permanently remove the changeset from Mercurial?

Steps Backup repository/repositories you want to modify. Enable “mq” extension. If you don’t know how to enable it, follow these steps. Open TortoiseHG Workbench Go to File > Settings > USERNAME’s Global Settings > Extensions > select “mq” > press OK button Restart TortoiseHG by closing and opening it again. Select changeset you want to… Read More »