Save as file from .lst to .xls

[lalaarif1]

Dear Friends,

I have 350 .lst separate files.
These files are saved in a particular folder.

I need to save these files as .xls files after performing the "Delimited" action and formatting the file as per the attachment.

Is there a macro which saves these files automatically without manually opening these files.

I also need to save these file as .pdf.

Its really time consuming.

Please assist.

I am attaching the raw .csv file and output .xls file for your reference. ( consider .csv as .lst since I am not able to upload .lst file)

[lalaarif1]

Friends,

Any luck?

Please help.

[davsth]

A quick google of batch convert csv to xls vba, gives many solutions, including

Please Login or Register  to view this content.

[lalaarif1]

Thanks a ton.

Macro is working fine.
You made my day.

Cheers.

[lalaarif1]

Dear friends,

This is in continuation of above post.

Is there a macro which converts .xlsx file to pdf files.
I need to convert approx. 350 .xlsx files to pdf files.

Please help.

[alansidman]

http://analystcave.com/vba-excel-to-...-batch-export/

[lalaarif1]

Thanks a lot...

I took the macro from the link.

But little problem...

How do I do the setting of fitting all the column in 1 page by shrinking it.

Currently, column are getting divided in multiple pages.

Please help.

[alansidman]

I don't understand your question. There are no pages in Excel. Please explain in Excel terms what is happening. Perhaps a sample example of what is happening. Your explanation is lacking enough details to understand the issue.