Macros - Coding Macros - Windows Folder Listings

**theprofessionalnyc** · 04-09-2013, 10:11 AM

I apologize but I am not a VBA or Excel Guru.

I want to be able to use MS Excel 2007 Macro tool to create a list of yellow Folders on a certain hard drive (entire drive such as C:\ or E:\ or X:\ etc.) using the program below (see link), but I am stuck because of my cluelessness compared to you members who are Gods in my eyes for this stuff.

Here is the link below, but I am not sure where I "copy and paste" this code below to get Excel 2007 to work.

Can someone tell me where I can copy and paste this code in Excel and and also more importantly, besides this line of code here (which is obvious to
me which part of the code is where the developer is telling me that I need to customize the code to specify which directory to send the "output"

'Parent Directory - Change this to whichever directory you want to use
ListFoldersAndInfo "C:\Documents and Settings\Administrator\My Documents", startRange

Is there any other part of the program besides the above obvious, where I need to "adjust/customize" to specify my personal directory of the location of the folders or where I
want the output?

Here is the program and link where it came from:

http://www.excelforum.com/excel-prog...-in-excel.html

WHERE DO I CUT AND PASTE THIS CODE BELOW IN MS EXCEL 2007???

Please Login or Register  to view this content.

PS: I know that I must follow these instructions to enable Macro's function/tab in Excel in order to work with the Macro functions in Excel:

http://www.excelforum.com/excel-prog...00#post3190300

**AndyLitch** · 04-09-2013, 10:24 AM

Hi, try the following

1. Right click on a worksheet tab
2. Select view code
............View will now switch to the VB editor.
3. Find the VBA project which has the same name as you excel file in the project explorer to the left
4. Right click on it
5. Select "Insert Module"
6. Double click on the module
7. Paste your code into it.

**arlu1201** · 04-09-2013, 10:55 AM

Welcome to the forum.

I have added code tags to your post. As per forum rule 3, you need to use them whenever you put any code in your post. Please add them in future. In order to put code tags, either type [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] at the end of it, OR you can highlight your code and click the # icon at the top of your post window.