Import all csv files in folder to sheet1

**jlang11** · 07-21-2015, 11:30 AM

Good morning,

I am having a problem with my macro. It seems to import all the csv files in, but they paste in sporadic places instead of just column A. I like the way the msoFileDialogFilePicker and InitialView are working, just cant get the array right.

Any advice?? Thank you!

Please Login or Register  to view this content.

**Kenneth Hobson** · 07-21-2015, 11:50 AM

Replace

Please Login or Register  to view this content.

with

Please Login or Register  to view this content.

**jlang11** · 07-21-2015, 12:06 PM

Originally Posted by Kenneth Hobson

Replace

Thank you Sir!!

Import all csv files in folder to sheet1

LinkBack

Thread Tools

Rate This Thread

Display

Import all csv files in folder to sheet1

Re: Import all csv files in folder to sheet1

Re: Import all csv files in folder to sheet1

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Import values from other files in folder

Import row from a folder with .csv files

Noob 4 Help - Macro to LIST ALL FILES IN FOLDER and then IMPORT ALL LISTED FILES

How to import two .txt files into sheet1, both on column D consecutively

Looking for VBA code to import data from two csv files into Excel sheet1 and sheet2 b

[SOLVED] how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder?

[SOLVED] how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder?

[SOLVED] how can I specific a folder with wildcard criteria and excel will import all the correct files in that folder?

Bookmarks

Bookmarks

Posting Permissions