Common Dialog files

[RSH]

We have several files generated by the common dialog box,and accessed individually by the common dialog box. However we would like also to access all of them with a command button so that we could total all of the values in one operation.
Does anyone have a way other than writing them all into code, which wouldnt work when files were changed.
73 RSH

[deghost]

if I anderstood right, why don't u create an array of strings containing the paths to your files.

Dim MyPaths(1 to 5) as string

sub fillpaths()
...
end sub

private sub command1_click()
[open file for MyPaths(1)]
[open file for MyPaths(2)]
...
[open file for MyPaths(5)]
[do whatever you want with the files]
end sub




----------
The @host is everywhere!
----------

[RSH]

Thanks DeGhost:
Will give that a try. Sounds reasonable.
If I run into bumps will be back.
73 RSH

[RSH]

On closer examination it looks like this is not exactly what I'm looking for since the files would have to be listed in code and if they were changed via the common dialog box would also have to be changed in code. Need to be able to access all files generated by the box sequentially from a command button.
73 RSH