There are times while working with an excel list that you would like to delete items of a list without changing the total Sum of that list. Example of this situation often occur when you are reconciling an account and you have various positive and negative values that offset each other. In this small article I will illustrate how you can use Excel and VBA to warn you when your cell deletion has cause the total value of a list to change. Lets take a quick look on how you would tackle this. Continue reading “VBA To Prevent You From Changing List Total.”
Insert excel Data Into oracle database using OO4O
Have you ever had a need to take and excel spreadsheet and load its data into an oracle table. I must say I had this very need a few years back and came upon a small DLL that saved my butt.Welcome to my OO4O tutorial. There is going to be a prerequisite to this tutorial. Continue reading “Insert excel Data Into oracle database using OO4O”