Originally Posted by
Mariusz()
I have the code which opens hundreds of csv files and move the sheets to the main file (noticed it was the most efficient way unless I am wrong), then convert text to column
Usually that no needs to open a csv file, to move the sheet in the main file and to convert text to columns
as all this stuff can be achieve at once via a QueryTable ! …
Originally Posted by
Mariusz()
The problem is that excel calculates each newly opened csv file
It can't calculate anything as a csv does not contain any formula but data only ! …
Just use the ISREF worksheet function for example to check if a sheet already exists,
if yes just clear data if necessary and if not create it …
Bookmarks