Problem with copying data to a new sheet with a name as variable

Hello Everyone,

i have a problem in my macro. I am just a beginner in VBA, so sorry if this problem is really easy. I have an external Access database. I programmed, that this database will be export to the worksheet "data_today". And what i want to do now, is to copy this data to a new worksheet with a today date. It should happen everyday. This is the part of the code, where is my error:

Please Login or Register  to view this content.

This code create the new sheet, copy the data from the old sheet, but it doesn't paste the data into the new sheet. Can someone help?

Greetings,
Aga

Your syntax is incorrect. Destination is an optional argument label so if you use it, it has to look like this

Please Login or Register  to view this content.

You are trying to use Destination as a variable. If you used Option Explicit then you would have seen your error right away. I strongly recommend to everyone that they declare variables. Doing so prevents a lot of bugs and runtime errors.