Copy from CSV to Workbook sheet1

[Luke777]

Hi,

I've written code to select a CSV file an open it. All I want to do now is copy the entirety of the only sheet in the CSV (I've set the CSV to wb2, is that an issue?) to wb1.Sheet1.Range("A1").

I've got far enough to have the files open side by side, but I've tried a few copy paste methods that don't seem to be working. Is this something to do with my syntax or is there something fundamentally different about CSV to XLSM copy and pastes?

Thanks

 

[ExcelToDAX]

Have you thought about using Power Query to get the CSV file into your Excel sheet? That should make it a little less complicated.

 

[Luke777]

Have you thought about using Power Query to get the CSV file into your Excel sheet? That should make it a little less complicated.

I have - is it possible to get the file to import as not a table (just means i have to convert to range and remove headers)? I just want the data... I've got code already doing a lot of manipulating once its arrived (deleting unnecessary data, data validation etc)

 

[ExcelToDAX]

you can have it load as a table, and then use Excel functions to get the tables without the headers and it will spill the data.

 

[Luke777]

you can have it load as a table, and then use Excel functions to get the tables without the headers and it will spill the data.

I don't really understand why that would be simpler than opening the CSV and copy pasting the data, especially as I'm specifying the file through VBA using Application.FileDialog(msoFileDialogFilePicker)

 

[ExcelToDAX]

Because you have to open the file and manually copy and paste which causes room for error. Power Query will get exactly what you need in a click of a button