Category "vba"

How to play local video file on loop on an excel userform?

How to play local video file on loop on an excel userform?

How can I compare two dates in Excel VBA?

I'm working on a school project to compare if date1 is equal to date2 - 1 (date1 is one day earlier than date2). date2 is located one cell below date1. This is

How to change sender name in Outlook ?

I am sending an email using Outlook object from a subroutine vba The email gets send from my email and the recipients see : [email protected] . Is there any wa

Argument not recognized when input

I run into run-time error 1004 Works if I use the cell as an argument but I don't want to constrain to one cell. I can get this to run if I use an input param

Deploy/programmatically create Outlook Rule to run Script

I need to deploy an Outlook rule that runs a script. So in other words I need deploy both an Outlook rule and the script it runs. I know I can get users to impo

VBA project explorer still showing the excel workbooks which are closed by the macro

I have created a macro that opens a excel workbook and performs some operations and then at the end it closes the file.The macro is running fine. Now, when I o

How to get the values when multiple items are selected in PivotTable PageField?

I am rying to ge the values of PivotField in PivotTable(1).Pivotfields, then I am trying to get the the filter value to string(str- Declared as string), It is w

VBA Open Workbook from Macro fails "(path & filename) could not be found. Check the spelling..."

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

Change cut view text in CATIA

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

Open HTML file in excel, preserving HTML inline styling

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

Open HTML file in excel, preserving HTML inline styling

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

Wait for 5-10 seconds then run Outlook code

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

Return one newest instance of the mail, based on subject, from multiple subfolders

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

Transferring variable from userform in the itemsend routine in outlook

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

How to import OPML file into Outlook 2013 via VBA?

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

Delete large number of rows (e.g. ~500k rows) based on a certain criteria

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

Sharepoint list retriving and updating using VBA

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

Cannot Run Visual Basic Editor Because of a Syntax error whilst recording macro

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

Determine if an Outlook event is a meeting and what the response was

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

Macro to resize all text boxes in a powerpoint presentation

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