Adding a CSV file always adds an extra column

[NatalieEC]

Hello,

I wrote some code that imports csv files into an excel sheet which works fine. I wrote the macro so that if it is clicked again, new files can be imported "on top" of the old files (deleted the csv range). My new problem is that it adds a new column after the csv file which I don't want. Initially I deleted the column in my code, but it does mess up some of my calculations regardless that weren't written using vba. I have my calculations two columns over from the last column of the csv file, but every time I run my code, it adds an additional column.

How do I get it to stop adding a new column?

Thanks!

Please Login or Register  to view this content.

[NatalieEC]

I think I solved it...

In my function that clears the old csv file, I cleared the added column but didn't delete it. Why would that prevent an additional column being added?

Here is the other function

Please Login or Register  to view this content.