I am using a combination of an RPA Client another with a third party database and VBA to create a full program to free up time for other tasks
I use the RPA client to call on the Macros at different times during the process. That is why there are four different macros stored in this workbook.
The current issue I have is i keep getting an "Out of Memory Error" as I try to edit and add portions to this process.
IE ) I tried to add CutCopy = False to the program just to clear the clipboard and I am getting the error and i cannot add the code line.
I am not the most efficient at VBA, so does anyone see why i would be getting this issue?
Quick rundown of the full process
Use RPA to open the Excel File
1 - use ClearContents Macro to delete all Data on Data Input page
2 - use RPA client and third party database to copy 150K records to excel file
3 - Use RPA to call on Macros
This macro clears contents and deletes all rows from the main Import sheet so new data can be pasted
This macro formats all rows and columns to autofit. The data from the third party database will paste awkwardly.
This macro also deletes any duplicate header rows copied over.
Ths macro also copies which database the data came from if a given value is null
This macro does the following
Copies blank IDs to a new sheet
Copies Blank Secondary Ids to a different new sheet
Copies two columns of Ids and paste unique values to a new sheet.
Writes formula to Count the number of times those values appear.
paste formula as values.
Hopefully this all makes sense and if any more information is needed I can try to provide.