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?

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?

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?

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?