Home arrow Howto's arrow Howto - Scripting
Home
Tools
Knowledge Center
Howto's
Latest Jobs
Latest jobs from IT Contractor Jobs
The latest jobs registered on the IT Contractor Jobs web site.
  • Test Analyst

    - Test Analyst (New Zealand, Auckland - Auckland CBD)

    Test Analyst - Contract A software test Engineer is required for a 6 month contract. Working in the Finance sector and for a...

  • Test Analyst

    - Test Analyst (New Zealand, Auckland - Auckland CBD)

    Test Analyst - Contract A software test Engineer is required for a 6 month contract. Working in the Finance sector and for a high...

  • Senior Infrustructure Engineer

    - Senior Infrustructure Engineer (New Zealand, Wellington - Wellington CBD)

    Senior Infrustructure Engineer - Hourly Rate Contract   I require an experienced Infrastructure Engineer to work in a technological environment that is constantly...


Howto - Scripting
Introduction to scripting in Excel PDF Print E-mail
 I have only recently discovered that I could create Excel spreadsheets using VBScript scripts, but I knew I could embed tabs into my output and import tab-delimited files into Excel. From that point, sorting columns, calculating totals, and even adding charts became relatively easy tasks.

The managers in many of previous organizations liked Excel. Some of the more Excel-savvy managers would add pivot tables, graphs, and pie charts to the existing spreadsheet and send them to their managers. They could add their own analysis, fine-tuning, and flair to the overall presentation. So began my deep involvement with scripting and Excel.

The floodgates opened, however, when I discovered I could create an instance of Excel and output directly to rows and columns. As it turned out, creating the Excel instance was actually an easy process. I’ll describe the steps of that process, briefly take you through them (covering some basic methods and properties as I go), share selected Excel features that I rely on, and offer some Excel scripting tips.

 
Howto - Keep track of users on computers PDF Print E-mail

When you have many roaming users, you often need to know which computer a user is logged on to. Trying to have a user find a computer name inside the OS or on a small label (which is often missing) placed somewhere on the computer isn't always an easy task. As a result, this task is often time consuming. And sometimes you just want to know what computer a user is logged on to without having to speak to the user.  Fortunately, there's an alternative...

Read more...
 
<< Start < Prev 1 2 3 4 Next > End >>

Results 28 - 29 of 29
Powered by IT CONTRACTORS and designed by EZPrinting web hosting