I'm trying to open a HTML file in excel (from VBA) so that the HTML inline styling is preserved. Are there any special ways of doing this because currently I've
In Excel, I am able to add validation rules to a range of cells and limit the accepted input to a list of values displayed in a dropdown. This is done using the
I have a large number of rows and columns (e.g. 500k rows and 20 columns) all filled with numbers. I'm trying to delete all data in column I that has a certain
I am a bit suprised as I am trying to record a macro in Excel, but I keep getting this error: Cannot Run Visual Basic Editor Because of a Syntax error The mo
I'm trying to write a macro in Excel that will look through my Outlook calendar, grab all the events, and display the following information: subject, start time
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