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

gatorfan1991

New Member
Joined
Oct 17, 2006
Messages
3
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?
 

Some videos you may like

Excel Facts

Last used cell?
Press Ctrl+End to move to what Excel thinks is the last used cell.

tmcfadden

Board Regular
Joined
Aug 17, 2005
Messages
151
You can grab a new filename from the user by using the "Application.GetOpenFilename" function.

E.g.
Code:
strFilename = Application.GetOpenFilename
 

gatorfan1991

New Member
Joined
Oct 17, 2006
Messages
3
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?
 

Watch MrExcel Video

Forum statistics

Threads
1,111,910
Messages
5,541,542
Members
410,549
Latest member
Anaarchie
Top