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
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,
>
>
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
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