Asking vba macro excel

[dolphino]

hi all member,
My name is Yaman but i use dolphino for user name in this forum,iam from indonesia, until now I work in on of private bank in indonesia, every month I checked the data end of the month for the banking report. I want to use excel macro to simplify my work. Allow me to asking with u about :

1. How and what VBA syntax we use if we want to process the data from csv file and line number of the file exceeds the capacity Ms.Excel (more than 1,500,000). I want to break down the contents of the file into multiple sheets ?
2. How and what VBA syntax we can use if we want to process the data from csv file where there are multiple csv files (each file has a number of different lines) and the files we will combine into 1 in the excel sheet?

Please, kindly help me for this question
Thank you

 

[Matt Allington]

Hello Yaman

you need to research Power Query. This tool will do both things you need without vba code.

Check out this post. Consolidate Multiple Excel Files in SharePoint using PowerQuery - Excelerator BI for information about consolidating files. Check the latest link to Chris's blog.

 

[dolphino]

Morning Matt
sorry, i just see your reply about my question. i see from your link Excelerator CBS. i'll try to check for this post. thank you for your inform. if any qustion again, might i to ask with you..

Thank you Matt

-Dolphino

 

[dolphino]

Hi Mitt,
About your information, Microsoft Power Query is an add in on ms.excel right? i use office 2010. Unfortunelly for me, I cann’t download it to install in my PC on my workplace. Because has been blocked by my security administrator. Any other method for me about my question in last day? If any, may I get the information from you. Thank you Mitt,