Just for added clarity:
GetOpenFilename just returns the name (fully qualified with path) of the
file selected - it doesn't open it. The user can select any type of file.
(if multiselect is set to true, it returns an array of filenames selected by
the user).
--
Regards,
Tom Ogilvy
";-)" wrote in message
...
Wouldn't this open an excel sheet? I need to get a data file name.
"Tim Williams" <saxifrax@pacbell*dot*net wrote in message
...
application.getopenfilename
tim
";-)" wrote in message
...
I developed a Excel sheet on my home PC, XP pro, Office XP, VB 6
installed
too.
The sheet works fine on my system.
I have one user form that opens when opened. I use a reference to
comdlg32.ocx (MS Common Dialog Control Version 6.0) to allow me to
have
a
file selection tool.
On the client system (large Corp) Win 2K, Office 2000. I can't get it
to
work. I even copied all parts over as text and recreated the Sheet.
On
the
client system, If I don't set the "References" first when I add this
control
to the tool bar I get a control that is named "Unknown". If I set the
Reference first, then add to control, it looks fine. When I run it I
get
an
unlicensed control error.
I have also noticed that after fighting this problem the system as
lost
the
ability to open any of the older excel sheets.
SO can I use this OCX with out loading VB 6 on it? Is there a "legal"
control that does the same thing? Will I have to reload Office to fix
the
functioning of the older sheets?