You’ve come to the right place of simple solutions & useful tricks in VBA in Excel, other Office applications (Word, PowerPoint…) and external apps (SAP, Internet Explorer…) too!
I invite you to Posts to read the latest entries. Use search engine to find articles You’re interested in from this website.
If You are better watcher go to Videos to watch some tutorials of mine from my YouTube channel.
Visit Memes gallery to see my collection of articles main pictures, also stored on Pinterest profile.
Go to About me to contact me.
Recent posts:
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 How to get data from Excel table using ListObject?
How to Save As and Open Excel during SAP scripting?
Native Microsoft Windows dialogs in SAP