Windows Vista Forums
Vista Forums Home Join Vista Forums Windows 7 Forum Vista Tutorials Tags
Welcome to Windows Vista Forums. Our forum is dedicated to helping you find solutions with any problems, errors or issues you are experiencing with Windows Vista. The Vista forum also covers news and updates and has an extensive Windows Vista tutorial section that covers a wide range of tips and tricks.

Go Back   Vista Forums > Misc Newsgroups > VB Script

Vista - VBscript Returns wrong value from Excel Cell

Reply
 
Old 03-13-2009   #1 (permalink)
michael.jarratt


 
 

VBscript Returns wrong value from Excel Cell

Hi

I've got an issue which I've seen and fixed before but for the life of
me I can't fix now....
I have a script which reads the value of an excel cell in to an
array. This works fine but for some reason some of the values are
wrong. For example the value 10:23:00 appears as a decimal
0.432638888888889 in the array. This happens on cells that are
custom.
The easy fix would be to change the cell type but that doesn't fix the
issue and I know that people will chage the cell type back to custom
at some point in the future....

Thanks

My System SpecsSystem Spec
Reply

Thread Tools


Similar Threads
Thread Forum
VistaPro + Excel 2007- cell copy very very slow Vista General
RE: Assign variable value to excel cell VB Script
Is there a write-multi-cell-at-once function in VBS for Excel? VB Script
Need sample for reading value from and writing value to cell E53 from outside Excel VB Script
Environment.GetFolderPath returns wrong path .NET General


Vista Forums is an independent web site and has not been authorized,
sponsored, or otherwise approved by Microsoft Corporation.
"Windows Vista", the Start Orb, and related materials are trademarks of Microsoft Corp.
© Designer Media Ltd

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46