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
I exported a PDF as a powerpoint presentation. The PDF had A4 pages, while the powerpoint has wide slides (16:9), and the text has ended up being centered in th
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