Skip to content

Instantly share code, notes, and snippets.

@zohann
zohann / ConfigManager.bas
Last active March 12, 2026 13:05
VBA INI Configuration Manager
Attribute VB_Name = "ConfigManager"
Option Explicit
' API функции для работы с INI-файлами
Private Declare Function GetPrivateProfileString Lib "kernel32" Alias "GetPrivateProfileStringA" ( _
ByVal lpApplicationName As String, _
ByVal lpKeyName As Any, _
ByVal lpDefault As String, _
ByVal lpReturnedString As String, _
ByVal nSize As Long, _
@zohann
zohann / NextcloudUpload.vba
Created March 11, 2026 13:14
Nextcloud VBA Upload - Upload files to Nextcloud via WebDAV (FIXED)
' =============================================================================
' Nextcloud File Upload via WebDAV (VBA)
' =============================================================================
' Requires: App Password from Nextcloud settings (Security -> App passwords)
' URL format: https://domain/remote.php/dav/files/USERNAME/path/to/file
' =============================================================================
Option Explicit
' Main upload function
@zohann
zohann / NextcloudUpload.vba
Created March 11, 2026 12:55
Nextcloud VBA Upload - Upload files to Nextcloud via WebDAV
' =============================================================================
' Nextcloud File Upload via WebDAV (VBA)
' =============================================================================
' Requires: App Password from Nextcloud settings (Security -> App passwords)
' URL format: https://domain/remote.php/dav/files/USERNAME/path/to/file
' =============================================================================
Option Explicit
' Main upload function
@zohann
zohann / keep_screen_on_key.py
Created February 27, 2026 09:18
Keep screen on (Key press) - prevents screen from turning off by simulating key press
import ctypes
import time
# Virtual key code (F15 = 0x7E)
VK_F15 = 0x7E
# Flags for keyboard_event
KEYEVENTF_KEYUP = 0x0002
KEYEVENTF_EXTENDEDKEY = 0x0001
@zohann
zohann / keep_screen_on.py
Created February 27, 2026 09:17
Keep screen on (Windows) - prevents screen from turning off
import ctypes
import time
# Constants for SetThreadExecutionState
ES_CONTINUOUS = 0x80000000
ES_SYSTEM_REQUIRED = 0x00000001
ES_DISPLAY_REQUIRED = 0x00000002
def keep_screen_on():
"""Prevents screen from turning off and system from sleeping."""
@zohann
zohann / access_config_solution.txt
Created February 26, 2026 07:17
MS Access - Подключение к разным БД по пользователю
================================================================================
РЕШЕНИЕ: Подключение к разным табличным БД в MS Access на основе пользователя
================================================================================
1. КОНФИГУРАЦИОННЫЙ ФАЙЛ (config.json)
================================================================================
{
"managements": {
"management1": {