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 TouchToneTommy 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
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
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
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... -
Need help writing a vb script that adds a row to the first line
Hi, I am new to this forum and scripting. I am tring to add a row to an excel file. The file contains 6 colums and the rows are populated with peoples First Name, Mid Init, Last name, birthdate, job type and date. I am trying to add a row with Description of the colums (header)at the begining... -
Need help writing a vb script that adds a row to the first line
Hi, I am new to this forum and scripting. I am tring to add a row to an excel file. The file contains 6 colums and the rows are populated with peoples First Name, Mid Init, Last name, birthdate, job type and date. I am trying to add a row with Description of the colums (header)at the begining...- arlinda
- Thread
- Replies: 17
- Forum: Visual Basic (Classic)
