View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Dick Kusleika Dick Kusleika is offline
external usenet poster
 
Posts: 179
Default EXCEL USERFORM

Gary

You should consider using the GetOpenFileName method instead of trying to
program all this stuff yourself. It won't give you quite the interface
you're looking for, but it will save you hours of programming. Check it out
in help.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"Gary Burke" wrote in message
...

Thanks guys, that works great. However, would like to expand the code
now to do 2 things.

1. List folders, so that the user can change the active folder, and
refresh the list of files.

2. Allow the user to do something with the selected file/folder. What
code would i use, to say insert the selected file at a given location
(ie how do i reference the selected file), and what code would I use to
change the folder, if the user selected a folder instead of a file ?

Maybe the checkbox concept was the wrong way, or maybe there is a better
way ???

Thanks in advance.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!