VBA Code (date format) should correspond with custom dateformat

[Stona]

Good morning

I have been trying for three weeks now to get this right but after watching videos and trying everything cant seem to get it to work.

I have a file that when you type things in certain cells, it automatically creates a date stamp in cell "I"

I then have a macro to copy the fields to another file that must be opened (I use a macro for that)

then the file where everything copied must be saved with the new information and then uploaded to a website.

the problem is that when it copies, the date changes to a number. I did watch various videos to make it correct but does not seem to work.

So I am uploading three small excel files.

Book2.xlsm is the file where you type in anything then it will generate a date stamp in cell "I"
Results.xls (and it must not be a macro enabled file) is the one that must be uploaded. there is a macro on the sheet when u click it will copy the info over.

make sure Results.xls is open before running the macro.

When you copy the results over, it overrides the values and format in cell "I' and then the date shows as a number which gives an sql error when I upload it to a specific website.

I am therefore also copying the file called "date file" so you can see what the correct format should be.


What I am asking is can you not adjust the vba code is Book2 so that it can correspond with the format and value in date file?


I removed sensitive information.

Please Login or Register  to view this content.

[Stona]

here is the file with the correct date value format

This is the error it is giving when the date shows as a "number" in the format General view

Error while accessing the database
Incorrect datetime value: '43886' for column 'Date_time' at row 1

[Pepe Le Mokko]

Administrative Note:

Welcome to the forum.

We would very much like to help you with your query, however the thread title does not really convey what your request is about.

Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

(Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)

[Stona]

Good day.

Thank you. I amended the thread title

[Stona]

Can someone please help????

[torachan]

Try this format

Capture.JPG

[Stona]

I have created a date stamp in Excel. When u type cells b to h it will automatically insert today's date in cell I. When u right click on that date choose format, in the general tab it appears as a nr. 43886. I want it to appear as a date. Like the date format in the attached date file. I wanted to know if there is another vba code I can use to make it happen.