I need to place a userform next to a selected cell. Here's my code. Excel 2013. In the userform module: Private rangePosition As Range 'Property passed to for
The problem: Control.HorizontalAnchor or Control.VerticalAnchor gets a value out of the accepted range. In the IDE window: Debug.Print Btn.VerticalAnchor -->
I have a VBA project where I need to create a userform on which there should be an attachment button to select multiple images and save them in a folder with a
I want to look through my Excel worksheets and find a sheet with a certain name and delete that sheet if it is found. Afterwards I want to create a sheet after
I've played quite a bit with "PR_SPAM_BLOCKED_SENDERS" ("http://schemas.microsoft.com/mapi/proptag/0x6106001F") and using VBA to manipulate/update my Spam list
I'm using a Split Form in Access 2012. Basic datasheet view on top with individual record and form header in bottom pane. I'm trying to figure if there's a way
I'm receiving Outlook mails that have other Outlook mails (*.msg) as attachments. I need them in txt format (or anything else Word can open). I seem to have tw
I want to automate some basic operations in Outlook 2014, so I create a macro in VBA. But I need to send an email if any error occur during the execution of the
I am in MS Access 2013 trying to set the Reply To address for a olMailItem with Outlook 2013. My current code is giving me: Run-time error '287' Application-d
Hello I am just trying to get into a bit of macro programing to help my Mom, and Dad get some excel work done, and they have some ungodly amount of paper work i
I'm connected to an Exchange server, so some mails are stored in my local Outlook file and some on the server. In Outlook the item count of the folder shows 13.
I'm working on a rec process which will pull data out of a SQL Server database into Excel and out of another application to compare the two sources. I've writt
So I have an Excel document, which is essentially a table. For the purposes of this, we will use this: Dummy Data What I'm wanting to do is take the values fr
I need some help Calling a wsdl web service function. The WSDL have one function named "Bye" that is waiting for 1 parameter of a type String. Then it gives bac
I have a power query function, e.g. getData with one parameter filename Can I invoke that function directly in a vba variable? Something like: Sub MyTest() D
I am working on a tool to analyse data. The data to be analyzed is manually copied into the first sheet, then I am planning to run a macro which analyzes the da
I have some VBA code in Outlook which behaves perfectly for the main Mailbox - however the same code is struggling when I add a secondary mailbox - this is Outl
I'm looking to forward email that I receive in Outlook to a new address with no changes - an exact clone, no envelope information nor signature added. The emai
Is there a way to have a macro changed when the value is changed is changed, not necessarily when a user changes the value? For example, I have a check box th
The user has hundreds of text files and requires making a change in the data before saving and closing them. Below is the code I have for a single file; how can