Macro acts funny when more than 30 records are present

I have a macro that reorganizes data presented to me from a batch parameter query.

If that query results in MORE THAN 30 records, then when i run THE MACRO IN QUESTION, only the 1st and last record get converted to how I want it.

The attached excel macro file has the first 5 Examples OF where it wont work right. The next 2 examples show where it will work right. The last 2 examples show where it wont work (just like the 1st 5 examples), except that the last 2 examples (#8 and #9 examples), you can see what the macro gives me as the END result.

A TRUE GOOD RESULT looks like the tab CSV GPS File.

Why does the macro do this?
The macro can be played on the button "Create CSV/GPS File" on the "GPS Extraction Template" tab.

Richard, sorry for not explaining it better.

Yes I am talking about Create_CSV_Filev4().

What I am achieving with limited success (as long as there isn't more than 30 rows of data), is gathering the data from B5:G33 (Which means 28 rows of data) from the tab GPS Extraction Template.

The end result is the tab CSV GPS File. When there are too many rows of data appearing on GPS Extraction Template, the results look like the last 2 tabs (EX 8 and EX 9) from Column G to A. I put in several tab examples so that my error can be replicated. The current data on the first tab works succesfully (and many times it will, provided there isn't that many rows of data).

I hope I didn't confuse you.

Originally Posted by Richard Buttrey

Hi,

What's the macro in question? Is it the Create_CSV_Filev4() procedure or the DoBatchOfParam....

Can you talk us through it explaining in narrative what you're expecting it to do with reference back to relevant sheets/ranges/criteria. I'm not entirely sure why you'd want to use a looping macro if the aim is to extract a subset of records which can be more easily and efficiently obtained with a data filter

Richard, what do you think?

Richard, my fault. I quoted the wrong post. I meant to quote my answer to your FIRST question.

What I meant to say is... What do you think of my explanation to your FIRST question on Post #3?

Leith

First of all, my apologies for the very delayed response. I never lost sight of the work you did, but my time shifted me away from responding to the macro you made.

Second of all, thank you for the macro. It is almost complete.

When I run it, I get the following error: Compile error: Method or data member not found.
It highlights the ".Close" line of code.

Is there something wrong that I did?

I ran the new macro, and I get the following error:

Run-time error '9':
Subscript out of range.

The row

Set DstWks = Workbooks("Book1").Worksheets("CSV GPS File")

gets highlighted.

When I run the macro (yours or mine), the only open file is GPS Automation.

When I run your latest macro, do I need to have a 2nd file open already saved called Book 1 with a tab called CSV GPS File?

Yes please Leith. When i run my original macro... I have the macro make a new CSV file for me with 1 tab in it. The new tab doesn't necessarily have to be called CSV GPS File. I just thought it was convenient because my GPS AUTOMATION file has a tab in it called CSV GPS File that the MY MACRO would just copy over to A NEW CSV File.

Leith, I get the original errors from Post #1. The middle part of the Name Column (Column B) appears blank. Sorry for the delayed response. Work caught up to me.

Well Leith, thanks though anyways for your time and effort. I appreciate it. :-)