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!
-
Excel VBA help
I have an excel spreadsheet that lists in rows. 1. I need to read starting with Column A3 and create a new sheet with exactly what is in Column A, (going down)until A is blank. 2. Next I need A2 through AK2 COPIED onto each sheet. (copy into A1:AK2) 3. Last I need to read each cell in A...- Tiahuana
- Thread
- Replies: 3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
List of Documents divided by codes and emailed to those directors.
OK, I have a direcotry of documents, that list like this 600_20101122.csv "Dim ctr,arrDocList, i ctr = 0 Const ForReading = 1 Set objFSO = CreateObject("Scripting.FileSystemObject") Set objTextFile = objFSO.OpenTextFile ("\\Directory\FileList.txt", ForReading) Do Until... -
using .vbs to read/retype .csv information
Hello everyone, First post and I need some assistance. master document is a .csv however each record is divided by a row: "information","information", and such. " " (space, and empty line) "Revenue Code: #### (this line is the key. code is 2 to 5 digits) I need to read the file storing each...
