{"id":53783,"date":"2009-05-11T23:21:00","date_gmt":"2009-05-11T23:21:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2009\/05\/11\/hey-scripting-guy-how-can-i-convert-a-vbscript-to-a-windows-powershell-script-that-creates-an-office-word-document-with-hyperlinks\/"},"modified":"2009-05-11T23:21:00","modified_gmt":"2009-05-11T23:21:00","slug":"hey-scripting-guy-how-can-i-convert-a-vbscript-to-a-windows-powershell-script-that-creates-an-office-word-document-with-hyperlinks","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/hey-scripting-guy-how-can-i-convert-a-vbscript-to-a-windows-powershell-script-that-creates-an-office-word-document-with-hyperlinks\/","title":{"rendered":"Hey, Scripting Guy! How Can I Convert a VBScript to a Windows PowerShell Script That Creates an Office Word Document with Hyperlinks?"},"content":{"rendered":"

\"Hey, Hey, Scripting Guy! I am trying to learn Windows PowerShell. I have a script that creates a Word document that has a series of hyperlinks in it. I want to be able to write that script in Windows PowerShell, but I am not sure where I should begin. As far as I can tell, there are no Windows PowerShell cmdlets that will let me do this. Am I out of luck?<\/p>\n

– MF
\"Spacer\"\"Hey, <\/p>\n

Hi MF,<\/p>\n

It is a shame there is no New-WordDoc<\/b> cmdlet. It would definitely simplify things significantly. I am glad you said you are trying to learn Windows PowerShell, because in most cases I do not recommend that people just go around converting VBScript to Windows PowerShell. For one thing, you can do so much more with Windows PowerShell than you can do with VBScript that I have yet to run out of ideas for new Windows PowerShell scripts. I have written more than 3,000 VBScripts in my life, and of those, I have translated fewer than 300 into Windows PowerShell. For one thing, if I spend an hour converting a VBScript to a Windows PowerShell script, what do I have at the end of that hour? I have the same thing I had before, only now it is Windows PowerShell instead of VBScript. That’s fine, but I have achieved no new functionality, and I am doing nothing new. <\/p>\n

As an example, I have a script that I use when I travel. It turns off my wireless network adapter, turns on my ethernet card, and shuts down the laptop. I use this when I am in an office with wireless connectivity and staying in a hotel that uses Cat 5. It saves me time. The script also reverses the process. Therefore, I am ready to go in the morning when I go back to the office. I have felt no need to translate it to Windows PowerShell. You will find a similar version of this script<\/a>, but it’s written in Windows PowerShell. Keeping these tips in mind should help you remain calm, serene, and happy, like this little fella I saw a couple of years ago while scuba diving off Kona on the Island of Hawaii<\/a> in the United States.<\/p>\n

\"Image<\/p>\n

 <\/p>\n\n<\/thead>\n\n\n
\n

This week we are looking at how to migrate VBScript to Windows PowerShell. You should definitely check out the VBScript-to-Windows PowerShell Conversion Guide<\/a>. This is included as Appendix C in the Microsoft Press book, Microsoft Windows PowerShell Step by Step<\/a>. It is also in the Windows PowerShell Graphical Help File<\/a>. Clearly, we are proud of that thing. You may also want to check out our Windows PowerShell Scripting Hub<\/a> where you will find links to the Windows PowerShell Owner’s Manual (very popular!) and other resources that will help you to convert VBScript to Windows PowerShell. One additional book that would be useful is the Microsoft Press book, Windows PowerShell Scripting Guide<\/a>. This book is useful if you are working with WMI, or if you are trying to go beyond simple line-by-line translations of one script to another.<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

<\/div>\n

MF, there is a Hey, Scripting Guy!<\/a> article that was published back in February 2005 that talks about adding hyperlinks to a Office Word document. Because we will not be covering the VBScript version of that script, refer to that article for detailed information about how the script works. For ease of learning, however, we took the liberty of pasting that script here:<\/p>\n

AddHyperlinkToWord.vbs<\/b><\/p>\n

Set objWord = CreateObject(“Word.Application”)
objWord.Visible = TRUE
Set objDoc = objWord.Documents.Add()
Set objRange = objDoc.Range()
Set objLink = objDoc.Hyperlinks.Add _
    <\/span>(objRange, ” http:\/\/www.microsoft.com\/technet\/scriptcenter “, , , “Script Center”)<\/p>\n

<\/font><\/font><\/span><\/p>\n

When the AddHyperlinkToWord.vbs<\/b> script runs, it opens Word and adds the words “Script Center” on a new line. Then it turns the words “Script Center” into a hyperlink that points to http:\/\/www.microsoft.com\/technet\/scriptcenter:<\/p>\n

\"Image<\/p>\n

 <\/p>\n

The Windows PowerShell version of the AddHyperlinkToWord.vbs<\/b> script is called—no surprises here—AddHyperlinkToWord.ps1<\/b>. This script is seen here:<\/p>\n

AddHyperlinkToWord.ps1<\/b><\/p>\n

$objWord = New-Object -comobject Word.Application
$objWord.Visible = $true
$objDoc = $objWord.Documents.Add()
$objRange = $objDoc.Range()
$objLink =
$objDoc.HyperLinks.Add($objRange, “http:\/\/www.ScriptingGuys.com”,$null,$null,”Script Center”)<\/p>\n

<\/font><\/font><\/span><\/p>\n

The first thing that you may notice is that the two scripts, AddHyperlinkToWord.ps1<\/b> and AddHyperlinkToWord.vbs<\/b>, are nearly identical. Each has six lines, and each calls the same objects and methods. The one change you may notice is that the last line is shortened by using the www.scriptingguys.com URL that was not available back in 2005. Let’s examine this script line by line. <\/p>\n

The first step that must be performed when you work with Word Automation is to create an instance of the Word.Application<\/b> COM object. To create a COM object in VBScript, you use the CreateObject<\/b> method. To create a COM object in Windows PowerShell, you use the New-Object<\/b>–comobject<\/b> cmdlet. There are two things I like about the Windows PowerShell methodology:<\/p>\n\n\n\n\n
•<\/td>\n\n

You do not have to use parentheses and quotation marks around the program ID (Word.Application<\/b>). This is because Windows PowerShell is a strongly typed language (it knows when something is a string, an integer, or a datetime<\/b> value, for example) The –comobject<\/b> parameter expects you to supply a string. Because it is expecting a string, you do not have to tell it you are giving it a string by using quotation objects.<\/p>\n<\/td>\n<\/tr>\n

•<\/td>\n\n

You do not have to use a keyword such as Set<\/b> to tell the variable that you are giving it an object. One thing that was confusing to students of VBScript was the use of the Set<\/b> keyword. Set<\/b> is required when you want to store an object in a variable. The problem is students were not always sure when an object was returned. In Windows PowerShell you can avoid that problem—everything is an object. Even a simple integer is an object (an instance of the system.int<\/b> .NET Framework class) and has both properties and methods.<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

The line of the script that creates the instance of the Word.Application object<\/a> and stores the returned object in the $objWord<\/b> variable is seen here:<\/p>\n

$objWord = New-Object -comobject Word.Application<\/p>\n

<\/font><\/span><\/p>\n

The next line in the AddHyperlinkToWord.ps1<\/b> script makes the instance of the Word.Application<\/b> object visible. To do this, you use a Boolean value. In the VBScript example, you used True<\/b>; here you use the automatic variable $true<\/b>. I like using the automatic variables $true<\/b> and $false<\/b> because they work almost everywhere. In VBScript some Boolean values require you to specify -1<\/b>. Others require a string “True”. Still others used the TRUE<\/b> keyword:<\/p>\n

$objWord.Visible = $true<\/p>\n

<\/font><\/span><\/p>\n

Now you have to add a document to hold the hyperlinks. To do this, you use the Add<\/b> method from the Documents collection<\/a>. In Windows PowerShell, all methods use empty parentheses. This provides a visual indicator you are working with a method instead of a property. In VBScript this was not a requirement, and sometimes it was confusing whether you were actually dealing with a property or a method. <\/p>\n\n<\/thead>\n\n\n
\n

One bug I discovered while writing the Microsoft Press book, Microsoft VBScript Step by Step<\/a>, was on MSDN. The count<\/b> method from the Windows Script Host was referred to in one place as the count<\/b> property.<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

<\/div>\n

In Windows PowerShell you will never confuse a method and a property. Here is how you call the Add<\/b> method to add a document to the documents<\/b> collection: <\/p>\n

$objDoc = $objWord.Documents.Add()<\/p>\n

<\/font><\/span><\/p>\n

You now have to create a range object<\/a>. To do this, you use the Range method<\/a> from the Document object<\/a>. This is shown here:<\/p>\n

$objRange = $objDoc.Range()<\/p>\n

<\/font><\/span><\/p>\n

As soon as you have the Application<\/b> object, the Document<\/b> object, and the Range<\/b> object, you are ready to add the hyperlink. To do this, you use the Hyperlinks property<\/a> to create an instance of the Hyperlinks collection<\/a>. The Hyperlinks<\/b> collection object has the Add method<\/a>, which enables you to add hyperlinks to a Office Word document. These parameters are shown in Table 1<\/b>. <\/p>\n\n\n\n\n\n\n\n\n\n\n\n
Table 1 Parameters of the Hyperlink Add Method<\/td>\n<\/tr>\n
Name<\/td>\nRequired\/Optional<\/td>\nData Type<\/td>\nDescription<\/td>\n<\/tr>\n<\/thead>\n
\n

Anchor<\/p>\n<\/td>\n

\n

Required<\/p>\n<\/td>\n

\n

Object<\/p>\n<\/td>\n

\n

The text or graphic that you want turned into a hyperlink.<\/p>\n<\/td>\n<\/tr>\n

\n

Address<\/p>\n<\/td>\n

\n

Optional<\/p>\n<\/td>\n

\n

Variant<\/p>\n<\/td>\n

\n

The address for the specified link. The address can be an e-mail address, an Internet address, or a file name. You should be aware that Microsoft Office Word does not check the accuracy of the address.<\/p>\n<\/td>\n<\/tr>\n

\n

SubAddress<\/p>\n<\/td>\n

\n

Optional<\/p>\n<\/td>\n

\n

Variant<\/p>\n<\/td>\n

\n

The name of a location within the destination file, such as a bookmark, named range, or slide number.<\/p>\n<\/td>\n<\/tr>\n

\n

ScreenTip<\/p>\n<\/td>\n

\n

Optional<\/p>\n<\/td>\n

\n

Variant<\/p>\n<\/td>\n

\n

The text that appears as a ScreenTip when the mouse pointer is positioned over the specified hyperlink. The default value is “Address”.<\/p>\n<\/td>\n<\/tr>\n

\n

TextToDisplay<\/p>\n<\/td>\n

\n

Optional<\/p>\n<\/td>\n

\n

Variant<\/p>\n<\/td>\n

\n

The display text of the specified hyperlink. The value of this argument replaces the text or graphic specified by Anchor.<\/p>\n<\/td>\n<\/tr>\n

\n

Target<\/p>\n<\/td>\n

\n

Optional<\/p>\n<\/td>\n

\n

Variant<\/p>\n<\/td>\n

\n

The name of the frame or window in which you want to load the specified hyperlink.<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

<\/div>\n

In VBScript you were allowed to pad parameters (omit parameter values) when calling methods. In Windows PowerShell you are not allowed to pad parameters. You must supply a value for each parameter, even if you only use $null<\/b>. In this method call, the Range<\/b> object, contained in the $objRange<\/b> variable is the anchor. The string http:\/\/www.<\/b>s<\/b>cripting<\/b>g<\/b>uys.com<\/b> is the address parameter. The SubAddress<\/b> and ScreenTip<\/b> parameters are left out. The TextToDisplay<\/b> parameter value is “Script Center.” The Target<\/b> parameter is left off. This is allowed because it is located on the end of the method<\/b> signature. This is seen here:<\/p>\n

$objLink = <\/p>\n

<\/font><\/span><\/p>\n

$objDoc.HyperLinks.Add($objRange, “http:\/\/www.ScriptingGuys.com”,$null,$null,”Script Center”)<\/p>\n

<\/font><\/span><\/p>\n

MF, I have to return to the Scripting Guys booth. Craig and I are in Los Angeles this week for Tech∙Ed, and we are dividing our time between sessions and the booth (I am also hanging out at the Windows PowerShell team’s booth and speaking on Friday). If you are out here this week stop by the Scripting Guys booth and say hi! Craig is a really nice guy and is fun to talk to. Just don’t expect him to fix your scripts. That’s Ed’s job. Ed will also talk to you about tea, Australia, scuba diving, and of course scripting. See you back here tomorrow.<\/p>\n

 <\/p>\n

Ed Wilson and Craig Liebendorfer, Scripting Guys<\/b><\/p>\n<\/h2>\n","protected":false},"excerpt":{"rendered":"

Hey, Scripting Guy! I am trying to learn Windows PowerShell. I have a script that creates a Word document that has a series of hyperlinks in it. I want to be able to write that script in Windows PowerShell, but I am not sure where I should begin. As far as I can tell, there […]<\/p>\n","protected":false},"author":595,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[84,49,3,4,5,155,45],"class_list":["post-53783","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-microsoft-word","tag-office","tag-scripting-guy","tag-scripting-techniques","tag-vbscript","tag-vbscript-migration","tag-windows-powershell"],"acf":[],"blog_post_summary":"

Hey, Scripting Guy! I am trying to learn Windows PowerShell. I have a script that creates a Word document that has a series of hyperlinks in it. I want to be able to write that script in Windows PowerShell, but I am not sure where I should begin. As far as I can tell, there […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/53783","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/users\/595"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=53783"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/53783\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media\/87096"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media?parent=53783"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=53783"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=53783"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}