Showing posts with label Application. Show all posts
Showing posts with label Application. Show all posts

Sunday, October 18, 2020

Get Info Of Selected Files Excel VBA Macro

This macro example triggers a dialog box to select files in windows explorer and then shows file name, date created, and file size information for each of them in the active worksheet.

Learn all about Microsoft Excel and VBA macros in Excel Macro Class with plenty of Excel macro examples and VBA learning materials. Find useful Excel macros to automate your daily tasks and work in Microsoft Excel.

Crop Selection Window Excel VBA Macro

This macro example crops the Excel active window to fit the selected range. It does the trick with some useful properties of the Application and ActiveWindow VBA objects.

Learn all about Microsoft Excel and VBA macros in Excel Macro Class with plenty of Excel macro examples and VBA learning materials. Find useful Excel macros to automate your daily tasks and work in Microsoft Excel.

Friday, September 18, 2020

Simple Digital Clock Timer Excel VBA Macro

This macro runs a clock timer in Excel. The user can start/stop the time, and the clock shows minutes and seconds. It is a simple example to learn how to use the OnTime method of the Application object. 

Learn all about Microsoft Excel and VBA macros in Excel Macro Class with plenty of Excel macro examples and VBA learning materials. Find useful Excel macros to automate your daily tasks and work in Microsoft Excel.

Saturday, August 29, 2020

List All Files In Folder Excel VBA Macro

The following macro example triggers a dialog box to select a folder in windows explorer and then lists all files within that folder in the active worksheet.

Learn all about Microsoft Excel and VBA macros in Excel Macro Class with plenty of Excel macro examples and VBA learning materials. Find useful Excel macros to automate your daily tasks and work in Microsoft Excel.

Popular Posts