This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
'Ver 1.00 2021/07/24 デスクトップに置いて、サクサク使えるメニューを作成する。 | |
' | |
'[処理] | |
' ファイル名/Exeファイル/URL/ショートカットを開く | |
' | |
'[使い方] | |
' このファイル(ランチャー.vbs)をデスクトップに置く | |
' | |
'[注意] | |
' エンコードは、ANSI(Shift JIS)で保存すること。 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Sub メニュー() | |
On Error GoTo subError | |
Dim wMenu As String | |
wMenu = "項目の追加,項目位置を保存,フォーム画面表示" | |
n = f_メニュー("タイトル", wMenu, "選択してください", 0) | |
If n = 0 Then Exit Sub | |
'--- Exit --- | |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Protected Sub S_GetID(qTBL As String) | |
'Azure | |
Dim strSQL As String | |
Dim cnnStr As String = ConfigurationManager.AppSettings("apps_BariSpDT_Kava") | |
Dim cnn As SqlConnection = New SqlConnection(cnnStr) | |
Dim sqlcmdSelect As SqlCommand = New SqlCommand() | |
Dim adpt As SqlDataAdapter = New SqlDataAdapter() | |
Dim dsDataSet As DataSet = New DataSet | |
sIDNew = 0 |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
' | |
' 日本語ローコードYUGE Ver1.19 | |
' (注意)変更しないでください。 | |
' https://excel-databace.hatenablog.com/entry/yuge-help | |
' | |
'Ver 1.17 2020/11/16 タイマー機能追加 | |
' 1.18 2020/11/25 ユーザーマクロに説明追加/年月範囲追加/印刷ダイアログ | |
' 1.19 2020/12/25 テーブル作成/解除 | |
' | |
Option Explicit |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Declare PtrSafe Function SetTimer Lib "user32" (ByVal hwnd As Long, _ | |
ByVal nIDEvent As Long, _ | |
ByVal uElapse As Long, _ | |
ByVal lpTimerFunc As LongPtr) As Long | |
Declare PtrSafe Function KillTimer Lib "user32" (ByVal hwnd As Long, _ | |
ByVal nDEvent As Long) As Long |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#If VBA7 And Win64 Then | |
'64bit版 Private Declare PtrSafe Function GetWindowRect Lib "user32" (ByVal hWnd As LongPtr, lpRect As RECT) As Long | |
#Else | |
'32bit版 Private Declare Function GetWindowRect Lib "user32" (ByVal hWnd As Long, lpRect As RECT) As Long | |
#End If |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Dim cd As String | |
cd = "" | |
cd = cd & "function timeConv(s){" | |
cd = cd & " var dt = new Date(s);" | |
cd = cd & " var dtf = dt.getFullYear();" | |
cd = cd & " dtf += '/' + (dt.getMonth()+1);" | |
cd = cd & " dtf += '/' + dt.getDate();" | |
cd = cd & " dtf += ' ' + dt.getHours();" | |
cd = cd & " dtf += ':' + dt.getMinutes();" | |
cd = cd & " dtf += ':' + dt.getSeconds();" |
NewerOlder