Re: $$Excel-Macros$$ Help with replacing Application.FileSearch in macro

File search has been removed after 2003 Version..you may use Dir() for same task.. On Fri, Mar 25, 2011 at 2:34 AM, Dave wrote: > Hi Gurus,, > > I have the following macro that has been working fine for ages in > Excel 2003 and now is giving me "run time error 445 Object doesn't > support this

RE: $$Excel-Macros$$ Help with replacing Application.FileSearch in macro

:=f.Name End If Next f For Each d In myFolder.SubFolders FolderRead d Next d End Sub HTH Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Dave Envoyé : jeudi 24 mars 2011 22:05 À : excel-macros@googlegroups

Re: $$Excel-Macros$$ Help with replacing Application.FileSearch in macro

Ok , I added Microsoft Scripting Runtime in the refrence, its #5 in the Priority list , but the macro is still not picking up sub-directories. thanks again -- -- Some important links for excel users: 1. Follo

Re: $$Excel-Macros$$ Help with replacing Application.FileSearch in macro

How do i add Microsoft scripting run time reference to this file? thnaks -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our

Re: $$Excel-Macros$$ Help with replacing Application.FileSearch in macro

I changed the ftdpath as below my production files are on a server so have to put in the address as below, macro runs but does not traverse the sub directories Under the pdf directory below I have directories for years and than months and days. Files are in days folder. ftdpth = \\codebase1

Re: $$Excel-Macros$$ Help with replacing Application.FileSearch in macro

is it giving any errors try this code . i haven't tried it on server. always on my local desktop Sub withsubfolder() Dim fldpth As String fldpth = "ftdpth = \\codebase1\docs\pdf\" Dim r As Long ListFilesInFolder fldpth, True End Sub Sub ListFilesInFolder(SourceFolderName As Strin

Re: $$Excel-Macros$$ Help with replacing Application.FileSearch in macro

press alt f11 goto tool -> references-> select Microsoft scripting run time reference On Fri, Mar 25, 2011 at 10:33 PM, Dave wrote: > How do i add Microsoft scripting run time reference to this file? > > thnaks > -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com

Re: $$Excel-Macros$$ Help with replacing Application.FileSearch in macro

please add Microsoft scripting run time reference in the workbook also is it working on the local desktop On Fri, Mar 25, 2011 at 10:20 PM, Dave wrote: > I changed the ftdpath as below my production files are on a server so have > to put in the address as below, macro runs but does not traverse

Re: $$Excel-Macros$$ Help with replacing Application.FileSearch in macro

try the attached macro change fldpth = "D:\my latest data\" this as per ur requirement if you copy the code of( withsubfolder) to other workbook add Microsoft scripting run time reference in that workbook On Fri, Mar 25, 2011 at 6:13 PM, Dave wrote: > Ashish, > > Thanks It works great, can y

Re: $$Excel-Macros$$ Help with replacing Application.FileSearch in macro

Ashish, Thanks It works great, can you please make one change for me I want the macro to start searching from c:\temp\vba always and traverse sub-directories and not ask the operator any questions. thanks, Dave -- ---

$$Excel-Macros$$ Help with replacing Application.FileSearch in macro

Hi Gurus,, I have the following macro that has been working fine for ages in Excel 2003 and now is giving me "run time error 445 Object doesn't support this action" in Excel 2010. I need help in fixing this macro please. I have read about the "dir" method & "Application.FileSearch" methods