Import CSV Into Worksheet

[MattVoz]

Good evening. I have searched the internet far and wide and have not found a solution to my problem. I am confident there is one out there, but I can't find it.

I need a macro to do this:

Open a '.csv' file. I will know the path the file is saved, but I do NOT know the file name. I need the macro to allow me to select the file from the path provided.
Import the data from the '.csv' file to the 'mc' worksheet from the original workbook. The original workbook will always have the same filename if that is needed to activate it.
Close the '.csv' file

I am very thankful for any help provided.

Matt

[ranman256]

paste the code into a module,
change the start path to yours: Const kDIR = "c:\temp\"
then make a button to run: ImportCsv

Please Login or Register  to view this content.

[JEC.]

To keep it simple and to paste the CSV directly in sheet1 of your source file.
Only change your folderpath in the macro below

Please Login or Register  to view this content.