This is my second attempt to convert an Excel application into a Visual Basic program. About a year ago I created a freeware Units Converter program using Visual Studio 2010. This time, I transformed my Folder, Subfolders & Files Excel application into a stand-alone .exe using the old Visual Basic 6.0 language. The advantage of using the “old” Visual Basic 6.0 was the fact that the Visual Basic code was quite similar to my original VBA code.
So, with this small utility you will be able to create a list of all folders, subfolders and files of a folder that you have selected. The application creates a new Excel workbook and writes the necessary names, paths and hyperlinks.
How to use it
The short video below demonstrates the application in use.
Download it from here
The program was written in Visual Basic 6.0. It has been successfully tested under the environment of Windows 7 + Office 2010, Windows XP + Office 2010 and Windows XP + Office 2003.
Read also
Yes, that would be a nice addition.
Thank you very much
I’m really looking forward to it
maybe can add file size, but i think this program already good
Best regards,
Ade
Ade,
If I find some free time, I will re-write this small application.
I have 1 or 2 ideas that will make it more useful.
If you have any suggestions, write them here.
When I re-write the application, I could include new features as well.
Best Regards,
Christos
thank you very much
this program very helpful, this program is very useful when creating many hyperlinks in excel
i think the problem is refences at VBAProject, i change some reference-VBAProject to use some VB Program to compatible with some aplication, especially Autocad aplication
Hi, Ade,
That’s strange.
Does it work on your other laptop?
Although this is quite an old application, I tested it on an old laptop with Win 7 and Office 2013 (32 bit) and it is still working fine.
Best Regards,
Christos
this awesome, but when i use at my new laptop, pop up error, could not start excel, i also use office 2010 in both laptop
Thank you very much for you nice comment.. It is nice to see you around.
Warm Regards,
Christos
This blog is really awesome!