Reading Excel Time Values

Forums

My Profile

Inbox

Address Book

My Subscription

My Forums

Reading Excel Time Values

Logged in as: Guest

arrSession:exec spGetSession 2,2,54912

	Active Users: There are 0 members and 0 guests.
	Users viewing this topic: none

Printable Version

All Forums >> [Scripting] >> WSH & Client Side VBScript >> Reading Excel Time Values
Do you like VisualBasicScript.com? Link to us and help spread the word about our forum. Thanks!

Page: [1]

Message

<< Older Topic Newer Topic >>

Reading Excel Time Values - 1/4/2008 1:34:17 AM

WebKill

Posts: 3
Score: 0
Joined: 1/4/2008
Status: offline

This is probably an easy one, but I am trying to read a value from a cell in Excel, it's is in a time format (HH:MM AM), but when the script reads it, it comes out as 0.#####. Any help on getting it to read the time, or converting it to the proper time, would be greatly appreciated.

Joe

Post #: 1

RE: Reading Excel Time Values - 1/4/2008 1:52:39 AM

ebgreen

Posts: 4972
Score: 31
Joined: 7/12/2005
Status: offline

Show the pertinent part of the script please.

_____________________________

"... when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick
Goog places to start:http://www.visualbasicscript.com/m_24727/tm.htm
http://www.visualbasicscript.com/m_47117/tm.htm

(in reply to WebKill)

Post #: 2

RE: Reading Excel Time Values - 1/4/2008 2:06:48 AM

WebKill

Posts: 3
Score: 0
Joined: 1/4/2008
Status: offline

Set objExcel = CreateObject("Excel.Application")
Set objWorkBook = objExcel.Workbooks.Open(strExcelPath)
wscript.echo objExcel.Sheets(1).cells(r,1).value

the value in that particular cell is a time, but like my last post said, it comes up as numbers (#.######)

(in reply to ebgreen)

Post #: 3

RE: Reading Excel Time Values - 1/4/2008 2:11:38 AM

ebgreen

Posts: 4972
Score: 31
Joined: 7/12/2005
Status: offline

Set objExcel = CreateObject("Excel.Application")
Set objWorkBook = objExcel.Workbooks.Open(strExcelPath)
wscript.echo CDate(objExcel.Sheets(1).cells(r,1).value)

_____________________________

"... when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick
Goog places to start:http://www.visualbasicscript.com/m_24727/tm.htm
http://www.visualbasicscript.com/m_47117/tm.htm

(in reply to WebKill)