Help please with Excel 2011 (Mac) VBA and El Capitan . . .

wimblejon

New member
Joined
Jun 2, 2016
Messages
3
Reaction score
0
Points
0
​Can someone help me please?


If you have a Mac running ElCapitan and you have Excel 2011 installed, please can you go into an Immediate window in the editor and type '?date' (return) and tell me what you get?


I get '02/06/' (and NO year!!!!)


Doing the same in Yosemite returns '02/06/2016'


I need to know whether I'm going mad or El Capitan degrades VBA to a point where it just doesn't function!


Many thanks.


Jon
 
I did eventually find this:

answers.microsoft.com/
en-us/
mac/
forum/
macoffice2011-macexcel/
vba-for-excel-2011-no-longer-handling-dates-since/
3d04e3b6-3cbc-4a36-89e8-323de4f1c7d1

. . . which points to the fact that it IS a known problem.

Jon
 
. . .oh, and add h t t p : / / to the front of the link.
Jon
 
Back
Top