Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
How to add the current time in a column
Thank you guy's I just figured it out. objFile.WriteLine strFirstLine -
How to add the current time in a column
Hi, I did add the objFile.WriteLine FirstLine but when I looked at my modifide file, it had opied the same information twice. One that had the header and text. The second had header, text and current date I also did paste exactly what you had posted objFile.WriteLine FirstLine arrContents =... -
How to add the current time in a column
Hi, I made the changes to the script. It adds the current time but it also adds the current time next to the modificationDate header. For example First Name, Middel int, Last name,ModificationDate,2/26/2008 11:24:03 AM This is what I did in my script but when I compile it, my script does not... -
How to add the current time in a column
Hi, My file includes Peoples First name, middle Initial, Last Name and Date. I am adding another column called ModificationDate. I would like to populate the modificationDate column with the current date. For example, this is what I am trying to acomplish First name, middle Initial, Last... -
How to add the current time in a column
Hi, Is it possible to add the current date in the ModificationDate Column? Thank you. -
How to convert this excel script to read from a text file
Ok, So far I have used ADO to open up my file. Let me know if this is correct. Private Sub myTest() Dim con As New ADODB.Connection Dim rs As ADODB.Recordset con.Open "provider=sampprov;data source=C:\data\teletick1.csv" Set rs = con.Execute("teletick.csv")... -
How to convert this excel script to read from a text file
Not a lot of examples -
How to add the current time in a column
Hi, I would like to know how to add the current time in my Modification column. This column is emty. This file is a text file and I dod not know how to create a script using ADO. Please advice. This is what I have so far. 'On Error Resume Next Const ForReading = 1 Const ForWriting = 2 'open... -
How to convert this excel script to read from a text file
I am not sure about ADO. Need advice? -
How to convert this excel script to read from a text file
I am not familiar with ADO so I am researching it write now. -
How to convert this excel script to read from a text file
The thing is that the pc does not have Ms OFFICE and when I frst compiled the script I got an error on, "Excel.Application" So far I am able to add a row on the first line and add a heading for every column. I am working on adding the current date on teh Modification column. Please advice. 'On... -
How to convert this excel script to read from a text file
Please read this one not the one above This is what I was able to do. Still researching the rest. Any comments Const ForReading = 1 Const ForWriting = 2 'open the data file Set objFSO = CreateObject("Scripting.FileSystemObject") Set objFile = objFSO.OpenTextFile("C:\data\abc.csv"... -
How to convert this excel script to read from a text file
Ok, This is what I was able to do. Still researching the rest. Any comments Const ForReading = 1 Const ForWriting = 2 'open the data file Set objFSO = CreateObject("Scripting.FileSystemObject") Set objFile = objFSO.OpenTextFile("C:\data\abc.csv", ForReading) sDo Until... -
How to convert this excel script to read from a text file
Hi, I would like to know how to I re-write this script to read and write this script in a text file format. Please advice. Thank you. call myMacro1() Sub mymacro1() ' ' mymacro1 Macro ' Macro recorded 2 ' ' const xlDown=&HFFFFEFE7 Set objXL = CreateObject("Excel.Application")... -
how to add a time stamp or current date in a column
Thank youuuuuuuuu very much. It works flawlessly -
how to add a time stamp or current date in a column
Thank youuuuuuuuu very much. -
how to add a time stamp or current date in a column
Hi, How do I put this in a loop? dim iRow iRow=2 Do Until objWS.Cells(intRow).Value = "" If objWS.Cells(iRow, "F") <> "" Then objWS.Cells(iRow, "M") = Now() objWS.MoveNext intRow = intRow + 1 Loop -
how to add a time stamp or current date in a column
Please look at this one on the one above Hi, Sorry to bother you again but when I put the If statement into my script, and compiled the code I got a "Unknown runtime error on the line that has the If statement any ideas? I initialy used the objWS.cell statement but I got an error saying that... -
how to add a time stamp or current date in a column
Hi, Sorry to bother you again but when I put the If statement into my script, and compiled the code I got a "Unknown runtime error on the line that has the If statement any ideas? I initialy used the objWS.cell statement but I got an error saying that Object doesn't support this property or... -
how to add a time stamp or current date in a column
Hi, I have an excel spreadsheet with a few columns. I have added a column called modification date and I would like to compare it with a column card num and if there is data in card num then I want the modification date column to add the current date. How do I do this. Please advice? Hi...
