Pops Jackson
12/17/2006 1:21:00 PM
You are right on the button. Using AvailableSpace I can write the lines
needed to trigger the msgbox and allow changing discs.
Thanks,
--
Pops Jackson
"JakeyC" wrote:
>
> Jim Jackson wrote:
> > I have searched VBA Help and this forum but cannot find any hint to what I
> > need. I have written a routine that backs up selected file types to the
> > drive chosen by the user. I found that, when including jpeg files, the CD
> > fills up rather quickly.
> >
> > The macro hung up and I was forced to re-boot to regain control. Is there
> > code that will recognize that the next file is too large for the available
> > space and allow a change of disks?
> >
> > Thanks.
> > --
> > Best wishes,
> >
> > Jim
>
> An interesting problem. I've never tried automating saving to multiple
> disks, but perhaps you could work around the problem by first knowing
> the capacity of the drive/disk, then, explicitly save each file one at
> a time, but whilst detecting their respective sizes (search for info on
> using the FileSystem object for this).
>
> As soon as you encounter a file that exceeds the remaing capacity of
> the disk, you can enter a DoEvents loop after prompting the user to
> swap the disks, then continue from the file you left off at once the
> disk is changed.
>
>