Excel add-in

Chas9 · 05-05-2008, 12:08 PM

I am trying to find an Excel add-in called "dirctory.xla". This file allows using Excel to capture the contents of a folder or directory which will display the folder or drive name, file name and several attributes. I have a copy of this dirctory.xla but it only works on Excel 97 and 2000. I am now using Excel 2003, where it does not work. I have googled it several times and did find a place to download it for $9.90, if memory serves me but again it does not work so have not paid for it even though the site says it is shareware and will work for a short period. The Microsoft web site comes up with a macro that is supposed to do the same thing but again that does not work. I get the following error message when an attempt is made.

Rin-Time 429
Active X component can't create object

**Glaswegian** · 05-05-2008, 02:24 PM

Hi

Ivan Moala has a sample workbook here which should provide the info you need.

Chas9 · 05-05-2008, 10:17 PM

Thanks for the reply, however did not find any thing at the site you suggested, nothing about an add-in that reports within Excel the contents of the folder of choice including sub folders and all files in those folders. The file directory.xla did do that when I was using an older Office program.

**Glaswegian** · 05-06-2008, 05:15 AM

When the page I linked to opens, scroll down and you'll see a list of file properties that are extracted. Then look for the "Get workbook here" link. I don't think it's an Add-In, more a workbook with sample code that you can experiment with.

Chas9 · 05-06-2008, 11:06 AM

Thanks for the suggestion, However I have tried numerous code snipits, non of which worked, I will go back and try the snipped you are suggesting but based on the others, including one from the Microsoft web site which did not work. I Left a message in that area as well.

**Glaswegian** · 05-06-2008, 02:42 PM

If you cannot get the code to work, you might want to try one of the specialised Excel sites, such as

http://www.mrexcel.com/forum/forumdisplay.php?f=10
http://www.vbaexpress.com/forum/forumdisplay.php?f=17

05-05-2008, 12:08 PM	#1 (permalink)
Chas9 Registered User Join Date: May 2007 Posts: 37 OS: windows xp pro	Excel add-in I am trying to find an Excel add-in called "dirctory.xla". This file allows using Excel to capture the contents of a folder or directory which will display the folder or drive name, file name and several attributes. I have a copy of this dirctory.xla but it only works on Excel 97 and 2000. I am now using Excel 2003, where it does not work. I have googled it several times and did find a place to download it for $9.90, if memory serves me but again it does not work so have not paid for it even though the site says it is shareware and will work for a short period. The Microsoft web site comes up with a macro that is supposed to do the same thing but again that does not work. I get the following error message when an attempt is made. Rin-Time 429 Active X component can't create object

05-05-2008, 02:24 PM	#2 (permalink)
Glaswegian Moderator/ Rangemaster TSF Academy; Analyst, Security Team; Oor Wullie; TSF Surgeon and Resident Comic Join Date: Sep 2005 Location: Glasgow Posts: 20,276 OS: Win XP Pro SP3 My System Blog Entries: 9	Re: Excel add-in Hi Ivan Moala has a sample workbook here which should provide the info you need. __________________ Iain - Defender of the Haggis and all things Scottish. I don't help by PM - post in the Forums. Ad-Aware::SpywareBlaster::SpyBot::SpywareGuard::SnoopFree::AVG Free::HOSTS File::HijackThis::Donate::5 Steps For Infected PCs

05-05-2008, 10:17 PM	#3 (permalink)
Chas9 Registered User Join Date: May 2007 Posts: 37 OS: windows xp pro	Re: Excel add-in Thanks for the reply, however did not find any thing at the site you suggested, nothing about an add-in that reports within Excel the contents of the folder of choice including sub folders and all files in those folders. The file directory.xla did do that when I was using an older Office program.

05-06-2008, 05:15 AM	#4 (permalink)
Glaswegian Moderator/ Rangemaster TSF Academy; Analyst, Security Team; Oor Wullie; TSF Surgeon and Resident Comic Join Date: Sep 2005 Location: Glasgow Posts: 20,276 OS: Win XP Pro SP3 My System Blog Entries: 9	Re: Excel add-in When the page I linked to opens, scroll down and you'll see a list of file properties that are extracted. Then look for the "Get workbook here" link. I don't think it's an Add-In, more a workbook with sample code that you can experiment with. __________________ Iain - Defender of the Haggis and all things Scottish. I don't help by PM - post in the Forums. Ad-Aware::SpywareBlaster::SpyBot::SpywareGuard::SnoopFree::AVG Free::HOSTS File::HijackThis::Donate::5 Steps For Infected PCs

05-06-2008, 11:06 AM	#5 (permalink)
Chas9 Registered User Join Date: May 2007 Posts: 37 OS: windows xp pro	Re: Excel add-in Thanks for the suggestion, However I have tried numerous code snipits, non of which worked, I will go back and try the snipped you are suggesting but based on the others, including one from the Microsoft web site which did not work. I Left a message in that area as well.

05-06-2008, 02:42 PM	#6 (permalink)
Glaswegian Moderator/ Rangemaster TSF Academy; Analyst, Security Team; Oor Wullie; TSF Surgeon and Resident Comic Join Date: Sep 2005 Location: Glasgow Posts: 20,276 OS: Win XP Pro SP3 My System Blog Entries: 9	Re: Excel add-in If you cannot get the code to work, you might want to try one of the specialised Excel sites, such as http://www.mrexcel.com/forum/forumdisplay.php?f=10 http://www.vbaexpress.com/forum/forumdisplay.php?f=17 __________________ Iain - Defender of the Haggis and all things Scottish. I don't help by PM - post in the Forums. Ad-Aware::SpywareBlaster::SpyBot::SpywareGuard::SnoopFree::AVG Free::HOSTS File::HijackThis::Donate::5 Steps For Infected PCs