Let’s go back to the basics and learn about getting the data from Excel worksheet. But not just filled worksheet cells with text and numbers. In this article I’m going to show You how to get the Excel table data using ListObject in VBA.

Make your office life easier with simple and fast Excel VBA solutions.
Let’s go back to the basics and learn about getting the data from Excel worksheet. But not just filled worksheet cells with text and numbers. In this article I’m going to show You how to get the Excel table data using ListObject in VBA.
I received from You so many questions about this, so I decided to investigate the issue. In this article I’m going to show You how to save as and open Excel spreadsheet during execution of SAP scripting code.
In one of my articles I showed You how to turn off the pop up message boxes in Accessibility & Scripting options
, but didn’t really describe about the 3rd checkbox below Enable scripting. In this article I’m going to show You how Show native Microsoft Windows dialogs works in SAP.I already presented you the way to loop through tabs in specific transaction. Now it’s time to show You how to find any field in SAP transaction, using recursion.
Sap Scripting can be really tricky sometimes. My job is to help You and solve any mistery case. In this article I’m going to show You a trick, which will help You to get next SAP object in loop and get through the iteration issue.
Between SAP tickets, I noticed that there may be a problem with recording actions when filling in different fields on several different tabs of a given transaction. In this article I’m going to show You how to run smoothly between tabs – loop through MM02 tabs in SAP.