Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Visual Basic > VB 2005 > Visual Basic 2005 Basics
|
Visual Basic 2005 Basics If you are new to Visual Basic programming with version 2005, this is the place to start your questions. For questions about the book: Beginning Visual Basic 2005 by Thearon Willis and Bryan Newsome, ISBN: 0-7645-7401-9 please, use this forum instead.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Visual Basic 2005 Basics section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old May 2nd, 2011, 11:19 AM
Registered User
 
Join Date: May 2011
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default Inserting a Time and Date into an Excel File With VB

I am creating a time clock for our school hardware lab so the students get credit for the time they spend fixing computers for other students. I am tring to use excel for the lfile that VB will write to I got it to create a file with the headings in the right place but cant figure out how to get the VB project to send a Time in and Time out or a Date to the excel file. I am very new to VB as I have only had about 3 weeks in the class so far. Any suggestions would be great.

Thanks for your time
Jeremy.Carter
 
Old May 2nd, 2011, 02:53 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,189
Thanks: 5
Thanked 59 Times in 57 Posts
Send a message via MSN to gbianchi
Default

IMHO... why use excel to store the data???
access is easier to do that...

Anyway what is the problem you have?? sending data to excel or sending the time???
__________________
HTH

Gonzalo


================================================== =========
Read this if you want to know how to get a correct reply for your question.
(Took that from Doug signature and he Took that from Peter profile)
================================================== =========
My programs achieved a new certification :
WORKS ON MY MACHINE
================================================== =========
I know that CVS was evil, and now i got the
proof.
================================================== =========
 
Old May 2nd, 2011, 04:37 PM
Friend of Wrox
 
Join Date: Jun 2005
Posts: 244
Thanks: 3
Thanked 4 Times in 4 Posts
Default

Or mysql, even better and easier
__________________
Apocolypse2005, I'm a programmer - of sorts.
 
Old May 3rd, 2011, 12:18 AM
Registered User
 
Join Date: May 2011
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I was having problems with the date and time but I found out what I was doing wrong I had to format the time and date

Dim DateIn as Date = today for ex.

In the matter of excel over access I havent delt with access at all but have messed around with excel so I'm just going with what I know





Similar Threads
Thread Thread Starter Forum Replies Last Post
Date Time Field not displaying Date and Time webmeister Access 2 January 31st, 2011 12:49 AM
Schedule Excel to run a macro at a specific time and date SheriV Excel VBA 4 March 18th, 2009 04:12 PM
Excel to vb.net date field problem zrtv Pro Visual Basic 2005 5 January 25th, 2009 04:35 PM
How can I set system time & date in VB.net ? mike123abc Pro VB.NET 2002/2003 1 April 27th, 2007 10:00 AM
Changing date format in a file export from excel t jonwitts Excel VBA 2 July 21st, 2005 04:22 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.