Wscript.Echo strProperty.Name & " - " & strProperty.Value Set objWorkbook = ("C:\Scripts\Test.xls")įor Each strProperty in objWorkbook.BuiltInDocumentProperties Set objExcel = CreateObject("Excel.Application") If you are interested in this process, let me know via (in English, if possible), and I will be glad to go into it in more detail.Īnyway, SV, I looked through the archives and found this script, which you may have been referring to: On Error Resume Next This having been said, I do know of a few companies that have passed down the edict “no more VBScript,” and they actually assigned several of the network administrators to translate the existing VBScript scripts to Windows PowerShell. Generally, I am so excited about the new capabilities of Windows PowerShell that I have not had time to do the translation work. In fact, of the more than 3,000 VBScript scripts I have written, I have actually translated fewer than 100 of them to Windows PowerShell. I appreciate your enthusiasm, but if you have a perfectly fine VBScript script, there is really no need to “translate” it to Windows PowerShell.
#MICROSOFT WORD FOR MAC 2011 METADATA UPDATE#
You want to update a previously working VBScript script to Windows PowerShell. Wow! How many questions can you ask in one question? I am impressed! Let’s see if I can answer them all: yes, a lot, sort of, not really. What gives? I thought Windows PowerShell could do everything VBScript can do and more. I would like to update the script to Windows PowerShell, but can I do this? I tried using New-Object to create the Excel.Application object but somehow it does not seem to work.
Hey, Scripting Guy! I have a VBScript script that reads Microsoft Office Excel metadata.
0 kommentar(er)
