Importing a user defined CSV file

[bwhyte21]

(from this thread)

I suppose this is how I would change my macro then, I've added a second separate function that presents a dialog box to select a CSV file to add to your workbook. Keep selecting files, press Cancel when done to end the loop.

Please Login or Register  to view this content.

IN the GetFileName function, you can remove the .InitialFileName line if you don't want to control where the dialog box starts each time.

Hello! I am in a similar predicament with importing csv files to a separate spreadsheet, BUT, I am looking to import just one csv file to a new spreadsheet. Would I just exclude the loop from the code. My current project has the gives the user a choice to either open/import a selected csv file into a currently active spreadsheet(appending it to the buttom of current text or an empty spreadsheet) or import a selected csv file into a fresh spreadsheet in the same active workbook. My project currently has the ability to append a selected csv to the currently active sheet. Thanks in advance!

[JBeaucaire]

You keep referring to "your current project". Care to share the code for that workbook?

[bwhyte21]

Sure thing. The chunk of code is for the buttons and the second chunk is for the userform.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[bwhyte21]

Ok so I figured it out! This is my new code

Please Login or Register  to view this content.

Thank you for your time! :D

[arlu1201]

Please mark your thread as Solved.

Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.