Re: Open find file dialog multiple files
- From: "Magius00" <Magius00@xxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Wed, 4 May 2005 11:36:02 -0700
Aye have been thinking along the same lines. What i'm working on is the data
from a system called ip accounting it makes a text file every 5 mins with
what ip address's. As you can imagine it makes a lot of files over 24 hours
(288).
As the user needs to be able to browse to the files as the name's change a
lot i was wondering if there was anyway to keep this as a string or array
within the Code but if i can get it to cyccle through whats in the folder and
add the file name which can then be used to generate thew file details i'll
give it a go.
Of course if anyone has any other ideas on how to do this i'd be very
greatful.
"Nick" wrote:
> WOW 200 - 300 files... what the heck are you working on?? :o)
>
> In tha past I have used a list of file names in a worksheet (as the files
> stay the same each time).
> Then I run a macro which loops through the list and opens the file. So each
> time you are opening one one file at a time.
> That way you don't run out of space in your filename string.
>
> Nick
>
> "Magius00" <Magius00@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:68A97CB7-A9FC-42AA-B16E-0B86AF99AE70@xxxxxxxxxxxxxxxx
> > When opening multiple files with the find file dialog (can't re,ber exact
> > dialog as on wrong computer). The only problem i get is I am wanting to
> > selct
> > around 200-300 files to work on. The method i have works fine for about 20
> > files but any more than that and the string it stores the files as gets to
> > big. I was wondering if anyone had ideas to a way around this or to get
> > the
> > dialog to store it as an array from the start. Any soultion either for
> > ofiice
> > 2003 or office 97 would be great help.
>
>
>
.
- Follow-Ups:
- Re: Open find file dialog multiple files
- From: Nick
- Re: Open find file dialog multiple files
- References:
- Open find file dialog multiple files
- From: Magius00
- Re: Open find file dialog multiple files
- From: Nick
- Open find file dialog multiple files
- Prev by Date: Get a value out off a chart just by a mouse click
- Next by Date: Re: Duplicate date from cell above
- Previous by thread: Re: Open find file dialog multiple files
- Next by thread: Re: Open find file dialog multiple files
- Index(es):
Relevant Pages
|