PDA

View Full Version : A macro used to migrate data from a csv file into ms excel 2007



wedd
11-18-2010, 01:29 AM
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???:help


Thanks for your contributions:friends:

Bob Phillips
11-18-2010, 01:36 AM
Just import it in Excel with the macro recorder on.

wedd
11-18-2010, 03:05 AM
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
11-18-2010, 03:07 AM
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.