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

Category Archives: Power Query

Power Query tool examples.

Excel Power Query: decimal numbers from integers

Posted on 24 November 2017 by pawel
303

How to change integers into decimal numbers in Excel Power Query? When new application was creating, I’ve noticed that values from external database should be decimal numbers, but they wasn’t.

Continue reading →

Posted in Power Query | Tagged Power Query, Text.End, Text.Length, Text.Start | 303 Replies

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

  • Do antibiotics weaken your immune system on Folder creation
  • How do I know if antibiotics are working on Remote connection to MySQL
  • What vitamins fight infection on Removing row from DataGridView
  • Can I eat yogurt after antibiotics on Code lines added automatically to VBA module
  • What is the strongest antibiotic for bacterial infection on Creation installation file in Inno Setup

Categories

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