Browse by Tags

All Tags » Office 2010 (RSS)
Tue, Apr 26 2011 22:03

Scripting Games Commentary: III PowerShell and Excel

Some of the events had the production of a CSV file as the end result with a bonus point if you opened the file in Excel. The quickest way and easiest way to open a CSV file in Excel is like this Invoke-Item -Path chapt4.csv   This will work if you...
Posted by RichardSiddaway | with no comments
Filed under: , ,
Sat, Nov 20 2010 18:47

Visio Stencils

If you are looking for Visio stencils – especially of a technical nature – check out Visio cafe - - http://www.visiocafe.com/
Posted by RichardSiddaway | with no comments
Filed under:
Tue, Jul 6 2010 22:18

PowerShell and Visio: Opening a file 3

We have seen how to open a file and add the stencil that goes with it. 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 017 018 019 020 021 022 $visio   =   New-Object   -ComObject   Visio.Application $doc   =  ...
Posted by RichardSiddaway | with no comments
Filed under: , ,
Mon, Jul 5 2010 21:50

PowerShell and Visio: Opening a file 2

If you run the AD diagramming script we looked at recently and save the Vision drawing on problem is that the stencil doesn’t open with it. We have to go back and add it 001 002 003 004 005 006 007 008 009 010 $visio   =   New-Object  ...
Posted by RichardSiddaway | with no comments
Filed under: , ,
Sun, Jul 4 2010 21:13

PowerShell and Visio – Opening a file

If all you want to do is open a Visio drawing then the simplest way is to use Start-Process test.vsd This will open the file in Visio ready for you to start work on it. If you want to open the file and work on it programmatically then we have a little...
Posted by RichardSiddaway | with no comments
Filed under: , ,
Sat, Jun 26 2010 18:43

PowerShell and Visio – Documenting AD: 3

Up to now we have been dealing with a single level of OUs. There are few AD implementations that don’t have child OUs so how do we deal with them. 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 017 018 019 020 021 022 023 024 025 026...
Posted by RichardSiddaway | with no comments
Filed under: , , , ,
Thu, Jun 24 2010 21:43

Listing all of the OUs in a domain

In this post - http://msmvps.com/blogs/richardsiddaway/archive/2010/06/13/powershell-and-visio-documenting-ad-2.aspx – I showed how to start creating a diagram of the OU structure in your AD domain.  In case you are wondering how to get a text file...
Posted by RichardSiddaway | with no comments
Filed under: , , , , ,
Thu, Jun 24 2010 19:50

Extended properties

In the last post I showed how to read the Extended Properties of a Visio stencil. But how do we know how which property to use? We can adapt our script to list the possible Extended Properties 001 002 003 004 005 $direc   =   "C:\Program...
Posted by RichardSiddaway | with no comments
Filed under: , ,
Thu, Jun 24 2010 19:46

Identifying Visio Stencils

In the previous posts on using Visio I’ve shown how to load and use a particular stencil.  But how do you know which stencil to use? One way is to use Windows Explorer, hover the mouse over the stencil and read the Extended File Properties. That...
Posted by RichardSiddaway | with no comments
Filed under: , ,
Sun, Jun 13 2010 20:32

PowerShell and Visio – Documenting AD: 2

I’ve taken the script to add OUs to a drawing and modified it so that the addition is performed by a function. I started with a text file containing some OUs ou=England,dc=Maticore,dc=org ou=Scotland,dc=Maticore,dc=org ou=Wales,dc=Maticore,dc=org ou=Ireland...
Posted by RichardSiddaway | 1 comment(s)
Filed under: , , ,
Sat, Jun 12 2010 22:58

PowerShell and Visio – Documenting AD: 1

If we take the concept of our last script that added objects to a drawing we can use this as the basis of a way to automate the documentation of our AD. One of the first things we need to document is the OU structure.  If you have ever produced one...
Posted by RichardSiddaway | with no comments
Filed under: , , ,
Fri, Jun 11 2010 19:43

Powershell and Visio: Move objects and add text

Lets take our look a Visio a bit further and move objects around and change the text labels 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 017 018 019 020 021 022 023 024 025 026 027 028 029 030 031 032 033 034 035 036 037 038 039 040...
Posted by RichardSiddaway | with no comments
Filed under: , ,
Thu, Jun 10 2010 20:47

Powershell and Visio: connectors

Last time we looked at creating a Visio drawing and adding a couple of objects.  This time we will build on that and resize the objects and add a connector. The Resize method on a shape is ONLY AVAIALBLE ON VISIO 2010 001 002 003 004 005 006 007...
Posted by RichardSiddaway | with no comments
Filed under: , ,
Wed, Jun 9 2010 21:52

PowerShell and Visio

I’ve blogged about using PowerShell with various members of the Office family before. I thought its about time I looked at Visio.  I use Visio quite a bit and it would be useful to be able to drive it with PowerShell 001 002 003 004 005 006 007 008...
Posted by RichardSiddaway | with no comments
Filed under: , ,
Sat, Apr 24 2010 13:55

Office 2010

Office 2010 recently went RTM and is now available fro download from MSDN/TechNet.  Downloaded and installed without a problem.  I removed the beta versions – having remembered to export my auto correct entries.  Install went smooth and...
Posted by RichardSiddaway | 1 comment(s)
Filed under: ,
Sat, Feb 13 2010 15:45

Access: Stored Procedure

Next stop on our trip around Access functionality is the stored procedure.  An SP is a piece of code that we have defined, and saved in the database. It may take parameters or may just be a straight select statement. As with any Access object we...
Posted by RichardSiddaway | with no comments
Filed under: , ,
Thu, Feb 4 2010 20:18

View Access table definitions part 2

  Following on from the last post we wanted to be able to look at the table definitions 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 017 018 019 020 021 022 023 024 025 026 027 028 029 030 031 032 $datatype   =   DATA...
Posted by RichardSiddaway | with no comments
Filed under: , ,
Wed, Feb 3 2010 22:27

View Access table definitions

We’ve looked quite a bit at how we can work with Access databases but how do we investigate the structure of the database.  The first thing we need to know is the tables in our database 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015...
Posted by RichardSiddaway | with no comments
Filed under: , ,
Fri, Jan 15 2010 20:03

Getting Access table definitions

So far we have only created a single table but in a database with a number of tables we need to be able to view the table definitions. 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 016 ## ## connect to database ## $conn   =   New...
Posted by RichardSiddaway | with no comments
Filed under: , ,
Sun, Jan 10 2010 16:42

Delete an index

We have seen how to add indexes. We also need to be able to remove them 001 002 003 004 005 006 007 008 009 010 011 012 013 014 015 function   Remove-AccessIndex   { # .ExternalHelp Maml-AccessFunctions.XML [ CmdletBinding ( ) ] param  ...
Posted by RichardSiddaway | with no comments
Filed under: , ,
More Posts « Previous page - Next page »