VBA not recognizing polish letters

Posted on 29 August 2018 by pawel

171

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 →

Text value dividing

Posted on 20 December 2017 by pawel

121

Something we have to divide some text value for two separated elements. VBA code contained to this post show how to do this. Of course shown code is quite simple – it has to be rebuilt for yours needs.

Continue reading →

Item removing from MySQL via Visual Basic

Posted on 20 December 2017 by pawel

170

In the project I still making I’m using MySQL database to storing items. We can remove items from database. How to remove item from MySQL via Visual Basic?

Continue reading →

UnobtrusiveValidationMode jquery w VS for Web

Posted on 18 December 2017 by pawel

125

I’ve wanted to add login control to my test website but unfortunately every time UnobtrusiveValidationMode jquery error be shown. App returned error with description that „ScriptResourceMapping for ‚jquery’” is required.

Continue reading →

Connection string encryption in VB.Net

Posted on 14 December 2017 by pawel

215

After hours of tests I’ve succeeded in ConnectionString encryption in asp.net. I’m not sure if code will work because I’ve done vb.net encryption in my test local website. What more, I’ve made vb.net websites for fun to learn something new.

Continue reading →

Checking if another Worksheet is opened and its opening or closing

Posted on 13 December 2017 by pawel

181

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

108

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

121

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 →

My Excel Database

My VBA codes history

Author Archives: pawel

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.

Text value dividing

Something we have to divide some text value for two separated elements. VBA code contained to this post show how to do this. Of course shown code is quite simple – it has to be rebuilt for yours needs.

Item removing from MySQL via Visual Basic

In the project I still making I’m using MySQL database to storing items. We can remove items from database. How to remove item from MySQL via Visual Basic?

Connection string encryption in VB.Net

After hours of tests I’ve succeeded in ConnectionString encryption in asp.net. I’m not sure if code will work because I’ve done vb.net encryption in my test local website. What more, I’ve made vb.net websites for fun to learn something new.

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.