How Do I Select a File From The Server?

[Kenji]

Within VBA code, I would like to popup a screen so the user can select a
file from his computer and VBA knows what it is.

I tried using Common Dialog Box, but I found that many Office users did not
have this library.

What can I do?

Kenji

 

[Andy Wiggins]

Here's a piece of code from Excel's Help file:

fileToOpen = Application.GetOpenFilename("Text Files (*.txt), *.txt")
If fileToOpen <> False Then
MsgBox "Open " & fileToOpen
End If


--
Regards
Andy Wiggins
www.BygSoftware.com
Home of "Save and BackUp",
"The Excel Auditor" and "Byg Tools for VBA"