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.
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
Bookmarks