Can you please help me to make Excel formula that takes string value from cell and sorts its characters in alphabetical order? Ex. original cell value: 'BACR'
I have a Excel VBA application which has been working fine in Excel 2003 but failed in Excel 2010. The relative codes are Public Sub Create_Chart Dim c
I'm developing an Excel 2010 workbook, in a manual formulas calculation mode. (file -> options -> formulas -> Workbook calculation -> manual) I ha
I have a basic WinForms application and want to be able to write data from this application to an Excel spreadsheet. So far I have the following code: Microsof
When I try to call remove item on my listbox, I get '-2147467259 (80004005)' unspecified error. My rowsource property is blank. I add the items originally thr
I am pretty sure there is an easier way than how i am doing it, I just have two workbooks and a single sheet in each work book, does anyone have any any suggest
I have 2 workbooks....OdysseyDeposit where my source data is and Civil Bank Accnt Recon which contains VLOOKUP to the OdysseyDeposit. Here is the VLOOKUP funct
I am working on a scraper to pull street names and zip codes from a site and all of that is working great and it builds a CSV file just fine for me. But when I
In VBA we can create an object to run and manipulate other applications. I am trying to do a few jobs in Outlook with code in Excel. Eg - With OutMail .Su
I was wondering if you know some tools to help to display a table with around 50 columns. Let's imagine we have 4 row and 50 columns: if we use Excel and dezoom
I currently have this code. It works perfectly. It loops through excel files in a folder, removes the first 2 rows, then saves them as individual excel files,
I have some data structured like this in an Excel spreadsheet: A B C D E F 1 1 1 2 x 2 3 2 1 1 1 2 2 3 3 3 3 3 3 4 4 I am trying to formulate an E
I have an Excel file with a table containing values O and G. I want to replace O with an orange icon and G with a green icon How do I read each cell for value O
How can I read a value related to Specific Column Names with Apache POI in Excel (xlsx). Column Names is my 1st Row of Excel Sheet . value is the row Which hav
I have the following code to get contacts out of Outlook from Excel: Public Sub GetGAL() Dim olApp As Outlook.Application Dim olNs As Outlook.Namespace Dim ol
I have a very simple yet seemingly unsolvable problem: I would like to copy a range of data from a worksheet to another. This is what I made up: Sub CopyProject
I have an array of Strings: Dim sArray(4) as String I am going through each String in the array: for each element in sarray do_something(element) next ele
I am creating a spreadsheet which has many columns and I am trying to make it check if a cell in a certain column is empty then it will check to see the cells i
I have a userform with a frame (Frame1) consisting a vertical scroll bar of height set to 1000 , the Frame houses 160 textboxes arranged in 40 rows and 4 column
I'm trying to query a table in Microsoft Excel using VBA. I've written up some code to try and accomplish this task, but I keep getting an error: run-time e