Re: Input box

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I can't understand yoyur message

Maybe I can be a little clear
I want an input box (or something) that will give two options
one that will show a path to one folder
and also a path to another folder



"Dave Peterson" wrote:

Are you trying to open an existing file?

If yes, look at application.getopenfilename in VBA's help:


Dim WkbkName As Variant

WkbkName = Application.GetOpenFilename(filefilter:="Excel files, *.xls")

If WkbkName = False Then
Exit Sub 'user hit cancel
End If

=====
I don't have a network to test this on--you may have to type in the start of the
UNC path to be able to choose deeper levels.

If you map that path to a drive letter, it may be easier to traverse.

Oldjay wrote:

I have an input box with the following code

quotenumber = InputBox("Please enter QUOTE to recall. If you are recalling a
quote from Server3 then type in \\server3\jobs\estimate1\new_quot1\ and the
quote number", "The Auld Company", "C:\quotes\")

I would like to be able to select the another
path"\\server3\jobs\estimate1\new_quot1\" without having to type it in

oldjay

--

Dave Peterson

.

Relevant Pages

  • Re: Input box
    ... Dim WkbkName As Variant ... Oldjay wrote: ... quotenumber = InputBox("Please enter QUOTE to recall. ...
    (microsoft.public.excel.misc)
  • Re: Ping: Larry Pattis and Steve Daniels
    ... Larry thanks for pointing that out about the Ed Gerhard quote. ... Never being able to recall for sure, who, though I ... Good artists borrow. ... But I always feel great when I play. ...
    (rec.music.makers.guitar.acoustic)
  • Re: Ping: Larry Pattis and Steve Daniels
    ... Larry thanks for pointing that out about the Ed Gerhard quote. ... Never being able to recall for sure, who, though I ... Good artists borrow. ... But I always feel great when I play. ...
    (rec.music.makers.guitar.acoustic)
  • Re: Ping: Larry Pattis and Steve Daniels
    ... Larry thanks for pointing that out about the Ed Gerhard quote. ... Never being able to recall for sure, who, though I ... Good artists borrow. ... But I always feel great when I play. ...
    (rec.music.makers.guitar.acoustic)
  • Re: Ping: Larry Pattis and Steve Daniels
    ... Larry thanks for pointing that out about the Ed Gerhard quote. ... thing I want to be is plagiarizing or taking similar credit. ... I can't recall ever even knowing who Ed Gerhard was ...
    (rec.music.makers.guitar.acoustic)