I want to be able to select all the xml files (they are huge!) from the folder and import them to the sql 2005 db table. This is my import button click event for to read xml files first. And for a good reason (which Iam not sure) this doesnt work. And I also get an error Error Cannot create an instance of the...Jun 11, 2015 · Previously in the article Find and List All Files and Folders in a Directory I’ve explained how you can list all the files in a folder using VBA for Excel. In this article I will explain how you can use VBA to list all the files in a folder, and create hyperlinks to each file. This can be achieved using the code below:
Click Change Permissions for Enclosed Files; In the resulting window, Select Read and Write under Files and Create and delete files under Folders (Figure A) Click Change; Click Close. The trick comes when you need to change the permissions of a folder which does not belong to you. It can be done, but Nautilus must be started with admin access.