I have the following code, which should simply open a workbook from a master workbook to allow me to paste some information which I will later retrieve from a d
I'm currently working with CATIA V5, and I want to use Macros (VBA), but I have some problems! My question is: how to change the text of a cut view? (see the p
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
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
I have VBA code in an Outlook rule. I want when I get email with a specific subject, Outlook starts to run a script. However, when email is received, Outlook s
I have a search for items, in subfolders of the Inbox, based on subject line. I am trying to return the most recent mail and have been using the code: Items.Sor
currently, I have a routine in outlook that is run when I send and email. The object of the code is to automatically CC a person in organization A whenever I e
In Outlook 2013 there is an option to import an OPML file and add all or some selected RSS feeds to the feeds list. This function can be triggered by right-clic
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'm new to this, but have been reading some answers earlier and see some experts have clarified many topics which are complex and so seeking help. I'm trying u
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
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