Entries from 2016-01-01 to 1 year

VBA VisualBasic Editor garbling issue

[Problem] Japanese characters on the menus and code window get garbled Visual Basic Editor does't support Unicode, even though VBA does. Go to the system rocale in Windows control panel, and check the setting of language for programs that …

VBA Clipboard trouble in Windows 10

[トラブルの概要] Step1. クリップボード にテキストデータをセットする。 Dim DO As New DataObject DO.setText [Text] DO.putInClipboard Step2.クリップボードにセットしたテキストデータが利用できない。 [解決策] stackoverflow.com

How to find and set properties of shapes

Get and set the sizes of shapes [Shape Width] Shape.CellsSRC(visSectionObject, visRowXFormOut, visXFormWidth) Return: String (e.g. "10 mm") Shape.CellsSRC(visSectionObject, visRowXFormOut, visXFormWidth).FormulaU = String Shape.Cells("Widt…

Sample Code - Get the properties of the first shape selected and apply them to the other selected shapes

Sub setSamePropertyOfPrimaryShape() Dim vsoSelection As Visio.Selection Dim primaryShape As Visio.Shape 'first selected shape Dim targetShape As Visio.Shape 'other selected shapes Dim primaryShapePropsCount As Integer ' the number of prope…