User dialogue to browse folers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm trying to modify a VB6 program (macro) that can run a user dialog, allow
the user to browse the network to find paths, and then, having selected one,
pull the path string back into my macro. I have found documentation on the
Shell function to do this, but it's not a command that's supported with VBA
that I have. Is there a straightforward way to do this in VBA from an Excel
spreadsheet?
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

File Open Dialogue Box to a Specified Location 1
How to browse folder and open xls file automatically in vba? 6
What are the steps to fix damaged MDF files in SQL Server? 0
Trouble Installing Excel VBA Code Cleaner into Office 365 0
Browse up to file 1
Saving to "MyDocuments" on users computer 5
Macro to Insert Object with browsing ability 4
Don't want to hard-code file name in macro 3

Back
Top