I've been trying to automate some weekly reporting
I've managed to write up some VBA in Business Objects (SAP) that refreshes multiple reports and saves them as text files.
Now i need to copy these text files and paste them into existing workbooks.
I tried integrating this into my VBA in Business Objects however kept on running into an error.
I was thinking of creating a bacth file to do this instead, but haven't managed to do it successfully.
Does anyone have a basic script that i can use to copy a text file and paste it into an existing excel workbook?