Hi, I am absolutely new to the world of coding and I need a simple code to do the below:
Open up files using data import from csv, (however many there are) and save files as xls. All files are saved in a central location. Can anyone please help me with the code? I have to open up so many different excel files and resave them as xls docs. these files are downloaded from a local web database and values in rows appear as "=12345"
To import I chose preferences convert text to columns, delimiters selection is other '=' sign and text qualifier is " and these selections gets rid of the "=
Thanks for looking and/or helping.
Open up files using data import from csv, (however many there are) and save files as xls. All files are saved in a central location. Can anyone please help me with the code? I have to open up so many different excel files and resave them as xls docs. these files are downloaded from a local web database and values in rows appear as "=12345"
To import I chose preferences convert text to columns, delimiters selection is other '=' sign and text qualifier is " and these selections gets rid of the "=
Thanks for looking and/or helping.
