Programming

Excel Object Not releasing from Task Manager (Vb.net)
Hi All, I was trying to create sheets from Book1 to Book2. And used this code Private oexcel As Excel.Application Dim oSourceWorkBooks_1 As Excel.Workbooks Dim oSourceWorkBook1 As Excel.Workbook Dim oDestinationWorkBooks_1 As Excel.Workbooks Dim oDestinationWorkBook_1 As Excel.Workb... 2 Feb 2010 17:29

how do I display last two digits of a SSN in a separate column
I am trying to create a formula to take an existing list of 8 or 9 digit numbers and display the last two numbers in a separate column. Is this possible? ... 2 Feb 2010 17:30

Automatically hide unused columns
I have a 10 year schedule which returns values to a defined point. Is there a way to hide the unused columns with the numerical value i am entering. As an example If i want to show 60 months of cash flow can i hide the other 60 when i enter this value. -- Thanks for your help! ... 2 Feb 2010 17:29

eliminating unwanted data
Column a has data, column b has data. I want ap1 to equal q1 if a1 equals b1. Actually I am looking for a way to eliminate rows if data in one column appears in a second column. Thank you ... 2 Feb 2010 17:29

how do I create a macro to select all colored cells in a worksheet
Need help writing the code for an Excel Macro that would find all cells that have any interior color so that an outer border can be added around all colored cells. ... 2 Feb 2010 17:29

Advanced transpose/grouping question
Don't hesitated to say this is too much for a forum question.... I am attempting to place a series of values from a column into rows, but the details of this task are much more than typical transpose. I have played with formulas, MATCH, OFFSET, etc. and got tangled up. That still my be good way to go. Her... 2 Feb 2010 17:30

How to load specific range of data from html into excel?
Does anyone have any suggestions on how to load specific range of data from html into excel? For example, http://www.hkex.com.hk/markdata/quot/d100114e.htm#short_selling I would like to load this link into excel, but this page is too long, and the limitation of row for excel is 66536, so the specific section of h... 2 Feb 2010 17:30

Check Box Question
I have a user form with several Check Boxes that are for controlling worksheets in a workbook. Each check box is for hiding or unhiding the different worksheets in a workbook from the user form2. Workbook name = Installer Forms Worksheet name = Sheet 1 Checkbox names = Office_Package_Preparations_101 I w... 2 Feb 2010 17:29

Making Plug-In Macros Visible for Custom QAT Access
Hi Gang, 1) I can't see my Public add-in macros for inclusion on QAT. Thoughts? 2) Is it possible to programatically alter QAT? 3) My legacy Add-In menus aren't showing on certain users' machines. In-Fact, their Add-Ins tabs are missing altogether. This is machine specific. One day I'll figure out Ri... 2 Feb 2010 17:29

Excel save takes 18 times longer than Windows Explorer copy - why? Options
Hi All I have an Excel system with about 10 sheets and loads of VBA modules and classes. It resides on a network at my company's headquarters. When I copy the file from my desktop to the server using Windows Explorer drag and drop it takes about 6 seconds. However if I open the Excel file from the s... 2 Feb 2010 17:29