Here I explain how to change headings and body font in Microsoft Word. I used Microsoft Word for Mac Version 16.70.
Continue reading How to change Headings and Body Font in Microsoft WordTag Archives: VBA
Excel: Move Cursor in All Sheets to Top Left
When you opened the excel file other man saved, have you thought “Why didn’t he move cursor to A1 cell” before ? Not to be thought so, conversely, I will introduce the way to move cursor in all sheets to top left, move scroll bars in all sheets to top left and activate first sheet.
Continue reading Excel: Move Cursor in All Sheets to Top LeftReaders who viewed this page, also viewed:
Excel: Prepare to Connect to the Database from VBA
Here’s the way to connect to the database from Excel VBA. (Excel から VBA を使わずにデータを取得・表示する方法もあります。 例: Windows, Excel: データベースから直接値を取得して表示する)
Continue reading Excel: Prepare to Connect to the Database from VBAReaders who viewed this page, also viewed:
PostgreSQL: Basic Cursor Handling
How to send email automatically and periodically
Does Mosquito Coil Work on Flies?
Google Drive: Stop Automatic Conversion ” and ‘ to “” and ‘’
Proof: Infinite Decimal of Rational Number is Recurring Decimal
How to Remove Accidental File Type Associations in Windows 10Create Wireless Internet Radio with Raspberry Pi (2 of 2)
For Loop of Controls in Excel VBA
The Required and Recommended Amount of Vitamin C for a Smoker
Calculate Pentagons and Hexagons in a Soccer Ball
VBA: Output file list in a directory, recursively
This is the code I frequently use.
It recursively exports file list in a directory on Microsoft Office Application, like Excel. It is written in VBA.
VBA can be written in object oriented way, but I didn’t because I had to write the code as soon as possible.
Process Flow
- A user clicks the button on the sheet.
- The program show a folder browsing dialog.
- User chooses the folder, then the program make the list of file in the folder.
- The program exports the file list onto a form (or sheet).
To Do
- Create a module file and create the following functions.
- get file list
- handle folder browsing dialog
- Create a dialog to show the result.
- Create a button on the sheet and add function on clicking.
Readers who viewed this page, also viewed:
(日本語) VBA: ファイル名に関連した文字列操作
Sorry, this entry is only available in 日本語.