How to insert FileDialog option into recorded code

**MadYowie** · 10-03-2018, 08:12 AM

Hi All

Recorded the following code to import a text file, but how can I insert a FileDialog box so I can manually select the file I want to import.

Thanks for the assistance.

Please Login or Register  to view this content.

**6StringJazzer** · 10-03-2018, 09:58 AM

Can't test this without your files, but I tested the file name retrieval part:

Please Login or Register  to view this content.

**MadYowie** · 10-04-2018, 06:27 AM

Many Thanks

Updated code worked perfectly.

How to insert FileDialog option into recorded code

LinkBack

Thread Tools

Rate This Thread

Display

How to insert FileDialog option into recorded code

Re: How to insert FileDialog option into recorded code

Re: How to insert FileDialog option into recorded code

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] How to add INSERT ROW option with below code.

Unable to incorporate a recorded code in a bigger code

Use code instead of recorded macro

Need to insert rows in between list of names and include averages for values recorded

Replace Macro recorded code with more effective code

Simplify recorded code

Mod macro recorded code

Bookmarks

Bookmarks

Posting Permissions