K
Karen
Hi,
I am working on an excel-Oracle data reporting
application. Originally the excel application was saved
and worked well under German Office XP settings. Now the
office XP settings have been changed to ENGLISH (US) as
default. The time settings of my machine have also been
changed from 'hh:mm:ss AM/PM' to 'HH:mm:ss'. Now I am
unable to run the application under English settings. The
macro code below gives me an error.
Range("Art!F1").Value = Range("Art!F1").Value - 0.001
where "Art!F1" is of a date format 'M/d/yyyy'
The error msg received is
Run-time error '-2147319784 (80028018)':
Method 'Value' of object 'Range' failed
Please tell me how to get around this problem. Thanks in
advance.
Karen
I am working on an excel-Oracle data reporting
application. Originally the excel application was saved
and worked well under German Office XP settings. Now the
office XP settings have been changed to ENGLISH (US) as
default. The time settings of my machine have also been
changed from 'hh:mm:ss AM/PM' to 'HH:mm:ss'. Now I am
unable to run the application under English settings. The
macro code below gives me an error.
Range("Art!F1").Value = Range("Art!F1").Value - 0.001
where "Art!F1" is of a date format 'M/d/yyyy'
The error msg received is
Run-time error '-2147319784 (80028018)':
Method 'Value' of object 'Range' failed
Please tell me how to get around this problem. Thanks in
advance.
Karen