Import CSV file into Excel

[Jovillanueva]

Hi,

I have a requirements to automate capturing or importing CSV file generated by SSRS and copy those records into an EXCEL File.
This Excel File, I will be using this for Dashboard and will be pointing to a powerpoint. this will be displayed in LCD monitor.
Can you help me guys if this is doable.

Btw, The SSRS file CSV formatted output is save in a network folder. This is composed of 25 columns with more than 10,000 rows or records. i need to filter those records by LineID.

Your help is very much appreciated. thanks you.

[JBeaucaire]

'CSVs To One Sheet (Stacked)
A macro for importing all CSV files in a folder into a single Excel sheet, each CSV filename will be listed on the sheet next to the data that it came from.

CSVs to 1 Sheet - Part 1

'SHEET1 TO MANY SHEETS
Here's a macro for parsing rows of data from one sheet to many sheets named for the same values in a specific column. (like your LineID)

Sheet1 to Many Sheets

It not only can parse the rows, it can create the sheets if they are missing. There is a sample sheet there where you can test this out.

[Jovillanueva]

Thanks for your reply. I'll try this one. Is this working without any user intervention?
I'm newbie in VBA Macro.

[JBeaucaire]

THe macros are meant for you to use as a basis for your own... they are fully commented to help you understand what each line does. Yes, once you activate the macro it runs to completion with no user interaction, thus you'll need spend time reading and understanding them so you can make the changes needed to use them in your environment.