Re: $$Excel-Macros$$ Opening All excel workbook one by one hen running the code

oglegroups.com >Sent: Thursday, 15 December 2011 8:12 PM >Subject: Re: $$Excel-Macros$$ Opening All excel workbook one by one hen >running the code > > >Sub getfilen() >'* to get file names in folder >Dim fldpath >Dim fld, fil As Object > >Appli

Re: $$Excel-Macros$$ Opening All excel workbook one by one hen running the code

Sub getfilen() '* to get file names in folder Dim fldpath Dim fld, fil As Object Application.FileDialog(msoFileDialogFolderPicker).Title = "Choose Folder" Application.FileDialog(msoFileDialogFolderPicker).Show fldpath = Application.FileDialog(msoFileDialogFolderPicker).Selected

$$Excel-Macros$$ Opening All excel workbook one by one hen running the code

Hello Ashish, i need a help regarding the open all the excel file one by one and then running the macro. regarding macro i will take care so please suggest me any code for opening the all fiel please dont suggest application.file search becouse i m using 2010 as its wont work in that. i dont kno