A macro used to migrate data from a csv file into ms excel 2007

[wedd]

Hi, I was wondering if it was possible to create a macro button that was able to retrieve data from a csv and when clicked auto-populate the data within the csv file (excel formatted spreadsheet) onto a blank worksheet worksheet? Can this be done? If so, how? I currently have a text file wizard option that previews the csv file when I click on the macro button I created, but doesn't auto populate the figures onto the spreadsheet. Any reasons why this is happening???


Thanks for your contributions

[Bob Phillips]

Just import it in Excel with the macro recorder on.

[wedd]

Is their a difference using a macro recorder compared to code? I was always advised to use code when creating a macro, purely on the basis of efficiency.

[Aussiebear]

XLD's suggestion will allow you to record your normal steps undertaken. Once this is done post the code here so we can adjust if necessary.