Discussion Locked

Macro help

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,
I have created a command button in an Excel sheet.NOw,Im trying to write a macro such that when a user clicks the button,a browser window(similar to the 'Save as' window) must open so that the user can look for any particular files in the local directories.Could anyone help me out?

1 reply

by tink!

Just a few clarification questions:

Are you wanting to open a custom browser window?
Or open an existing Excel browser window? (i.e. Open, Save, Save As)
Or open a browser window like "My Computer"?
How much limitation are you looking to add to this window? Do you want the user to ONLY be able to look for files and not select them to open?

This discussion is closed to new replies.