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-File sheet list macro (with ST function) for business use
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.

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

Share this product


40+ people viewing

Last viewed: 12 hours ago


Free
Since our quotes are free, feel free to use our service.

No Phone Number Required
You won’t have to worry about receiving unnecessary calls.

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)
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-Part Number-File sheet list macro (with ST function) for business use

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.

About Company Handling This Product

This is the version of our website addressed to speakers of English in the United States. If you are a resident of another country, please select the appropriate version of Metoree for your country in the drop-down menu.

Copyright © 2024 Metoree