Macro to browse for text file and then format it

[RH4]

I have a standard text file report of a financial statement that I would like to open in Excel and then format. Each row has a description and then several columns of numbers. I recorded the macro to do this but it embeds the name of the specific file I pointed to when recording it. I'd like the macro to prompt me for a file to open. Then once I select a file, the macro would proceed with the formatting.

[jaslake]

Hi RH4

Welcome to the Forum!

Please post the Recorded Code so we can "see" what it is you're trying to do. Be sure to use Code Tags.

Also, it'll be extremely helpful if you post the Text File you're attempting to Import and Format. Change proprietary information.

To Attach a File:

1. Click on Go Advanced
2. In the frame Attach Files you will see the button Manage Attachments
3. Click the button.
4. A new window will open titled Manage Attachments - Excel Forum.
5. Click the "Add Files"... button to locate your file for uploading.
6. This will open a new window File Upload...Click "Select Files"
7. Once you have located the file to upload click the Open button. This window will close.
8. You are now back in the Manage Attachments - Excel Forum window.
9. Click the "Upload Files" button and wait until the file has uploaded.
10. Click the "Done" Button.

[lokicl]

Hi RH4,

Use the below code:
__________________________________
Ipath = Application.GetOpenFilename("Text File (*.txt), *.txt")
If Ipath = "False" Then
Exit Sub
End If
______________________________________

You will be able to browse and pick the file. Then use the Set property to set the Ipath value as text and load in the values. Use your routine format program.

Regards,
Loki

[Alf]

I'd like the macro to prompt me for a file to open.

Try adding this code snippet at the begining of your macro:

Please Login or Register  to view this content.

Alf