Import data from MS SQL in Excel by using Excel VBA
AS-IS Scenario Mr. Rick Rude (HR Executive) has to extract the employee data every day from MS SQL Server Database. He has to extract the data at the start of day and before leaving the day. He has to send 2 reports to…
Import data from MS Access in Excel by using Excel VBA
AS-IS Scenario Mr. Mike Cole (MIS Executive) has to extract the Sales data every day from MS Access Database. He has to extract the sales data every day and prepare Sales report. He has to send the sales report to his Sales Manager…
How to Create Pivot Table and Pivot Chart using VBA
AS-IS Scenario Mr. Andre Dell (MIS Executive) has to prepare a sales report which involves Pivot table and Pivot chart (Bar Chart) to be created from the sales data which represents Sales done as per Region and Order Date. He has to prepare this…