Please help Looping In VBA

**shelim481** · 08-30-2018, 12:44 PM

I Have the below VBA code but i cant get it to loop every time, until "rFound" is noting, also how do i change "Const FlName" so that it would save in the same file directoy as the xlsm file but everytimes it loops i want the txt file it creates to change its name in consecutive order e.g. chunk 1.txt, chunk 2.txt?
all once "rFound" is noting i want it to say complete work

Please Login or Register  to view this content.

**6StringJazzer** · 08-30-2018, 03:59 PM

I am giving this a try but can't test it without your file.

You have a bug that I don't know how to fix because I am not sure what you are doing:

Please Login or Register  to view this content.

numRows and numColumns are not declared and never assigned a values. So they will be 0 here. I strongly recommend to everyone that they declare variables. Doing so prevents a lot of bugs and runtime errors.

Please Login or Register  to view this content.

**shelim481** · 08-30-2018, 04:18 PM

Hi, thank you for your help much appreciated, i have large amount of data but it always starts at cell E5, i want to cut the data and put it into a new sheet then exports as TXT file, finally i want to repeat this until no data is left in the original work sheet. now im getting a error at

Please Login or Register  to view this content.

run time error 76

**6StringJazzer** · 08-30-2018, 04:30 PM

What is the value of FCell when this error occurs?

**shelim481** · 08-30-2018, 04:51 PM

Now i get runtime error 91, for some reason it it starts separating each line into different sheets, it just does the first sheet correctly. but no txt files produced.

**shelim481** · 08-30-2018, 04:58 PM

Attachment 588544

all i wanted was to separate out the data into txt files of 50 columns (with no speech marks)...the data is more complicated then one attached...
I got it working with a little modification but i cant seem to get the txt files.....Any ideas?

Please Login or Register  to view this content.

I need the txt files in the same directory as the excel file, but it only works for one text file if i use

Please Login or Register  to view this content.

when i use

Please Login or Register  to view this content.

no txt files are created...

**shelim481** · 08-30-2018, 05:48 PM

Working after some thinking ....thank you very much .... just need

Please Login or Register  to view this content.

to be saved at the xlms directory any ideas?
when i change to ThisWorkbook.Path or something similar it does not do anything in the xlms file directory but adds files in the temp directory....

**6StringJazzer** · 08-30-2018, 07:56 PM

I can't help you any further without having your file. Remove any private data and attach it.

The paper clip icon does not work for attachments. Instead, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.