Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default How to print current data and time to text file

Hi All
Any body can guide me How to print current data and time to text file in Visual Basic..

Regard
Dayanand
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,885
Default How to print current data and time to text file

Hi
what do you mean with 'print ...to text file'?

--
Regards
Frank Kabel
Frankfurt, Germany


Dayanand wrote:
Hi All,
Any body can guide me How to print current data and time to text file
in Visual Basic..?

Regards
Dayanand


  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 107
Default How to print current data and time to text file

Are you looking for somethig like this?

Sub test()
Dim ff As Integer, timDat As String
ff = FreeFile
Open "c:\test.txt" For Append As ff
timDat = Format(Now, "dd mmm yyyy, hh:mm:ss")
Print #ff, timDat
Close ff
End Sub

Dayanand wrote:

Hi All,
Any body can guide me How to print current data and time to text file in Visual Basic..?

Regards
Dayanand

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Enter text automatically based on current time jmj713 Excel Discussion (Misc queries) 3 September 7th 07 04:18 PM
updated cell with current time\date if any data in a row has chan pmj Excel Worksheet Functions 4 August 27th 07 08:28 PM
Having the current time inserted w/o updating the current time sherobot Excel Worksheet Functions 2 October 2nd 06 05:05 PM
Can I automatically enter the current date or current time into a Ben New Users to Excel 7 October 19th 05 03:38 PM
problem working with time data imported from text file afaqm Excel Worksheet Functions 1 February 24th 05 08:02 AM


All times are GMT +1. The time now is 08:52 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"