Excel With VBA

Hi, I made a post about this referencing the Outlook inbox on my blog at vbahowto.com (http://vbahowto.com/how-to-extract-data-from-outlook-to-access-with-vba) This is the Excel version of how to export outlook emails to excel with date and time. It’s pretty much the same as looping the inbox, but instead of “throwing” the results into a table, we will put…

I am going to show you 2 ways of scraping data from a website. One with the standard approach and 1 with JSON. For this example, I want the stock numbers from yahoo in my worksheet. The site is https://finance.yahoo.com/quote/%5EGSPC/history?period1=1520575200&period2=1552111200&interval=1d&filter=history&frequency=1d This data is rendered in a table format so I can use the following code…

This post is actually a response to a question someone had. ‪i need help comparing two cells with a high and low value, one of the cells is blue. Return 1 if the lowest value is blue color or return zero if the higher value is blue color. how do i perform this task in…

This post is actually an answer to a question on a youtube video “I am facing one problem during working with excel, how do I solve below….. Serial number in row:1,2,3,4………… Required no of repit :2,1,3,2………… Answer will be : 1,1,2,3,3,3,4,4…….. How do I solve this problem??? Where one and another dejit will repit continuously..…

This post is called “How To Have Excel VBA Write To XML File”, and is going to be an enhancement to my previous post: http://www.vbastring.com/blog/how-to-create-an-excel-userform-to-add-edit-and-delete/ In this post we are going to add a button to our form where we can save the current contents of the worksheet to an XML file. Here is the…

This post is going to show you how to create a UserForm in Excel which will allow you to do the most common tasks of add, edit, and delete of records. Here is the code for the form above: ‘Erik Loebl ‘https://vbastring.com ‘erik@loeblcomservices.com ‘We will make a modular scope variable because we need this _…

This post is to help answer a question from the youtube video at https://www.youtube.com/watch?v=kamx7NnsCZI&t=2s hi, i need help with the msgbox. I would like a msgbox to pop up if a particular value is smaller than a condition value eg. is 39 < 40, a msgbox should pop up to indicate that the number is…

This post will show you how to find and filter your worksheet based on the value in your text box. Here is a short description of what we want to do: Since we are using VBA, we can use ADO, and not the standard Find/Replace function Excel provides. The following example will allow the user…

In this post I am going to show you how you can find the last row in excel vba, so you can enter your new data. On the previous screen I have a list of random names I generated from https://www.generatedata.com/ When the button “View/Edit Records” is clicked, we’re launching a UserForm which allows us…

In this post I’m going to show you how to hide and unhide sheets in excel with vba. We are also going to load the data from the active sheet into the text boxes of the UserForm. Essentially, we have 5 worksheets with the same layout. It’s just that each patient has their own spreadsheet.…