Button to allow user to browse, select and import CSV file

Hello forum,
I have a question i hope some of you might be able to help me with.

I have a document where i would like to import a CSV file.
I would like to be able to push a button "Import CSV" and get a browse window where i can locate the file i want to import and then import it.

I made a recording of a macro where i use the import CSV function and then adjusts the rows/colums and was hoping to use this after the file is selected.

The macro inserts the csv in to the excel, deletes an column that empty, removes the 4 first lines in the csv file and renames the column title.

Please Login or Register  to view this content.

Im not locked in to this solution. If you know of a better way where i can click a button, get a browse window to select my file and import the contens in to my worksheet im all ears :-) the CSV file differs in rows. one fil might have 4000 rows another might have 15000 rows but the 12 columns will always be the same.

Best regards
Joachim

Hi there,

I'm not too familiar with the approach you're using, but see if the following (totally different) approach get you moving in the right direction:

Please Login or Register  to view this content.

The highlighted values may be changed to suit your requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M

Hi Greg, sorry for the delayed reply.
I likte the setup. Very clean. but i get an error #I/T in the last two columns.

Got any idea why?

I will try to investigate more, liked you apporach.

Hi again,

I'm not sure exactly what you mean when you say:

but i get an error #I/T in the last two columns

Is there any chance you could post a small sample of your raw data and of the processed data so that I can understand your situation better?

Regards,

Greg M