Showing tag results for Office

Sep 12, 2008
Post comments count0
Post likes count0

Hey, Scripting Guy! How Can I Read from Excel Without Using Excel?

ScriptingGuy1

Hey, Scripting Guy! I have an Microsoft Office Excel spreadsheet with server names in it, and I would like to be able to use this in a Windows PowerShell script. The thing is, I do not have Microsoft Office or Excel installed on the server. How can I use this spread sheet without installing Office on my server (which I understand is unsupported...

Scripting Guy!Windows PowerShellOffice
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
Jun 28, 2008
Post comments count0
Post likes count0

Hey, Scripting Guy! How Can I Prevent Office Excel From Turning My Imported Numbers Into Dates?

ScriptingGuy1

Hey, Scripting Guy! I have a CSV file, and every time I open that file in Office Excel my numbers get converted to dates. How can I import numbers as numbers?-- JR Hey, JR. You know, just yesterday the Scripting Guy who writes this column learned about Yelo, an interesting little company based in New York City. So what does Yelo do? Well, primari...

Scripting Guy!scripting techniquesVBScript
Jun 25, 2008
Post comments count0
Post likes count0

Hey, Scripting Guy! How Can I Add a Hyperlink to a Microsoft Office Outlook Signature?

ScriptingGuy1

Hey, Scripting Guy! I’m trying to use a script to create a Microsoft Office Outlook signature, but I can’t figure out how to add a live hyperlink to that signature. Can you help?-- BK Hey, BK. You know, it’s interesting that you mention signatures. During his last two trips to TechEd Orlando, the Scripting Guy who writes the col...

Scripting Guy!VBScriptOffice