Importing all components in a folder

T

Todd Huttenstine

Hey guys

I have a folder called...
Q:\CS Management Reports\Reports Setup\Administrator
Files\Exported Modules

This folder contains all the VB components in a project.
The files have .cls, .bas, .frm, .frx extensions. I need
a code that will import all these files in this folder
into OPEN Workbooks("ImportData.XLS").


How do I do this?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trim "\" Value 7
Browse For Folder start directory 2
Export/Import: How do I delete Userform copies? 1
Importing/deleting .bas files (a lot)? Repost 3
Copying code behind from a sheet to a sheet in another workbook. 6
Importing all files in a folder to excel workbook 2
Kill all files in Folder, If folder exists 2
Gathering data from all xl files in a folder 5

Top