Showing archive results for 2008

Jul 21, 2008
Post comments count0
Post likes count0

Hey, Scripting Guy! How Can I Load a Drop-Down List From a Text File?

ScriptingGuy1

Hey, Scripting Guy! I have a text file that has a list of different store numbers and I would like to be able to populate a drop down list of an HTA.-- MH Hi MH, The basic task of reading data from a text file and using it to populate a drop-down list is pretty straightforward. Below is the code for an HTML Application (HTA) that does just that....

Scripting Guy!scripting techniquestext files
Jul 16, 2008
Post comments count0
Post likes count0

Hey, Scripting Guy! How Can I Read the MAC Address From a Text File?

ScriptingGuy1

Hey, Scripting Guy! I've been asked to create a script which will read the contents of addresses.txt and output ONLY the MAC addresses listed in the text file. Could you give me some pointers or even a demo script with which to give me a boost?-- FR Hi FR, The last time someone asked the person writing this column for a boost, the result was low...

Scripting Guy!scripting techniquesVBScript
Jul 3, 2008
Post comments count0
Post likes count0

Hey, Scripting Guy! How Can I Replace a Series of Variables Found in a Text File with Values Taken From That File?

ScriptingGuy1

Hey, Scripting Guy! I have a text file containing TSQL syntax. In this file are a number of variables: @P1, @P2, @p3, and so on, up through @P58. The bottom line of the text file contains replacement values for these variables; for example, I need to take the variable @P1 and replace it with the first value in the last line; I need to replace @P2...

Scripting Guy!scripting techniquesVBScript
Jul 2, 2008
Post comments count0
Post likes count0

Hey, Scripting Guy! How Can I Summarize Information Found in a Spreadsheet Row?

ScriptingGuy1

Hey, Scripting Guy! I have an Excel spreadsheet that tracks daily time for our employees, indicating whether the employee worked on a given day or took some type of leave (paid leave, leave without pay, sick leave, etc.). Is there a way to output a report showing the various leave types taken by each employee, along with the dates those leaves we...

Scripting Guy!VBScriptOffice
Jun 30, 2008
Post comments count0
Post likes count0

Hey, Scripting Guy! How Can I Copy Specified Sections of an .RTF File to a New Word Document?

ScriptingGuy1

Hey, Scripting Guy! I have large files output by a reservoir simulator, files I use to predict oil, water and gas movements in hydrocarbon reservoirs. These files are finite-difference numerical simulators, and work by timestep (i.e. a time interval, usually about 90 days); when they have finished calculating, they chuck out a bunch of data about ...

Scripting Guy!VBScriptOffice