Using a macro to import PRN files and format the data.

[gatorfan1991]

I have created an existing macro, but it is looking for a specific file and I want it to allow me to choose the file and then continue on with the formatting steps in the macro.

Does this sound possible?

 

[tmcfadden]

You can grab a new filename from the user by using the "Application.GetOpenFilename" function.

E.g.

strFilename = Application.GetOpenFilename

 

[gatorfan1991]

I'll try that and let you know what happens.

Thanks!

 

[gatorfan1991]

That did work, so thanks for the tip.

Is there a site anyone knows of that will put me in touch with a VB.net coder that can code this macro for me to a certain spec?