Thank you for your help mdmackillop but I have used p45cal solution which worked eventually. At least my colleague has results even without the same date format as I have. (I have dd mm yyyy and she now has d mm yyyy or something similar..)
There are side effects though because of the following code I think. When she puts the password and user name, she can see the results in the specific cells that are mentioned below..I tried to change the reference cell but the excel is not working..so she has to manually change these cells with dates (luckily in these cells only dates appears..). If there is also a solution to the below or you need more info for a solution let me know! I appreciate your help!! Regards, Evan
Range("N10").Value = user_name
Range("N11").Value = Oracle_password
Range("D7").Value = end_date