How to Put Programming Code Syntax Highlighter On Blog —
This is the address that I downloaded a plugin for the Windows Live Writer Program Check it out Syntax Highlighter Let me know what you think Scott
Archive for the ‘MS OFFICE’ Category
How Can I backup my quicken data files with Powershell? —
The other day i was asked how do I backup my quicken data files but I want it to be seemless and automatic without me knowing, maybe it can send me an email to let me know that the backup went through. This is very simple for My favorite Scripting Language MS Powershell I started [...]
How to change rows to columns in excel or How to change Columns into rows —
In the morning to all you Techjunkies out there. I ran into an issue at work today as I was creating a bunch of excel sheets for my boss. The issue I was running into was that as I was entering columns into Excel. I started noticing I had to scroll all the way to [...]
How do you center a cell in EXCEL using Powershell? —
I was going nuts trying to find how to center my values in a excel spreadhseet. I finally found it at this site. here is the code: $Sheet.Range(“A1″, “B1″).MergeCells = $True $Sheet.Range(“A1″, “B1″).horizontalalignment = -4108 $Sheet.Cells.Item(1,1) = “november” What gets me is that we have to remember the value -4108 Let me know what you [...]
how to edit a excel file with powershell? —
Question: How do you use Powershell to edit an excel file automatically? That is the question I asked myself when my boss asked me for a dynamic monthly report from a couple systems. I query a database and capture the results. Then I put in the excel file with the correct formatting and save it. [...]