はじめに
Sequence MakerはExcelから測定器を制御可能にするアドインです。Sequence Makerではいろいろな設定ができるのですが、それらの設定はExcelを終了しても保存されています。次に起動したときには、ちゃんと前の設定になっています。ということは、どこかに設定が保存されているハズですが、それはどこに・・・?この記事ではそのありかを明らかにします。Sequence Makerについての詳細は以下の記事を参照ください。
お断り
本記事の内容はSequence Maker開発元の公式見解ではなく、あくまでも個人が趣味の範囲内で執筆しているものです。記事の内容について開発元へ問い合わせることはお控えください。ご質問・要望などは各記事のコメント欄へお願いいたします。
結論
いきなり結論ですがSequence Makerの設定ファイルは以下にあります。
C:\Users\<ユーザー名>\AppData\Local\Microsoft_Corporation\SequenceMaker.vsto_vstolo_Path_jojpsvsna1vaszvd35jsryd0vnvv001i\16.0.17726.20126\user.config
環境やバージョンによっては若干フォルダ名が違うかもしれませんが、だいたいそのあたりです。
user.configの中身
せっかくなので中身を書いておきます。基本的に全ての設定がこのファイルに保存されているようです。
<?xml version="1.0" encoding="utf-8"?>
<configuration>
<userSettings>
<SequenceMaker.Properties.Settings>
<setting name="OptionSendCheck" serializeAs="String">
<value>False</value>
</setting>
<setting name="OptionNotEndMsg" serializeAs="String">
<value>False</value>
</setting>
<setting name="OptionOverWrite" serializeAs="String">
<value>False</value>
</setting>
<setting name="OptionTimeLog" serializeAs="String">
<value>False</value>
</setting>
<setting name="OptionCommTimeLog" serializeAs="String">
<value>False</value>
</setting>
<setting name="OptionSeparateComma" serializeAs="String">
<value>False</value>
</setting>
<setting name="InterfaceRsComportCount" serializeAs="String">
<value>1</value>
</setting>
<setting name="Interface" serializeAs="Xml">
<value>
<ArrayOfString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<string>1</string>
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
</ArrayOfString>
</value>
</setting>
<setting name="InterfaceRsSpeed" serializeAs="Xml">
<value>
<ArrayOfString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<string>9600</string>
<string>9600</string>
<string>9600</string>
<string>9600</string>
<string>9600</string>
<string>9600</string>
<string>9600</string>
<string>9600</string>
<string>9600</string>
<string>9600</string>
<string>9600</string>
<string>9600</string>
</ArrayOfString>
</value>
</setting>
<setting name="InterfaceLanIp" serializeAs="Xml">
<value>
<ArrayOfString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<string>192.168.1.1</string>
<string>192.168.1.1</string>
<string>192.168.1.1</string>
<string>192.168.1.1</string>
<string>192.168.1.1</string>
<string>192.168.1.1</string>
<string>192.168.1.1</string>
<string>192.168.1.1</string>
<string>192.168.1.1</string>
<string>192.168.1.1</string>
<string>192.168.1.1</string>
<string>192.168.1.1</string>
</ArrayOfString>
</value>
</setting>
<setting name="InterfaceLanPort" serializeAs="Xml">
<value>
<ArrayOfString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<string>6866</string>
<string>6866</string>
<string>6866</string>
<string>6866</string>
<string>6866</string>
<string>6866</string>
<string>6866</string>
<string>6866</string>
<string>6866</string>
<string>6866</string>
<string>6866</string>
<string>6866</string>
</ArrayOfString>
</value>
</setting>
<setting name="InterfaceGpibNiBoardId" serializeAs="Xml">
<value>
<ArrayOfString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
</ArrayOfString>
</value>
</setting>
<setting name="InterfaceGpibNiAddress" serializeAs="Xml">
<value>
<ArrayOfString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
</ArrayOfString>
</value>
</setting>
<setting name="InterfaceGpibContecBoardId" serializeAs="Xml">
<value>
<ArrayOfString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
</ArrayOfString>
</value>
</setting>
<setting name="InterfaceGpibContecAddress" serializeAs="Xml">
<value>
<ArrayOfString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
</ArrayOfString>
</value>
</setting>
<setting name="InterfaceVisaAddress" serializeAs="Xml">
<value>
<ArrayOfString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<string />
<string />
<string />
<string />
<string />
<string />
<string />
<string />
<string />
<string />
<string />
<string />
</ArrayOfString>
</value>
</setting>
<setting name="InterfaceRsComport" serializeAs="Xml">
<value>
<ArrayOfString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<string>見つかりません。</string>
<string>見つかりません。</string>
<string>見つかりません。</string>
<string>見つかりません。</string>
<string>見つかりません。</string>
<string>見つかりません。</string>
<string>見つかりません。</string>
<string>見つかりません。</string>
<string>見つかりません。</string>
<string>見つかりません。</string>
<string>見つかりません。</string>
<string>見つかりません。</string>
</ArrayOfString>
</value>
</setting>
<setting name="InterfaceRsData" serializeAs="Xml">
<value>
<ArrayOfString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
</ArrayOfString>
</value>
</setting>
<setting name="InterfaceRsParity" serializeAs="Xml">
<value>
<ArrayOfString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
</ArrayOfString>
</value>
</setting>
<setting name="InterfaceRsStopBits" serializeAs="Xml">
<value>
<ArrayOfString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
</ArrayOfString>
</value>
</setting>
<setting name="InterfaceTerminator" serializeAs="Xml">
<value>
<ArrayOfString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
<string>1</string>
</ArrayOfString>
</value>
</setting>
<setting name="InterfaceRsFlowXon" serializeAs="Xml">
<value>
<ArrayOfString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<string>False</string>
<string>False</string>
<string>False</string>
<string>False</string>
<string>False</string>
<string>False</string>
<string>False</string>
<string>False</string>
<string>False</string>
<string>False</string>
<string>False</string>
<string>False</string>
</ArrayOfString>
</value>
</setting>
<setting name="InterfaceRsFlowRts" serializeAs="Xml">
<value>
<ArrayOfString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
</ArrayOfString>
</value>
</setting>
<setting name="InterfaceRsFlowDsr" serializeAs="Xml">
<value>
<ArrayOfString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
</ArrayOfString>
</value>
</setting>
<setting name="InterfaceGpibContecEoi" serializeAs="Xml">
<value>
<ArrayOfString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
</ArrayOfString>
</value>
</setting>
<setting name="InterfaceGpibNiEoi" serializeAs="Xml">
<value>
<ArrayOfString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
</ArrayOfString>
</value>
</setting>
<setting name="InterfaceGpibNiDcl" serializeAs="Xml">
<value>
<ArrayOfString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
</ArrayOfString>
</value>
</setting>
<setting name="InterfaceGpibContecDcl" serializeAs="Xml">
<value>
<ArrayOfString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
<string>True</string>
</ArrayOfString>
</value>
</setting>
<setting name="InterfaceCharset" serializeAs="Xml">
<value>
<ArrayOfString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
<string>0</string>
</ArrayOfString>
</value>
</setting>
<setting name="OptionNotOverWriteMsg" serializeAs="String">
<value>False</value>
</setting>
<setting name="InterfaceVisaEom" serializeAs="Xml">
<value>
<ArrayOfString xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<string>False</string>
<string>False</string>
<string>False</string>
<string>False</string>
<string>False</string>
<string>False</string>
<string>False</string>
<string>False</string>
<string>False</string>
<string>False</string>
<string>False</string>
<string>False</string>
</ArrayOfString>
</value>
</setting>
<setting name="OptionLineAccessToken" serializeAs="String">
<value />
</setting>
<setting name="OptionExponentFormat" serializeAs="String">
<value>###.0#########E+00</value>
</setting>
<setting name="OptionContecDigitalIoDeviceName" serializeAs="String">
<value />
</setting>
</SequenceMaker.Properties.Settings>
</userSettings>
</configuration>
まとめ
ちなみに設定ファイルを削除すると、次回Excel起動時に自動生成されます。設定は全てクリアされ、デフォルト値に戻ります。Sequence Makerの動作がなんだか不安定になったなと思ったら、思い切って一度設定ファイルを削除してみるのも一つの手かもしれません。