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