import every file in the folder and rename sheet to the imported file name

Hi, vivek_work,

according to Rule #3 from the Forum Rules please use code tags around your code for better readabilty.

If you want the sheet to be renamed without the ".prn" use the left part of the string you get without the last 4 characters:

Please Login or Register  to view this content.

Ciao,
Holger

@ vivek_work

Welcome to the forum.

Please notice that code tags have been added to your post(s). As HaHoBe pointed out the forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.

Hello guys thanks a lot it helped me to import file without the .prn name now the next step is i want to save them as text file in some folder, like suppose i keep this macro file in Folder1 and run it should save all the text file in the same (Folder1) location, and the name of text file should be same as per the worksheet here is the code i have but it saves all the text file to My Document which I dont want...

Please Login or Register  to view this content.

Once again thanks for your help...

Hi, vivek_work,

try it like this:

Please Login or Register  to view this content.

Ciao,
Holger

Hey friend thanks a lot u solved my problem but still i have to specify path to save files can u modify it so that it can save the sheets in the current folder where the macro file is kept coz this file is gona be use by many people on there computer so please modify these code in a way that it should save file in the directory where the macro file is kept

thanks in advance

Hi, vivek_work,

change this

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

Ciao,
Holger

thanks guys for ur help still my problem is unsolved actually what i want is open multiple prn files in one workbook and name each sheet as per the imported prn file name and then save in sheet in the same location with same name but in text format so i have two piece of code
1) to import multiple prn files (but problem is it imports it to new workbook)

Please Login or Register  to view this content.

2) This code is to save this file to txt format

Please Login or Register  to view this content.

can anyone of u please make a macro file with command button to import multiple .prn file and save them as text file with existing name

Hi, vivek_work,

in your code:

Please Login or Register  to view this content.

Change that to read:

Please Login or Register  to view this content.

if it´s the workbook which holds the code or

Please Login or Register  to view this content.

if you want to import into the active workbook (which may not be the workbook with the code).

Ciao,
Holger

Hi, Hi, vivek_work,,

see if this code will do what you want (code is untested):

Please Login or Register  to view this content.

Ciao,
Holger

Hi HaHoBe
thanks the code works very well thank u very much for helping me, and this site is really very helpful member are very helpful and my problem is solved very fast i didn't expected this really very nice and tallented member's are here once again thanks all for helping me and hope in future also i will get help

Vivek

just one last question the above code is working perfect but is it possible that for selecting .prn file when it opens, open dialog box can it show the current directory instead of showing the windows default path to browse for file

Hi, vivek_work,

the mistery of a solved thread and one more question (maybe you´d better taken away the solved to this thread).

Instead of

Please Login or Register  to view this content.

maybe use

Please Login or Register  to view this content.

Ciao,
Holger

Hi HaHoBe,
sorry frnd actually my query was solved so i marked it as solved and i thought about the last question at the end so just for my knowledge i asked that question thank u for solving it, really this site is very nice thank u so much i will post any threat if i need any help hope u will always help me

Sorry frnd i tried it now and found that this code is not working

Please Login or Register  to view this content.