3月 2013

<style>/*<meta name='google-adsense-platform-account' content='ca-host-pub-1556223355139109'/>
<meta name='google-adsense-platform-domain' content='blogspot.com'/>

<script async src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js?client=ca-pub-9537838482740208&host=ca-host-pub-1556223355139109" crossorigin="anonymous"></script>

<!-- data-ad-client=ca-pub-9537838482740208 -->

</head><body>*/</style>

tips , vba

VBAでワークシートの名前とオブジェクト名の取得方法

ドキュメントを作成する上で、オブジェクト名の一覧が必要になったので、取得してみた。

じみんご 2013/3/13

tips , vba

Excel VBA で列番号を英文字に変換する方法でエラーが出たので対応してみた

Microsoftさんが書いていたものが、英文字2桁までしか対応しておらず、注意が必要となっていたので、対応してみました。

じみんご 2013/3/12

<style>/*
<script type="text/javascript" src="https://www.blogger.com/static/v1/widgets/2422103421-widgets.js"></script>
<script type='text/javascript'>
window['__wavt'] = 'AOuZoY7pGbOFDgEwuEMV4V1sHmB_LvH_dw:1756030215940';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d274788450089400277','//blogger.u-mu.net/2013/03/','274788450089400277');
_WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '274788450089400277', 'title': '\u3046\u30fc\u3080\u3068\u60a9\u3080', 'url': 'https://blogger.u-mu.net/2013/03/', 'canonicalUrl': 'https://blogger.u-mu.net/2013/03/', 'homepageUrl': 'https://blogger.u-mu.net/', 'searchUrl': 'https://blogger.u-mu.net/search', 'canonicalHomepageUrl': 'https://blogger.u-mu.net/', 'blogspotFaviconUrl': 'https://blogger.u-mu.net/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': true, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': 'G-87V3Z7JJPE', 'analytics4': true, 'encoding': 'UTF-8', 'locale': 'ja', 'localeUnderscoreDelimited': 'ja', 'languageDirection': 'ltr', 'isPrivate': false, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'isDynamicViewsAvailable': true, 'feedLinks': '\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22\u3046\u30fc\u3080\u3068\u60a9\u3080 - Atom\x22 href\x3d\x22https://blogger.u-mu.net/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22\u3046\u30fc\u3080\u3068\u60a9\u3080 - RSS\x22 href\x3d\x22https://blogger.u-mu.net/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22\u3046\u30fc\u3080\u3068\u60a9\u3080 - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/274788450089400277/posts/default\x22 /\x3e\n', 'meTag': '', 'adsenseClientId': 'ca-pub-9537838482740208', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': true, 'adsenseAutoAds': true, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/09348407eaf53e28', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': '\u30ea\u30f3\u30af\u3092\u53d6\u5f97', 'key': 'link', 'shareMessage': '\u30ea\u30f3\u30af\u3092\u53d6\u5f97', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Facebook \u3067\u5171\u6709', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': '\xd7', 'key': 'twitter', 'shareMessage': '\xd7 \u3067\u5171\u6709', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Pinterest \u3067\u5171\u6709', 'target': 'pinterest'}, {'name': '\u30e1\u30fc\u30eb', 'key': 'email', 'shareMessage': '\u30e1\u30fc\u30eb', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27ja\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': true, 'jumpLinkMessage': 'Read more \xbb', 'pageType': 'archive', 'pageName': '3\u6708 2013', 'pageTitle': '\u3046\u30fc\u3080\u3068\u60a9\u3080: 3\u6708 2013', 'metaDescription': '\u30a6\u30a7\u30d6\u30c7\u30a3\u30ec\u30af\u30bf\u30fc\u3068\u3057\u3066\u4ed5\u4e8b\u3059\u308b\u4e0a\u3067\u5fc5\u8981\u306a\u8003\u3048\u65b9\u3092\u7d39\u4ecb\u3002\u5b9f\u52d9\u3067\u4fbf\u5229\u306aVBA\u30c1\u30c3\u30d7\u3082\u3002'}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': '\u7de8\u96c6', 'linkCopiedToClipboard': '\u30ea\u30f3\u30af\u3092\u30af\u30ea\u30c3\u30d7\u30dc\u30fc\u30c9\u306b\u30b3\u30d4\u30fc\u3057\u307e\u3057\u305f\u3002', 'ok': 'OK', 'postLink': '\u6295\u7a3f\u306e\u30ea\u30f3\u30af'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': '\u30ab\u30b9\u30bf\u30e0', 'isResponsive': true, 'isAlternateRendering': false, 'isCustom': true}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\x3dclassic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\x3dflipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\x3dmagazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\x3dmosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\x3dsidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\x3dsnapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\x3dtimeslide'}, 'isMobile': false, 'title': '\u3046\u30fc\u3080\u3068\u60a9\u3080', 'description': '\u30a6\u30a7\u30d6\u30c7\u30a3\u30ec\u30af\u30bf\u30fc\u3068\u3057\u3066\u4ed5\u4e8b\u3059\u308b\u4e0a\u3067\u5fc5\u8981\u306a\u8003\u3048\u65b9\u3092\u7d39\u4ecb\u3002\u5b9f\u52d9\u3067\u4fbf\u5229\u306aVBA\u30c1\u30c3\u30d7\u3082\u3002', 'url': 'https://blogger.u-mu.net/2013/03/', 'type': 'feed', 'isSingleItem': false, 'isMultipleItems': true, 'isError': false, 'isPage': false, 'isPost': false, 'isHomepage': false, 'isArchive': true, 'isLabelSearch': false, 'archive': {'year': 2013, 'month': 3, 'rangeMessage': '3\u6708, 2013\u306e\u6295\u7a3f\u3092\u8868\u793a\u3057\u3066\u3044\u307e\u3059'}}}, {'name': 'widgets', 'data': [{'title': 'Upload Image', 'type': 'Image', 'sectionId': 'upload-image', 'id': 'Image10'}, {'title': '\u4eba\u6c17\u306e\u6295\u7a3f', 'type': 'PopularPosts', 'sectionId': 'upload-image', 'id': 'PopularPosts1', 'posts': [{'title': 'VBA\u3067\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u306b\u5b58\u5728\u3059\u308b\u5168\u30aa\u30fc\u30c8\u30b7\u30a7\u30a4\u30d7\u306e\u30c6\u30ad\u30b9\u30c8\u306e\u53d6\u5f97', 'id': 6685222617677774212}, {'title': 'Microsoft Project\u3067\u30ea\u30bd\u30fc\u30b9\u3054\u3068\u306b\u30d0\u30fc\u306e\u8272\u3092\u5909\u66f4\u3059\u308b', 'id': 7974424680387313891}, {'title': 'VBA\u3067POST\u3067\u30ea\u30af\u30a8\u30b9\u30c8\u3092\u9001\u3063\u3066\u3001\u623b\u308a\u5024\u306e\u6587\u5b57\u30b3\u30fc\u30c9\u3092\u5909\u63db\u3057\u3066\u307f\u305f', 'id': 424783226856619502}, {'title': 'Microsoft Project\u3067\u30bf\u30b9\u30af\u306e\u958b\u9589\u3092\u30b7\u30e7\u30fc\u30c8\u30ab\u30c3\u30c8\u3067\u5b9f\u884c\u3059\u308b', 'id': 3762986763705175837}, {'title': 'Android\u306eChrome\u306e\u30db\u30fc\u30e0\u753b\u9762\u3067\u691c\u7d22\u5c65\u6b74\u304c\u8868\u793a\u3055\u308c\u3066\u3057\u307e\u3046\u3053\u3068\u3078\u306e\u5bfe\u5fdc', 'id': 1835658740058821545}, {'title': 'VBA\u3067\u6587\u5b57\u5217\u3092MD5\u306b\u5909\u63db', 'id': 3419223510733253542}, {'title': '\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u304b\u3089\u30a2\u30b8\u30e3\u30a4\u30eb\u3067\u3084\u3063\u3066\u304f\u3060\u3055\u3044\u3068\u8a00\u308f\u308c\u305f\u3068\u304d\u306e\u5bfe\u5fdc\u6cd5\uff13\u7a2e', 'id': 8308545723765563328}, {'title': '\u30d7\u30ed\u30b8\u30a7\u30af\u30c8\u306b\u30a2\u30b5\u30a4\u30f3\u3055\u308c\u305f\u3089\u6700\u521d\u306b\u3084\u308b\u3053\u3068', 'id': 4025600339056764983}, {'title': '\u76f8\u624b\u306e\u8a00\u8449\u306b\u5408\u308f\u305b\u305f\u30b3\u30df\u30e5\u30cb\u30b1\u30fc\u30b7\u30e7\u30f3\u306e\u91cd\u8981\u6027', 'id': 23680686242601800}, {'title': '\u30af\u30e9\u30a4\u30a2\u30f3\u30c8\u306e\u30d3\u30b8\u30cd\u30b9\u3068\u62c5\u5f53\u8005\u306e\u601d\u8003\u30fb\u5c5e\u6027\u3092\u7406\u89e3\u3057\u3066\u30c7\u30a3\u30ec\u30af\u30b7\u30e7\u30f3\u3059\u308b\u3053\u3068\u306e\u91cd\u8981\u6027', 'id': 6116672194492419341}]}, {'title': '\u3046\u30fc\u3080\u3068\u60a9\u3080 (Header)', 'type': 'Header', 'sectionId': 'upload-image', 'id': 'Header1'}, {'title': '\u30da\u30fc\u30b8', 'type': 'PageList', 'sectionId': 'upload-image', 'id': 'PageList1'}, {'type': 'Attribution', 'sectionId': 'upload-image', 'id': 'Attribution1'}, {'title': '\u30ab\u30c6\u30b4\u30ea', 'type': 'Label', 'sectionId': 'upload-image', 'id': 'Label1'}, {'title': '', 'type': 'Text', 'sectionId': 'upload-image', 'id': 'Text1'}, {'title': 'Logo', 'type': 'HTML', 'sectionId': 'header-main', 'id': 'HTML10'}, {'title': 'Icons, Dark, Search', 'type': 'LinkList', 'sectionId': 'header-main', 'id': 'LinkList10'}, {'title': 'Menu', 'type': 'LinkList', 'sectionId': 'header-main', 'id': 'LinkList11'}, {'title': 'Featured Post', 'type': 'FeaturedPost', 'sectionId': 'before-blog', 'id': 'FeaturedPost1', 'postId': '8545894454497695329'}, {'title': '\u30d6\u30ed\u30b0\u306e\u6295\u7a3f', 'type': 'Blog', 'sectionId': 'blog-post', 'id': 'Blog1', 'posts': [{'id': '7031805185363025014', 'title': 'VBA\u3067\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u306e\u540d\u524d\u3068\u30aa\u30d6\u30b8\u30a7\u30af\u30c8\u540d\u306e\u53d6\u5f97\u65b9\u6cd5', 'showInlineAds': false}, {'id': '5023612086926254401', 'title': 'Excel VBA \u3067\u5217\u756a\u53f7\u3092\u82f1\u6587\u5b57\u306b\u5909\u63db\u3059\u308b\u65b9\u6cd5\u3067\u30a8\u30e9\u30fc\u304c\u51fa\u305f\u306e\u3067\u5bfe\u5fdc\u3057\u3066\u307f\u305f', 'showInlineAds': false}], 'footerBylines': [{'regionName': 'footer1', 'items': [{'name': 'author', 'label': '\u6295\u7a3f\u8005:'}, {'name': 'timestamp', 'label': 'yyyy/M/d'}, {'name': 'comments', 'label': 'Comment'}, {'name': 'labels', 'label': '\u30ab\u30c6\u30b4\u30ea'}, {'name': 'share', 'label': ''}]}, {'regionName': 'footer3', 'items': [{'name': 'reactions', 'label': '\u95a2\u9023\u8a18\u4e8b'}]}], 'allBylineItems': [{'name': 'author', 'label': '\u6295\u7a3f\u8005:'}, {'name': 'timestamp', 'label': 'yyyy/M/d'}, {'name': 'comments', 'label': 'Comment'}, {'name': 'labels', 'label': '\u30ab\u30c6\u30b4\u30ea'}, {'name': 'share', 'label': ''}, {'name': 'reactions', 'label': '\u95a2\u9023\u8a18\u4e8b'}]}, {'title': '#You may also like', 'type': 'HTML', 'sectionId': 'ads-post', 'id': 'HTML15'}, {'title': 'Popular Posts', 'type': 'PopularPosts', 'sectionId': 'sidebar-static', 'id': 'PopularPosts10', 'posts': [{'title': 'VBA\u3067\u30ef\u30fc\u30af\u30b7\u30fc\u30c8\u306b\u5b58\u5728\u3059\u308b\u5168\u30aa\u30fc\u30c8\u30b7\u30a7\u30a4\u30d7\u306e\u30c6\u30ad\u30b9\u30c8\u306e\u53d6\u5f97', 'id': 6685222617677774212}, {'title': 'Android\u306eChrome\u306e\u30db\u30fc\u30e0\u753b\u9762\u3067\u691c\u7d22\u5c65\u6b74\u304c\u8868\u793a\u3055\u308c\u3066\u3057\u307e\u3046\u3053\u3068\u3078\u306e\u5bfe\u5fdc', 'id': 1835658740058821545}, {'title': 'VBA\u3067POST\u3067\u30ea\u30af\u30a8\u30b9\u30c8\u3092\u9001\u3063\u3066\u3001\u623b\u308a\u5024\u306e\u6587\u5b57\u30b3\u30fc\u30c9\u3092\u5909\u63db\u3057\u3066\u307f\u305f', 'id': 424783226856619502}, {'title': 'Veo3\u3067\u52d5\u753b\u30b3\u30f3\u30c6\u30f3\u30c4\u4f5c\u6210\u7814\u7a76 \u5343\u5e74\u6226\u4e89\u30a2\u30a4\u30ae\u30b9 \u6226\u5deb\u5973\u30b3\u30a6\u30e1\u7de8 1\u30ab\u30c3\u30c8\u76ee\u2460', 'id': 1289799565555906837}, {'title': 'Microsoft Project\u3067\u30ea\u30bd\u30fc\u30b9\u3054\u3068\u306b\u30d0\u30fc\u306e\u8272\u3092\u5909\u66f4\u3059\u308b', 'id': 7974424680387313891}]}, {'title': 'Categories', 'type': 'Label', 'sectionId': 'sidebar-static', 'id': 'Label10'}, {'title': 'Blog Archive', 'type': 'BlogArchive', 'sectionId': 'sidebar-static', 'id': 'BlogArchive10'}, {'title': '#Recent Post', 'type': 'HTML', 'sectionId': 'sidebar-static', 'id': 'HTML19'}, {'title': 'About Us', 'type': 'HTML', 'sectionId': 'footer-widget', 'id': 'HTML21'}, {'title': 'Learn More', 'type': 'LinkList', 'sectionId': 'footer-widget', 'id': 'LinkList13'}, {'title': 'Follow Us', 'type': 'LinkList', 'sectionId': 'footer-widget', 'id': 'LinkList14'}, {'title': 'Newsletter', 'type': 'HTML', 'sectionId': 'footer-widget', 'id': 'HTML22'}, {'title': 'Copyright', 'type': 'HTML', 'sectionId': 'copyright', 'id': 'HTML23'}, {'title': 'SVG Icons', 'type': 'HTML', 'sectionId': 'jet-options', 'id': 'HTML24'}]}]);
_WidgetManager._RegisterWidget('_ImageView', new _WidgetInfo('Image10', 'upload-image', document.getElementById('Image10'), {'resize': false}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_PopularPostsView', new _WidgetInfo('PopularPosts1', 'upload-image', document.getElementById('PopularPosts1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HeaderView', new _WidgetInfo('Header1', 'upload-image', document.getElementById('Header1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_PageListView', new _WidgetInfo('PageList1', 'upload-image', document.getElementById('PageList1'), {'title': '\u30da\u30fc\u30b8', 'links': [{'isCurrentPage': false, 'href': 'https://blogger.u-mu.net/', 'title': '\u30db\u30fc\u30e0'}], 'mobile': false, 'showPlaceholder': true, 'hasCurrentPage': false}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_AttributionView', new _WidgetInfo('Attribution1', 'upload-image', document.getElementById('Attribution1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label1', 'upload-image', document.getElementById('Label1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_TextView', new _WidgetInfo('Text1', 'upload-image', document.getElementById('Text1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML10', 'header-main', document.getElementById('HTML10'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList10', 'header-main', document.getElementById('LinkList10'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList11', 'header-main', document.getElementById('LinkList11'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_FeaturedPostView', new _WidgetInfo('FeaturedPost1', 'before-blog', document.getElementById('FeaturedPost1'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog1', 'blog-post', document.getElementById('Blog1'), {'cmtInteractionsEnabled': false, 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/3582406089-lbx__ja.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/123180807-lightbox_bundle.css'}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML15', 'ads-post', document.getElementById('HTML15'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_PopularPostsView', new _WidgetInfo('PopularPosts10', 'sidebar-static', document.getElementById('PopularPosts10'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label10', 'sidebar-static', document.getElementById('Label10'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_BlogArchiveView', new _WidgetInfo('BlogArchive10', 'sidebar-static', document.getElementById('BlogArchive10'), {'languageDirection': 'ltr', 'loadingMessage': '\u8aad\u307f\u8fbc\u307f\u4e2d\x26hellip;'}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML19', 'sidebar-static', document.getElementById('HTML19'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML21', 'footer-widget', document.getElementById('HTML21'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList13', 'footer-widget', document.getElementById('LinkList13'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList14', 'footer-widget', document.getElementById('LinkList14'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML22', 'footer-widget', document.getElementById('HTML22'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML23', 'copyright', document.getElementById('HTML23'), {}, 'displayModeFull'));
_WidgetManager._RegisterWidget('_HTMLView', new _WidgetInfo('HTML24', 'jet-options', document.getElementById('HTML24'), {}, 'displayModeFull'));
</script>
</body>*/</style>

VBAでワークシートの名前とオブジェクト名の取得方法

Excel VBA で列番号を英文字に変換する方法でエラーが出たので対応してみた

Popular Posts

VBAでワークシートに存在する全オートシェイプのテキストの取得

AndroidのChromeのホーム画面で検索履歴が表示されてしまうことへの対応

VBAでPOSTでリクエストを送って、戻り値の文字コードを変換してみた

Veo3で動画コンテンツ作成研究 千年戦争アイギス 戦巫女コウメ編 1カット目①

Microsoft Projectでリソースごとにバーの色を変更する

Categories

Blog Archive

Veo3で動画コンテンツ作成研究千年戦争アイギス戦巫女コウメ編 1カット目①