Jump to content
Please Use CODE Tags

Excel VBA

Darkscooty
By Darkscooty
in Programming
 Share
Posted

Hope you can help I am in the middle of writing a macro for excel but need help with the picking file location manually not having the designate the location in my macro. Any help please?

- Darkscooty - AKA: George or Scooty -

Link to comment
Share on other sites
Link to post
Share on other sites
Posted

You could use Application.Dialogs(), specifying msoFileDialogFolderPicker, msoFileDialogOpen or msoFileDialogSaveAs for example, depending on your need... or then perhaps place a path inside of an Excel cell/named range instead so it isn't hardcoded as 2 options.

Link to comment
Share on other sites
Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing Programming

×