application filedialog featured
Excel, MS Office, Outlook, PowerPoint, Word

VBA FileDialog – Opening, Selecting and Saving files and folders

Often in VBA we need to ask the users to select files or directories before we execute the actual functionality of our macro. Welcome to the VBA Open file dialog post. Today we will learn how to use the Application.FileDialog, to understand the various msoFileDialogFilePicker file dialog picking options and how to properly manage these […]

visual basic for applications
Excel, MS Office, Outlook, PowerPoint, Word

Do you really need Visual Basic for Applications macro for that?

Visual Basic for Applications (abbrv. VBA) is often misused causing issues with maintaining code, backward compatibility with older Excel version and other issues. Reason being is often that some of us don’t know, or better still, don’t make the minimal effort to learn ready available tools in Excel or other Office applications. From time to […]