![]() ![]() ![]() ![]() However, at this point Scott started wondering whether the Org Chart Wizard could be automated. With an automated way to create the spreadsheet in hand, the authors intended to manually invoke the Visio Org Chart Wizard to read the data and create the directory display. The collected data also included the attributes of each directory (Read-only, Hidden, System, Archive and Compressed see reference 1 below for code that obtains directory attributes).Īfter some fine tuning by oldviking, the directory listing in Excel for "C:\Program Files\Microsoft Office\" looked like this: To get started, Scott wrote an Excel macro that collected names and paths of the subdirectories on a Windows hard drive or network share and wrote the results to the worksheet. After all, the Windows directory on a hard drive is a hierarchical structure and the Organization Chart Wizard that comes with Visio was designed to display hierarchical information. When you think about it, displaying a directory as an org chart is a very logical idea. When one person specifically asked about displaying directory info in an organization chart format, experts Scott and oldviking decided to give it a try, with the goal of producing something like this: Several times in recent years, someone has posted a question at EE asking whether they could display the Windows directory structure – folders and subfolders – using Visio. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |