Macro to Sort a table and Save file as a CSV

**dirock** · 08-29-2012, 09:01 AM

I have a macro that manupulates data into a table. I need to cut and paste this table into a new worksheet, sort by "ticket" and save into a CSV file. See attached Table starts at line 101. Please help

**BuckoAk** · 09-02-2012, 01:05 AM

The code is assuming that the Data will always start on Row 101, if not changes will have to be made.
The Export function will export the file "Exported CSV File.csv" to your C:\ Drive, the file-name and location can be changed if you choose to do so.

Give it a try. Excel Sort and Save RevA.xlsm

**dirock** · 09-04-2012, 09:22 AM

BuckoAK, thanks this helps out a lot. However, the table location will change depending how many ACCTs there are in the data field (it will not always start at "101"). I tried implementing this code in the code you created to reference the differing location of the table but I get "Range of Object failed" response. I can't seem to figure out why this is happening?

Please Login or Register  to view this content.

Here is my code to create the table.

Please Login or Register  to view this content.

Thanks for your help!!

**Cutter** · 09-04-2012, 11:41 AM

@ dirock

Welcome to the forum.

Please notice that code tags have been added to your post(s). The forum rules require them so please keep that in mind and add them yourself whenever showing code in any of your future posts. To see instructions for applying them, click on the Forum Rules button at top of the page and read Rule #3.
Thanks.

**BuckoAk** · 09-05-2012, 01:22 AM

Here you go, this is a fully working macro.

I add a variable in your code, to pass along to the new code.
This line identifies a dynamic starting position each time.

Give it a run and let me know what you think.