Skip to primary content

My Excel Database

My VBA codes history

My Excel Database

Main menu

  • Home
  • Posts’ list
  • Other
    • VB.net
    • VB
    • WordPress
    • Others
  • Contact
  • About me
  • Log In

Posts’ list

Already published posts on exceldb.net.

VBA category:

  • VBA not recognizing polish letters
  • Checking if another Worksheet is opened and its opening or closing
  • Folder creation
  • Removing duplicates in collection
  • Creating HTM file via Excel VBA
  • Getting Windows user name
  • Access database .accdb operations via Excel VBA
  • Get SAP format date
  • Removing row from DataGridView
  • Blocking X button in UserForm
  • Code lines added automatically to VBA module
  • Dynamic drop down list with array source
  • Dynamic variable
  • How to check if sheet with specific name exist?
  • Global error handling
  • Adding VBA code lines automatically
  • XLAM add-in as database
  • Create Pivot table thru VBA
  • Connection to SAP HANA via Excel VBA
  • File Picker
  • Adding quotation marks to string
  • Remote connection to MySQL
  • Msgbox with link redirection to website

Excel category:

  • Excel XLAM add-ins creation

Power Query category:

  • Excel Power Query: decimal numbers from integers

VB category:

  • Text value dividing
  • Item removing from MySQL via Visual Basic

VB.net category:

  • UnobtrusiveValidationMode jquery w VS for Web
  • Connection string encryption in VB.Net
  • Filling and centering GridView in VB.NET
  • ConnectionString for MySQL w VB.NET

WordPress category:

Others category:

  • MySQL: query with joining two tables
  • Creation installation file in Inno Setup
  • Remote connection to MySQL

Proudly powered by WordPress