Re: $$Excel-Macros$$ fso

Dear Rakesh, Please use below code to open file of Folder, *Sub open_all_fileoffolder() flname = Application.GetOpenFilename(MultiSelect:=True) For Each fname In flname Workbooks.Open fname Next End Sub * -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*

Re: $$Excel-Macros$$ fso

By FileSystemObject we can do operation with File and folder..Here is code for that.. Sub GetAllFilesInAFolder() Dim fso As New Scripting.FileSystemObject Dim flFIle As File Dim fdFOlder As Folder Set fdFOlder = fso.GetFolder("C:\Documents and Settings\Cyber Junction\My Documents"

Re: $$Excel-Macros$$ fso

Rakesh, Application.FileSearch has been discontinued from Excel 2007 for reasons I am still not sure why. You can find an alternative method here. http://www.ozgrid.com/forum/showthread.php?t=147929 Regards, Sam Mathai Chacko On Sat, Dec 3, 2011 at 6:20 PM, Rakesh Joshi wrote: > Hi Ashish, >

$$Excel-Macros$$ fso

Hi Ashish, i need to open all files in a folder and run the macro regarding macro i can take care but opening all files in folder i am getting trouble application .filesearch is not working 2010 coudl you please let me know how to do that. -- Rakesh Joshi -- FORUM RULES (934+ members already B

$$Excel-Macros$$ FSO

i, I am trying to write a code to do the following Retrieve last modified .xls file each folder is in a directory. example: "Project" folder has many project folders like P1,P2,P3etc Each Project folder has Budget folder in it. ie P1 has Budget folder Budget folder