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

Post navigation

← Older posts

VBA not recognizing polish letters

Posted on 29 August 2018 by pawel
573

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 | 573 Replies

Checking if another Worksheet is opened and its opening or closing

Posted on 13 December 2017 by pawel
586

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 | 586 Replies

Folder creation

Posted on 12 December 2017 by pawel
320

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 | 320 Replies

Removing duplicates in collection

Posted on 11 December 2017 by pawel
310

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 | 310 Replies

Creating HTM file via Excel VBA

Posted on 10 December 2017 by pawel
561

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 | 561 Replies

Getting Windows user name

Posted on 8 December 2017 by pawel
189

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 | 189 Replies

Access database .accdb operations via Excel VBA

Posted on 8 December 2017 by pawel
708

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 →

Posted in VBA | Tagged .accdb, Access, INSERT, SELECT, UPDATE | 708 Replies

Get SAP format date

Posted on 6 December 2017 by pawel
77

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 →

Posted in VBA | Tagged SAP date format, SU3 | 77 Replies

Removing row from DataGridView

Posted on 1 December 2017 by pawel
520

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 →

Posted in VBA | 520 Replies

Blocking X button in UserForm

Posted on 30 November 2017 by pawel
287

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

Continue reading →

Posted in VBA | Tagged UserForm, X button | 287 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

  • cialis from india on Adding quotation marks to string
  • northwest pharmacies on Filling and centering GridView in VB.NET
  • asebg.bigcartel.comcanadian-pharmacy on Get SAP format date
  • https://asebg.bigcartel.com/canadian-pharmacy on Blocking X button in UserForm
  • https://asebg.bigcartel.com/canadian-pharmacy on Access database .accdb operations via Excel VBA

Categories

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