Posted to microsoft.public.excel.programming
|
|
Getting a String Path from a browser...
Bob... thanks... is is certainly MUCH simpler...
Juan
-----Original Message-----
Juan,
Much shorter, much simpler.
I don't use 2002 myself, so you may need to play with
this, but this is
basically it
With Application.FileDialog(msoFileDialogFolderPicker)
.Show
MsgBox .SelectedItems(1)
End With
Look up FileDialog in the VBA help
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Juan Sanchez" wrote in
message
...
Bob...
Yes, that is what I ment. Thanks alot... I am using
it...
actually I wanted it for an Outlook macro, and it is
working fine... If you use outlook you'll know the pain
of
detaching various attachments... like when someone sends
you a bunch of pictures, I have overcome that... I
posted
in the outlook group but is not as attended as this one
and I though that VBA is VBA and somethings can work on
any program... Thanks!
I use XL2000 in the office that is where I really need
the
macros, but have XP at Home, is the folder dialog you
mention shorter and simpler that the one on the article?
can you tell me where to look so that I learn how to
code
it?... thanks in advance...
Juan
-----Original Message-----
Juan,
The GetOpen method does allow you to select a folder,
but
not just a folder.
Is that what you mean? If so, I would have given you
very
similar code to
that article. Don't worry it won't break.
If you have XL2002 or later, there is a folder browser
dialog.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the
Purbecks
(remove nothere from the email address if mailing
direct)
"Juan Sanchez" wrote in
message
...
Bob/Andy
Thanks!
Both of your suggestions work great, exept that i
need
to
get a file selected at the end... It does not allow
me
to
select a folder. I found sort of what I'm looking for
he
http://support.microsoft.com/default.aspx?
scid=kb;es;550902
its in spanish, but the code works fine... it messes
with
dll's functions and custom types and some other
stuff I
don't understand and have never used...
Simply using the code works great but I don't like to
use
things I don't understand... I never know when
they'll
fail...
If you know of something simpler to do the same I
would
appreciate it...
Regards
JS
-----Original Message-----
Take a look at the GetOpenFileName method.
--
HTH
Bob Phillips
... looking out across Poole Harbour to the
Purbecks
(remove nothere from the email address if mailing
direct)
"Juan Sanchez" wrote
in
message
...
Hi all...
Is there a way in VBA to get a path in string
format
out
of a browser dialog box?... similar to an inputbox
that
includes a *browse* button???
Any help is greatly appreciated...
Regards
Juan
.
.
.
|