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
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
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 made a model for our project managers to follow the economy in different projects. A wish for the model was the option to add rows into the matrix I made with
There are 1000s of .MSG files on my d drive and each containe an XLS file,as attachemnt. Is there any way to download these xls files from these .msg file usin
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
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 need to constantly update excel file with information, obtained from the following link (warning, ukrainian language): link to the Ministry of Finance web-sit
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'm trying to delete a mailitem using the outlook API. Like the following, Dim objMail For each objMail in objFolder.Items objMail.Delete Next Obviously, del
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
EDIT: I am looking for an APL function, or MS Access VBA function, which takes as arguments the total number of employees, total number of dinning tables, and n
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
I have a number of imported worksheets from CSV. The data includes timestamps based on UNIX epoch. Each time I import a new sheet I need to add a column to conv
I have a VBA function in Excel returns a concatenated string of text from cells selected by users. This works as I require, however if there are hidden cells i
I am currently working on a code that is supposed to assign a value to a certain variable and open a file with the name assigned to the variable. However, every
While Folder.SetCustomIcon can be used to customize folder icons, the only thing related to icons for messages seems to be the deprecated (and basically undocum
I have an access file that I regularly need to copy to another directory, replacing the last version. I would like to use an Excel macro to achieve this, and wo