i have this odd issue
original CSV files have data in various columns ...
if i rename the csv files to xls manually FIRST then open the file, i am able to delimit according to semi colon because apparently that manual rename moved all the data in column A
however,
if i rename the csv files to xls via VBA, the files won't open because i changed the extension using this method (sorry I forget the error messagE)
additionally,
i tried manually (and via VBA) opening the CSV files and saving as XLS, but the data is still in its original data (ie in various columns) so I can't delimit properly
...
is there a way to do this without me having to manually rename the extension?
original CSV files have data in various columns ...
if i rename the csv files to xls manually FIRST then open the file, i am able to delimit according to semi colon because apparently that manual rename moved all the data in column A
however,
if i rename the csv files to xls via VBA, the files won't open because i changed the extension using this method (sorry I forget the error messagE)
additionally,
i tried manually (and via VBA) opening the CSV files and saving as XLS, but the data is still in its original data (ie in various columns) so I can't delimit properly
...
is there a way to do this without me having to manually rename the extension?
Last edited:
