I pull the Subject, received date and sender's name with the following code: Set InboxSelect = GetObject("", "Outlook.Application").GetNamespace("MAPI").PickFo
I´m trying to find and replace multiple sentences from different word files from an specific folder. The words that I´m trying to change are on two
In Excel we have the "Name Box" in the upper-left side, but I could not find a way to retrieve the name of a shape in Word. How do I do that?
I've an Access database that records and saves email on the mailitem_send event. Saved email looks like: I want email to appear like an already sent email, li
My users have their personal mailbox as their primary account and an auto-mapped shared mailbox configured in their Outlook 2010 client. The shared mailbox is a
I have a database in SQL Server that I'm using to feed some financial reports in Excel. I'm using Recordsets through a custom Excel Function that uses arguments
I am running an Excel 2010 macro that opens another workbook and removes a few code modules (a form and a BAS module). After that it re-imports them as an updat
I wanted to develop a macro for my worksheet that would pick up a range and change the color of specific chars based on its color. This was similarly answered b
I have an Excel userform I want to resize on opening to fit the screen resolution. I get the height and the width through Application.Height and Application.Wi
I have written a code for web data downloading using selenium VBA, it works good in Firefox, but many time Firefox is crashing. I tried to launch chrome/IE from
I just learned to use VBA in excel, I have a spreadsheet as shown, I have columns from B1:B12 containing content to search and move, I want to build code to se
Set objOutlook = CreateObject("Outlook.Application") Set objMail = objOutlook.CreateItem(0) objMail.To = "[email protected]" objMail.cc = "[email protected]" o
I am trying to do a email export from outlook to excel macro which includes the recipient, email subject and most importantly the date time of email reply. I ha
How to properly save this kind of attachment (from signed message)? I saved this with .SaveAsFile method, but it is without any extension and no application can
Yet another topic with multidimensional array and Redim Preserve, I know. I read a lot of them but still can not understand why my code is not working. I kwow
When I use (some code here).copy destination:=(some code there). It will still prompt for protection issues on cells. Basically it just won't let my code runs.
I need help with this macro. Every time I run it, I get the error below. I thought it was a simple macro that I could have anybody on my team use to make it t
My problem is that an Excel spreadsheet (exported from Access as .xls) has cells that look empty, but are not. This is mucking up my calculations & navigati
I tried the following to filter (between filter) my worksheet based on 2 values. The 2 values are input in textbx1 and textbox2 in userform 'A1_Filter_Range'.
I have a lot of PDFs to convert to excel. I found the code below which converts PDF to excel by opening the pdf file in word but it fails at Dim fso As New File