How Do I Select a File From The Server?

  • Thread starter Thread starter Kenji
  • Start date Start date
K

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
 
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"
 
Back
Top