Macro that outputs a list of files, sheets, and folders on a sheet "Effective Cell" series File sheet list macro (with ST function) For business use
EC Research Institute Co., Ltd.
About This Product
Purpose
■Gets a list of files, sheets, and folders contained in the specified folder and outputs it to a sheet.
-You can specify folders, hierarchy depth, extensions, etc. You can also get a list of currently open locations.
- Detailed information can be output. More than 100 items can be output, including size, update date and time, various folder information, file information, and in the case of Excel files, Excel file information, sheet information, etc.
- In particular, sheet information allows you to obtain a wide variety of information such as print header, last cell position used, etc.
- You can set the presence or absence of hyperlinks, so you can jump to them with one click.
・You can output a list of files and sheets. You can specify whether to output the sheet list.
・You can output a list of folders.
- Easy to process and reuse as it is output to an Excel sheet. Management of numerous materials such as projects and reports, file management, etc. Detailed information can be output.
- Can also be used to understand and manage disk usage, launch frequently used folders and files, create catalogs of materials, etc.
Especially recommended for those who:
■Those who perform similar work on multiple books and sheets
By simply creating a simple user macro, you can process all books and sheets, making your daily work much more accurate, faster, and easier.
■Those who manage a large number of files and sheets such as projects and reports
File/sheet list makes management easier, and you can immediately open documents you want to see or frequently use with hyperlinks. Managing update status is also easy.
■Those who submit and manage a list of files and sheets to the other party as a catalog etc.
Being able to easily obtain a list of file sheets is very convenient for creating catalogs.
■Those who want to create a book/sheet launcher that collects frequently used books and sheets
Even if the number of files is 9 or more, it can easily record (up to the last 9 files in EXCEL standard) Once you create it, you can save yourself the trouble of searching for it every time, and the more you use it, the more convenient it becomes.
■Those who have low free space on their HDD and want to find files that can be deleted more effectively
A list of all files with size can be output. If you sort by size, it will be clear at once. Folder list is also valid.
-
Product
Macro that outputs a list of files, sheets, and folders on a sheet "Effective Cell" series File sheet list macro (with ST function) For business use
-
Handling Company
EC Research Institute Co., Ltd.
-
Categories
1 Models of Macro that outputs a list of files, sheets, and folders on a sheet "Effective Cell" series File sheet list macro (with ST function) For business use
| Product Image | Part Number | Price (excluding tax) |
|---|---|---|
|
|
File sheet list macro (with ST function) for business use |
Available upon quote |
Customers who viewed this product also viewed
Other products of EC Research Institute Co., Ltd.
View more products of EC Research Institute Co., Ltd.
