$$Excel-Macros$$ Re: Running a sub through sub directories

2008-11-11 Thread Howy
e loops through the files, it stores the subdirectory names in an array named Dirs. When no more files are found, the procedure calls itself using an entry in the Dirs array for its argument. When all of the directories in the Dirs array have been processed, the procedure ends. Because the RecursiveD

$$Excel-Macros$$ Re: How can i print a range of worksheets from workbooks in a directory

2008-11-10 Thread Howy
st > > > activeworkbook.close SaveChanges:=False > > Hope this works. You need not combine the two functions, rather use both of > them. > > Akhilesh Kumar Karna > > On Fri, Nov 7, 2008 at 9:39 AM, Howy <[EMAIL PROTECTED]> wrote: > > > Hi there, > >

$$Excel-Macros$$ Running a sub through sub directories

2008-11-10 Thread Howy
Hi Everybody, I've written some code which prints worksheets were a range is not empty for each workbook in a directory. As below. I'd like to use the getdirectory to choose the root directory. then run the Printworkbooks(spath) for each directory below it. e.g. all it's sub directories. I've ha

$$Excel-Macros$$ How can i print a range of worksheets from workbooks in a directory

2008-11-06 Thread Howy
Hi there, I have a timesheet spreadsheet i have designed, for each employee they have a workbook. in a directory and subdirectories by there pay location. I would like to create a macro in a new workbook. Which asks the path the workbooks are in then prints the worksheets if data exists in a ran