I am creating a database where a number of spreadsheet reports are produced. I want to get all these reports together on a template sheet with a main menu so they are presentable for customers. Each report is copied to different sheets in the main spreadsheet.
I want to copy the reports into the main spreadsheet using Excel macro code inside Access. This seems to be fine except that when I select the relevant data from a report, copy it to the clipboard and then change across to the main spreadsheet window to paste the data, the check message "You have copied a large amount of data to the clipboard. Do you wish to save it to use elsewhere?" appears. This interupts the code and causes it to error. Does anyone know another way of doing the above or how to temporarily stop the message from appearing?
I want to copy the reports into the main spreadsheet using Excel macro code inside Access. This seems to be fine except that when I select the relevant data from a report, copy it to the clipboard and then change across to the main spreadsheet window to paste the data, the check message "You have copied a large amount of data to the clipboard. Do you wish to save it to use elsewhere?" appears. This interupts the code and causes it to error. Does anyone know another way of doing the above or how to temporarily stop the message from appearing?
