VBA not recognizing polish letters

Posted on 29 August 2018 by pawel

Although in the sheet we can insert Polish letters, we can’t use it in VBA console, for example when retrieving string values.

Continue reading →

Checking if another Worksheet is opened and its opening or closing

Posted on 13 December 2017 by pawel

Sometime we have to call another Worksheet to get some data. Thanks to this code we could check if data source file is opened or closed.

Continue reading →

Folder creation

Posted on 12 December 2017 by pawel

How to create folder in chosen localization with VBA? For one project I had to create folder. Had to search internet and as always helpful was site stackoverflow.com.

Continue reading →

Removing duplicates in collection

Posted on 11 December 2017 by pawel

When Microsoft is publishing new version of Excel they add new tools to Excel. I think in newest version of Excel there is duplicates remover. In Excel 2003 there wasn’t such a tool – I think there wasn’t? Few years ago writing application to support automatic warehouse there was need to extract unique batch numbers.

Continue reading →

Creating HTM file via Excel VBA

Posted on 10 December 2017 by pawel

This post VBA code never been used in final application by me – but in test files it was used. I’ve spent a little bit time on it. Code is quite interesting becasue of HTML tags used inside to create HTM file that is being opening in internet browser.

Continue reading →

Getting Windows user name

Posted on 8 December 2017 by pawel

There is not much to write about it. Short code to get Windows user name. Quite interesting is declaration for 32bit and 64bit systems. Unfortunately I’ve forgot source of code.

Continue reading →

Access database .accdb operations via Excel VBA

Posted on 8 December 2017 by pawel

When I had access to Office Access app I’ve done some test to connect Excel to .accdb database via VBA. Currently I don’t have Access license therefor I can’t verify if code is proper.

Continue reading →

Get SAP format date

Posted on 6 December 2017 by pawel

User’s SAP date format might a problem while using Excel VBA application connected to SAP . If SAP date format is different then Excel default format we will not able to make mathematics operation with dates.

Continue reading →

Removing row from DataGridView

Posted on 1 December 2017 by pawel

If user would like to edit some data in DataGridView he might remove selected row. DataGridView is a control to show data from database.

Continue reading →

Blocking X button in UserForm

Posted on 30 November 2017 by pawel

Many times I’ve wrote applications, where top right X button had to be disabled. Code has been borrowed from Johna Walkenbach.

Continue reading →

My Excel Database

My VBA codes history

VBA not recognizing polish letters

Although in the sheet we can insert Polish letters, we can’t use it in VBA console, for example when retrieving string values.

Checking if another Worksheet is opened and its opening or closing

Sometime we have to call another Worksheet to get some data. Thanks to this code we could check if data source file is opened or closed.

Folder creation

How to create folder in chosen localization with VBA? For one project I had to create folder. Had to search internet and as always helpful was site stackoverflow.com.

Removing duplicates in collection

Creating HTM file via Excel VBA

This post VBA code never been used in final application by me – but in test files it was used. I’ve spent a little bit time on it. Code is quite interesting becasue of HTML tags used inside to create HTM file that is being opening in internet browser.

Getting Windows user name

There is not much to write about it. Short code to get Windows user name. Quite interesting is declaration for 32bit and 64bit systems. Unfortunately I’ve forgot source of code.

Access database .accdb operations via Excel VBA

When I had access to Office Access app I’ve done some test to connect Excel to .accdb database via VBA. Currently I don’t have Access license therefor I can’t verify if code is proper.

Get SAP format date

User’s SAP date format might a problem while using Excel VBA application connected to SAP . If SAP date format is different then Excel default format we will not able to make mathematics operation with dates.

Removing row from DataGridView

If user would like to edit some data in DataGridView he might remove selected row. DataGridView is a control to show data from database.

Blocking X button in UserForm

Many times I’ve wrote applications, where top right X button had to be disabled. Code has been borrowed from Johna Walkenbach.