How to Dynamically Create Tables(Create A New Table With A Different Name each loop)?

[Crunch]

Hi

I have a lot of data which is thousands of lines long in a table.
I want to break this data up into sections so It's easier to deal with.

I am wondering is their a way to create a new table with a variable name every time I loop through a script?

At the moment I get the error message No such macro in macro base when I try the following

 

[bigcajones]

Did you try using a file name of .xlsx in the File path instead of .txt?

 

[Crunch]

Did you try using a file name of .xlsx in the File path instead of .txt?

Tried Didn't Work
Thanks though!