Hi -
I need to create a user form that imports a .CSV file, then allows the
user to scroll through the imported records and display the selected
record(s) individually on a report (with chart) on a second user form.
I have the import of a constant file name partially working, but I want
to offer the user the standard Windows feature "enter the file name or
click the Browse button to select a file". I believe I need to use a
standard Windows component in VBA to do this, but can't find the right
component (nor the time to figure this all out by my deadline). The
files are coming from a Pocket PC, so ideally the Browse capability
would drill through the ActiveSync connection and allow access to the
files which are stored in a folder within the Program Files directory
(a system folder). Without the browse capability to the Pocket PC, I
plan to have the users drag the .CSV file from the Pocket PC to a place
on their hard drive (or go to the Pocket PC backup file), where the
selection method above would pull them in.

Any help would be very much appreciated. I'll submit another post for
the functionality for multi-select and scroll through the selected
records.
Thanks in advance,
Brett Strouss
bstrouss at sensoryarts.com
http://www.pockethearo.com



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/