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!
Recent content by paulk11
-
Ammend Add to column.
After a whole weekend of headscratching finaly got the below to work in VBS. Trouble is this overwrites the data already in column A as opposed to just adding to it. any body have any any anmmendments nessasry to make so this dosnt happen. Paul Dim i, objfso, objfile, strline, arrline, aFile... -
running additional app in script.
GOT IT...! ------------------------------------------------------- Next and final question, how do i append this output to COL A of my .CSV... -------------------------------------------------------- ' send commandline parameters to Password Generator Professional Dim wshShell Set wshShell... -
running additional app in script.
Dear all, posted here yesterday,RE: The below script (Which works great.) Now i need to call a new program (Password Generator Professional) ive got this this:- Which works from a new.vbs file. how do i attach it to the bottom of my main script below... -
Write Macro in to VBS
WOW AMAZING UNBELEIVABLE !!!! Its done !! It Works..!! thank you so so much PHV you truly are a scholar and a gentleman. what difference did that last change mean...? whats the USEDRANGE bit affect..? drinks are on me (or at least they would be) Its like real early here and im off to bed... -
Write Macro in to VBS
ok done when i run the script it opens xl i see to line deleted i see the column deleted i see it change A to Lowercase i see it change A to 3 chars# then it just loops Paul -
-
Write Macro in to VBS
not until i click yes or no, run it again got a WSH error when i opened the .csv (takes a while to popup). line 35 character 5 call was rejected by callee 80010001 Paul -
Write Macro in to VBS
ok that works creates .csv dels column A and row 1 drops A to lower case and sets it to 3 characters. But when i open the .csv i get groupmember.csv is already open Reopening will cause any changes you have made to be disgarded Do you want to reopen groupmembers.csv YES NO if i do yes i get... -
Write Macro in to VBS
PHV Your "Bolted" together script works a charm.!! Now column A looks like as below, so as per original post i need to manipulate this output to change it all to lower case and leave only the 3 characters from the left. (COL A) Alicia Charlie Maria Aishling Tayler (Needs to... -
Write Macro in to VBS
hi there PHV. Actually i have written 3 scripts, which i need to combine in to one script but i cant figure that out. (sorry im very new to VBS) I can tell you all the below scripts individually work but they are 3 individual files currently... -
Write Macro in to VBS
Dear all I need to insert a macro in to my VB script which will do two things to a File previously created in the script. Drop (Change) everything in column A in to lower case Shorten the text displayed in column A to show only the first 3 characters (from the left). Any help much...
