I've been successfully using the Yahoo Finance API cookie/crumb technique to get historical stock quotes for many years. On April 28th, 2022, it broke, and exc
I am trying to select a worksheet every time when i open up a workbook using an inputbox in VBA. here is my code for opening a workbook but after i open up my w
I have a loop to check for incoming emails from Joe Doe with specific subject. That loop works and saves attachments from Joe Doe. If (Msg.SenderName = "Doe, J
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