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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
VBScript Needed to Manipulate Excel Sheet
SkipVought, Our client uses a BAT (yes, BAT file) file which performs an Export from a DCT (Data Connectivity Tool). It is a simple unattended export which creates the TXT file that needs to be manipulated. If possible, I would simply like to add to the BAT file "scripting" that will kick off... -
VBScript Needed to Manipulate Excel Sheet
VBScript masters, I need your help. I am not very good at scripting, and what I need is probably very easy for someone here to figure out. Here is what I need the script to do: 1: Open Excel and import a TXT file using delimited text import. Here is the "tuff" part. Certain columns need to...
