Skip to primary content
Skip to secondary 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

Author Archives: pawel

Post navigation

← Older posts

VBA not recognizing polish letters

Posted on 29 August 2018 by pawel
658

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 →

Posted in VBA | Tagged control panel, polish letters, region | 658 Replies

Text value dividing

Posted on 20 December 2017 by pawel
443

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 →

Posted in VB | Tagged Array, divide text, InStr, Space, Split | 443 Replies

Item removing from MySQL via Visual Basic

Posted on 20 December 2017 by pawel
598

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 →

Posted in VB | Tagged Connection to MySQL, delete from, item removing | 598 Replies

UnobtrusiveValidationMode jquery w VS for Web

Posted on 18 December 2017 by pawel
525

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 →

Posted in VB.net | Tagged jQuery, login, UnobtrusiveValidationMode jquery | 525 Replies

Connection string encryption in VB.Net

Posted on 14 December 2017 by pawel
950

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 →

Posted in VB.net | Tagged ConnectionString, Encryption, GridView, MySQL, MySQL Connection | 950 Replies

Checking if another Worksheet is opened and its opening or closing

Posted on 13 December 2017 by pawel
667

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 →

Posted in VBA | Tagged File copying, File open, Save Changes | 667 Replies

Folder creation

Posted on 12 December 2017 by pawel
382

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 →

Posted in VBA | Tagged Chr(34), Creation, double-quotes, Folder | 382 Replies

Removing duplicates in collection

Posted on 11 December 2017 by pawel
386

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 →

Posted in VBA | Tagged Duplicates Remover, RemoveDuplicates | 386 Replies

Creating HTM file via Excel VBA

Posted on 10 December 2017 by pawel
644

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 →

Posted in VBA | Tagged HTM, HTM creating, HTML | 644 Replies

Getting Windows user name

Posted on 8 December 2017 by pawel
268

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 →

Posted in VBA | Tagged Getting User Name | 268 Replies

Post navigation

← Older posts

Language

English Polski

About website

Website showing coding examples found in internet and  used by me. Was created in order to find working code in new projects. This is a source for my future applications to find needed code fast and easily.

Video presentation (PL)

https://www.youtube.com/watch?v=ysJDqAbEOSQ

Visual Basic .NET

  • UnobtrusiveValidationMode jquery w VS for Web

    I’ve wanted to add login control to my test website... Read more →

  • Connection string encryption in VB.Net

    After hours of tests I’ve succeeded in ConnectionString encryption in... Read more →

  • Filling and centering GridView in VB.NET

    GridView in VB.NET is the same control as DataGridView in... Read more →

  • ConnectionString for MySQL w VB.NET

    ConnectionString for MySQL w VB.NET For now I’ve only tested... Read more →

Visual Basic

  • Text value dividing

    Something we have to divide some text value for two... Read more →

    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.

    (more…)

  • Item removing from MySQL via Visual Basic

    In the project I still making I’m using MySQL database... Read more →

    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?

    (more…)

Recent Posts

  • 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

Recent Comments

  • bucha killings on Text value dividing
  • bucha killings on Item removing from MySQL via Visual Basic
  • bucha killings on Blocking X button in UserForm
  • bucha killings on Dynamic drop down list with array source
  • bucha killings on VBA not recognizing polish letters

Categories

  • Excel
  • Others
  • Power Query
  • VB
  • VB.net
  • VBA
Proudly powered by WordPress