Upload Data to be selected using BROWSE option

Hi elaph

You'll need to define your requirements a bit more. The best way to do that is to show us what you have and what you wish it to be...and the best way to do that is to attach a Sample File.

Please attach a sample workbook the Structure of which is the same as your actual workbook.

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

INCLUDE ANY CODE YOU'RE USING OR HAVE TRIED.

Remember to desensitize the data.

To do this, click on Go Advanced (below the Edit Window) while you are composing a reply, then scroll down to and click on Manage Attachments and the Upload window will open. Click on Browse and navigate to (and double-click) the file icon that you want to attach, then click on Upload and Close this Window to return to the Edit window. When you have finished composing your post, click on Submit Post.

Hi elaph

Try this Code in the attached...change this Line of Code to change the Start Folder in which to Browse for Data.xlsx...

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Hi elaph

You're welcome...glad I could help. Thanks for the Rep.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Is there any e-book or something to learn VBA

Anything by John Walkenbach is worthwhile.

Hi elaph

Sure...let me know...

I will require your assistance in the coming weeks. Hope you will assist