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?
 

Excel Facts

Format cells as time
Select range and press Ctrl+Shift+2 to format cells as time. (Shift 2 is the @ sign).

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?
 

Forum statistics

Threads
1,141,163
Messages
5,704,667
Members
421,361
Latest member
AJPlant

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top