Hi all,

I am wondering if anybody could help with creating a macro that lets the user choose a CSV file to import into a worksheet.

I have done a bit of research and it seems that Mac Office has a bit of trouble with GetOpenFilename or Application.FileDialog(msoFileDialogFilePicker)

When I record the macro of just importing one particular csv I get:
Please Login or Register  to view this content.
This is just a for a specific csv file and what I would like to do is have the user be able to choose the file and then the import happen with the parameters needed into the active worksheet.

I have tinkered around with some things I have found and came up with a macro that does give a prompt:

Please Login or Register  to view this content.
Once the prompt is given on this macro and the user selects the csv, it imports the csv into a completely new workbook and does not apply the delimiters.

How can I tailor the above macro to import into the active worksheet and also maintain the delimiters?

thanks in advance!