Macro loop for "text to columns"

Hi everybody,

Part of the problem I am going to present might sound trivial, but..
I am trying to run a macro that for a series of sheets in a file should erase some columns and then separate in different columns the text one column (N) by when a semicolumn is present. I tried like this:

Please Login or Register  to view this content.

This has a first major problem: the command "text to column" seems not to loop among files.

The second problem is not very important but: the different sheets are originally different files in a folder. Do I need always to group them together in the same file or there is an efficient way to loop across files directly in the folder?

Thank you for any help,

Stefano

You aren't using wks within the loop for the ranges.

That can be fixed with some well placed dots.

Please Login or Register  to view this content.

Thanks for the quick reply!
yes, the same colums have to be deleted in all the files.
Is the separetion of text in columns more problematic.
(And, how can I loop through files?)
Cheers,
Stefano

Wow, this would be like the simple solution that seemed to be so difficult to find.
I'll try right now!
Thanks!

I'm sorry to ask.. but could I have an hint about how to do it?
If it is to time consuming to show, I'll try to document myself better (although I have already tried)
and continue with the solution by Norie.
Thanks,
Stefano

Stefano

arlette is right, I think perhaps I misread your post.

If you do have multiple files you want to run the code on you'll need to give us more information.

eg where are the files located, which sheets in the files should the code run on

Great, thanks.. well
1. the files are located in a folder; specifically with address:

C:\Users\baruffal\Dropbox\Progetto_eth_epfl (3)\RAW_DATA\RAW_PUBS\Pubs_Stefano\Professors

the code should run only on the first sheet of the files.

Try this.

Please Login or Register  to view this content.

Great!
Thank you very much to both!