VBA Code to Close all Workbooks in One Go

VBA Code to close all workbooks all Workbooks in One Go What is it: This VBA Code will help you close all workbooks opened in the system in one go. Why: When you are creating an Excel Macro to create a consolidated report from multiple individual workbooks and after updating…

Continue reading

VBA Code to Open Excel File from Folder

Open Excel File from Folder with VBA Code What is it: This VBA Code will help you browse and Open Excel File from Folder or a directory. Why: When you create a program and if you want to provide the user an option to select a particular Excel file and…

Continue reading

VBA Code to Import Access Table /Query data to Excel

Import Access Table to Excel with VBA (Images and Code) What is it? This VBA code helps you to download or import Access Table data or Query to Excel in one click. Why is it? You can import Access table data to Excel without even opening the Access DB. How to import Access…

Continue reading

VBA Code to Export Access data to Excel

Export Access data to Excel using VBA (with Images & Code) What is it? This VBA code helps you to export data in Access Table to Excel in one click. Why is it? You can upload or export Access data to Excel without even opening the Excel Workbook. How to Export Access data to…

Continue reading

How to enable Developer tab in excel 2007

Enable Developer tab in excel 2007 (with Images) What is a Developer Tab:  This tab need to be accessed when we are developing or running macros using Visual Basic to use with Microsoft Office programs. Why is it important: This tab contains lots tools which are essentials when we are creating  applications to use with…

Continue reading

Excel VBA Macros Tutorial for Beginners

Excel Macros or VBA Tutorial for Beginners (with Images) This Introductory post/tutorial is for beginners who want to learn the basics of Excel Macros ! Before getting started with excel macros just two lines about Macros and VBA. What is a Macro? – A macro is a series of VBA commands and functions…

Continue reading