VBA For Loop

How To Exit A Do Or For Loop Using An API Call

This post is going to show you how you can exit a for or do loop in VBA using an API call. API calls use the power of the Windows operating system to do your wishes. Here we are using the “GetAsyncKeyState” API function: Insert the following code in a common module. Click in the […]

Continue Reading

Peoplesoft To SAP Migration Via Access

I received an interesting question yesterday from a potential customer. They are migrating all their Oracle PeopleSoft data to SAP. (They are exporting from PeopleSoft into Excel, importing it into Access to tweak it, and exporting to csv from Access to upload to SAP) Basically, how to take 1 (PeopleSoft) row and make it into […]

Continue Reading

How To Exit A VBA Loop

Hi, there are times when you need to exit a loop after a certain condition has been met. How do you exit function in VBA? In the following example, you are going to see how to exit a function in VBA: 1234567891011121314151617181920Sub StartNumbers()     Dim intNumber As Integer         intNumber = […]

Continue Reading

How To Extract Data From Outlook To Access With VBA

In this post you are going to find out how you can extract data From Outlook to Access with VBA”. Someone at the place I’m working at was let go, and they wanted the information, primarily from the user’s Outlook inbox, to be extracted to an outside application so the particular information about various projects […]

Continue Reading

VBA For Loop

Use the VBA For Loop when you know how many iterations the code should make. Using this VBA For Loop will allow you to loop for a specific number of times. Take a look at the video: The syntax for the VBA For Loop is: ****************************************** For counter= start To end [Step backward count (how […]

Continue Reading