I am having trouble trying to build a macro to help with posting 800 records to SharePoint.
Can you provide some more information? Is this a SharePoint List that you are writing to? Is this just a file that you are looking to have saved? Are you receiving any errors?
If you are using the SharePoint List Output tool it shouldn't have any issues with 800 records without making a macro: https://help.alteryx.com/current/designer/sharepoint-list-output-tool
1. I had a list that had names listed as text versus using the people field.
2. I converted the text to the proper naming convention for our email system
3. I created the new people fields to be able to receive the updated fields
4. I removed any of the calculated fields from the list prior to posting
5. I set up the first 100 as delete and append; each of the other buckets had a max of 100 records. I also added block until done tool for each group of three
The list will only populate the first 100 and sporadically a few from each subsequent SharePoint List Output.