Modify closed csv file without open it

Hi excel and vba experts

On desktop I have csv file called 1.csv and has a column separated by comma
I wanted a code that open the csv file and modify it so as to make the column into multiple columns by comma then save the changes and close the csv file

Hi,

it could be possible … Once you well elaborate the process to be executed rather than such a guessing challenge as guessing can't be coding !

Hi Marc L sir
I thought it is clear. I attach a file (column with data and need each part between commas to be in columns)

Originally Posted by KingTamo

I thought it is clear.

So according to your 'clear' initial post my reply is just well answer to the Import Assistant when you open the file from Excel …

I didn't get your answer sir. Can you tell me most details?

Just open the file from Excel then well answer to the Import Assistant.
If you don't see any Import Assistant then rename the file as .txt and retry …

I can't see the Import Assistant. I wanted a code in another xlsm file that opens the csv and modify it to several columns then save the csv and close it

Read again post #6 but well this time …

I read it well but I don't want to import it the xlsm file.
in simple steps: the code opens the closed csv file called 1.csv - separate each data between commas to several columns - save the csv file - close the csv file

Thanks. I have searched for opentext on google and can solve the first step

Please Login or Register  to view this content.

Now I need to separate the one column to several columns and this depend at comma ,

You can use the Text To Columns Excel feature from the Data menu aka TextToColumns method under VBA, easy with the Macro Recorder …