Vba can't read Date?

Question

My company changed the computers two months ago, all new pc with same specification.

I posted this same thread on 1 Mar 13 and the thread went to Chinese forum. Suggestion from that forum was to check the area and language within the control panel, I did that and found that all computer were set with same area and language. I still looking for the answer to solve this problem.

I have a line Range("A26").Value = Format(Date,"dd-mm-yy") which runs well in some but not all PC.

Debug highlighted "Date".

Answer 1

The following has to be done on a computer where the error message occurs.

If the error message states that Date is an unknown function, end macro execution, and select Tools | References... in the Visual Basic Editor.

The references in use are displayed at the top of the list; their check boxes are ticked.

There may be a reference in use whose name starts with MISSING:. If so, clear its check box, then click OK.

Next, select Debug | Compile <projectname>. Hopefully, you won't get an error message about the Date function.

Answer 2

HansV,

Thanks for you answer. Unchecked missing reference solved the problem, now the vba performs as it should be.

Thanks again.

I pasted the link of this thread to the chinese forum, hopefully it would help those chinese users who face the same problem as I was could get it fixed as well.

Also thanks for the rest of input and advices, you guys are great.

Best Regards

Answer 3

Hans

I will try that and let you know the result.

Tks

Answer 4

Hi,

On the problem pc's, try

msgbox VBA.Date

postback the result

Regards

JY