Date in Excel ("30/09/2016") copies incorrectly into Access ("30/05/1905")

Hello everybody,

couple of days back I've started coding in Access/VBA environment and I'm coming here for beginner advices.

At the moment, I'm dealing with the issue, that the date I've got in my Excel database (e.g. "30/09/2016") doesn't copy correctly into my Access database (in this case "30/05/1905").

Here is the fraction of the code I use:

First, I determine in what column and row is the date information and store it as a vDate.

Please Login or Register  to view this content.

Then, I store the data as a global variable:

Please Login or Register  to view this content.

Then I call WriteXLSdata procedure copying the data into Access:

Please Login or Register  to view this content.

Would any one of you had the idea, why is the date copying over wrong?

Thank you very much for any tips!

Thank you very much! It seemed to be working. However, out of a blue, the macro started crashing again. So, I would like to ask you one more question relevant to the same code

Would you have any idea, why the Match function in the second line of the following code

Please Login or Register  to view this content.

results every time in an error statement:

Method 'Sheets' of object'_Global' failed

Thank you! It's working now. Hopefully, the very last question:

Is there any way, how to adjust the code for the possibility of not matching any variable? Because the information in every sheet differs, so that not every column header can be found every time

Please Login or Register  to view this content.

which is part of this code:

Please Login or Register  to view this content.

Thanks for the answer. My code is working fine at the moment. The problem as I see it was, that the global variable was missing the values for vCurrency. So, I've used this trick to reference it to the blank columns (Column # = 100) if error occured. It's not very clean way, how to do it, but I needed to find the solution fast

If you had some other better solution, I would be happy if you typed it here.

Please Login or Register  to view this content.

Anyway, thanks for your advices yesterday!