note

名前を付けて保存ダイアログを操作して図の圧縮を行うVBScript(Word ...

先日、「名前を付けて保存」ダイアログの「ツール」から表示できる「画像の圧縮」ダイアログを操作して図の圧縮を行うPowerShellスクリプトを書きました(下記記事ご参照)。 最初はExcelのみに対応していたのですが、他のOfficeアプリケーションを調べてみる ...
Houston Chronicle

How to Make a Button in VBScript Using Excel

Microsoft Excel's form controls let you add buttons to your spreadsheet to perform functions. For example, if a spreadsheet invites coworkers to enter sales predictions, they might press a button to ...
GitHub

VBScript_CodePack /VBScript /Section-11

' - We need to get to the desired cell, and then set the value. ' objExcel.Sheets(sheetName).Range("B3").Value = "45" ' objExcel.Sheets(sheetName).Range("C3").Value ...
Ars Technica

vbscript - read from excel spreadsheet - doesn't close excel process

How do you close the excel process when your script gets done running? I have a script that reads a couple lines of data from a spreadsheet but it doesn't close the ...
Ars Technica

Excel VBA Macro -> standalone VBScript?

Oy, I'm going to show off how little I know with this one, I think. -- View image here: http://episteme.arstechnica.com/groupee_common/emoticons/icon_smile.gif --<br ...