View Single Post
  #16   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default How to get the current path

Stefan,
I still don't see how "MsgBox (FileListBox.Path)" tells you anything about
the StartIn setting of a short cut, but this may help:
http://www.vbaccelerator.com/home/Vb...ts/article.asp

NickHK

"Stefan Mueller" wrote in message
ups.com...
You understood me wrong.
I just want to mention that in real VB I can get the information
entered in 'Start in:' of a shortcut with a FileListBox:
MsgBox (FileListBox.Path)

Unfortunately VBA doesn't have a FileListBox and therefore I'm looking
for another way to get this information.