How to Extract Data using Macro?

Hi All,

I am just start learning macro and I want to create a workbook that extract data from a .cvs file locate at C:\WN-Diff.csv

Can someone guide me to the posts or website that explain the steps.

Thanks

Hi,

I beleive for your task, steps are as follows:

1. Open your VBE from Excel.
2. Insert a module.(Insert->Module)
3. Write a subroutine there.
4. In your sub, write Workbooks.Open(Your CSV file path name, n parameters)

Regards,
Gajendra Gupta

Another way is to record a macro whilst you extract the data from the csv file.

Then if you need any additional assistance post code here with details of what is required.