VSTO & .NET & Excel

August 13, 2014

Articles about installing softwares from SamLogic

I’m aware of the fact that I nowadays rarely make any posts here at all. One explanation is that I’m learning about new tools and that I find it very satisfaction and enjoyable.

Nevertheless, SamLogic, the Swedish vendor of Visual Installer and other excellent tools, have recently published some interesting articles which explain some important aspects when it comes to install softwares:

 

Happy coding everyone!

Dennis

May 13, 2014

Free ApressOpen eBook: Office 365

Filed under: .NET & Excel, Excel, Tools, VSTO & Excel — Dennis M Wallentin @ 7:31 pm

I’m still alive although it was quite a long time ago I published any article here. But now that I’m back I hope I will speed things up so You will see more activity of my blog.

Apress have a series of books that are made available for free. The series is  named ApressOpen eBooks and it’s the publisher branch’s “open source” program.

It should be noted that the series only includes eBooks.

Recently Apress announced that, among other titles, the book Office 365 is now part of the series.

The start page for ApressOpen eBooks: http://www.apress.com/open-source

Here is the URL to the book’s page: http://www.apress.com/9781430265269

Enjoy!

Kind regards,
Dennis

January 13, 2014

VBA Enumeration Database

Filed under: .NET & Excel, Database, Developer sites, Excel, SQL Server, SQLite, Tools, Valentina DB — Dennis M Wallentin @ 3:24 pm

Whenever CodeProject send their newsletter I take the time to read it more carefully. Although not every time but quite often I find one or more gems among the presented articles.

The article VBA Enumeration Database should be read by every seriously MS Excel developer as it covers one of the cornerstones in VBA development; interaction with databases.

So I recommend You to click on the above URL, start to read and then download the code!

Please note, You must be a member of CodeProject to download.

Kind regards,
Dennis

PS: I must confess; I have not written a single line of VBA code for the last 6-8 months. At least, what I can remember ;-)

January 1, 2014

Syncfusion’s Free Offers

Filed under: .NET & Excel, Apps for Office, COM Add-ins, Excel, SQL Server, SQLite, Tools, UI Design, Valentina DB, VSTO & Excel — Dennis M Wallentin @ 8:37 pm

During 2013 Syncfusion have been releasing additional books in the series of Succintly. They cover a lot of development areas and are all free (PDFs).

Not only books are shipped free. Syncfusion offers also for Hobbyist the Essential Studio for JavaScript.

Per se it’s not free as You need to pay $ 1 for 1 license which is also valid for next offer.

Another offer for Hobbyist  is the Essential Studio for WinRT (Windows 8.1)

The JavaScript Studio should attract Excel developers who develop so called Office Apps.

Anyway, I find it nice when a company like Syncfusion actually see the group of hobbyists.

Yes, I’m a full member of the Hobbyists group ;)

Happy Coding!

Dennis

December 9, 2013

Load and Help: SoftMaker’s FreeOffice suite

Filed under: .NET & Excel — Dennis M Wallentin @ 2:16 pm

SoftMaker have a yearly tradition, Load and Help, where they offer a free version of their Office suite, FreeOffice for the Windows platform and also the Linux platform.

This time the free package also includes a group of nice fonts.

For every download SoftMaker will pay € 10 to aid and charity projects around the world.

For more information please go to Load and Help site.

I find it to be a very nice approach and therefore give it my support.

Kind regards,
Dennis

November 19, 2013

Add-in Express Series for Excel Beginners

Filed under: .NET & Excel, Apps for Office, COM Add-ins, Excel, SQL Server, Tools, Valentina DB, VSTO & Excel, XLLs — Dennis M Wallentin @ 7:51 pm

Add-in Express have published a great number of interesting articles for Excel beginners. To be more specific, Excel beginners who use their All-in Framework .NET to create COM Add-ins, RDTs and Functions Libraries (XLLs and UDFs).

Here is the link to the first article in the series:
http://www.add-in-express.com/creating-addins-blog/2013/09/23/excel-addin-development-application-base-objects/

Enjoy!

Kind regards,
Dennis

October 30, 2013

Crazy things at a Peer Support forum

Filed under: About Nothing — Dennis M Wallentin @ 12:23 am

Let me tell You a story of a Peer Support Forum that do things totally different then other forums do. It’s remarkable that it happens 2013 at an US-centric forum as the actions are more like to be find in a country without any democracy.

# Moderators correct the English in use, especially when non-US citizens make post.

I find it very abusing. It’s like treating non-US citizens as second class members. It’s the first time for me. after all the years in the online communities, that my English has been corrected. It was also the first time where I explicit was abused for my poor English.

# Moderators remove threads that are critical in some way to the product the forum is based on.

I simple lack word for it.

# Members of the forum can be black listed if they continue to be critical.

Ditto

# Members who still not follow the rules are kicked out and blocked to access the forum.

Ditto

If You want to view it You can access it via the following URL:
http://www.powerbasic.com/support/pbforums/index.php

Of course, only customers to the product can be members.

In my next article I will discuss what customer service is for me and what it is for the company behind the product.

Kind regards,
Dennis

PS: If You want to spell check this blog article it’s not possible.

October 11, 2013

Apps Launcher – Windows 8

Filed under: Tools, Xojo — Dennis M Wallentin @ 11:44 pm

I have been using Windows 8 for a while. As most of us know it’s primarily for touch screens which can create some issues on the desktop. Most softwares I use are usually placed on the Task bar. Up to Windows 7 it worked well out.

With Windows 8 I started to notice that I sometime cannot access the Task bar. In other words it’s not accessible. Perhaps I have not found out the right keys combination. Of course, an even better solution may be to skip the Task bar in the first place.

So I decided to create a small utility, App Launcher, where my favorite tools are available for me. The screen shot below shows the UI for App Launcher.

AppLauncher

App Launcher is a test pilot. If things go well I will create a better tool that makes it possible to add/remove/replace tools. But at present I will test the App Launcher to find out if it suites me or not.

Is this kind of tool attractive for other users as well?

Edit: What I originally forgot to mention in this article is that with a (free) tool like App Launcher it will also be possible to start the tools with various start parameter(s).

Kind regards,
Dennis

PS: App Launcher is created with Xojo.

September 3, 2013

Great Articles based on Formulas only!

Filed under: .NET & Excel — Dennis M Wallentin @ 5:54 pm

Whenever I see solutions in MS Excel without the use of VBA it actually reveals the core power with functions and formulas. That’s why I want to highlight the excellent work made up at “E90E50fx….only formulas”.

It says “…only formulas” however it exist at least one article that includes VBA. But they are forgiven :)

The following link will take You to the site: https://sites.google.com/site/e90e50fx/home

Now I will go back to other activities excluding MS Excel!

Enjoy!

Kind regards,
Dennis

July 20, 2013

Ribbon Control – Xojo – Jérémie Leroy

Filed under: SQL Server, SQLite, Tools, UI Design, Valentina DB, Xojo — Dennis M Wallentin @ 2:57 pm

This is the first post of a series that will present controls and tools by Jérémie Leroy.

Why I pick these controls is quite simple to explain:

  • All controls and tools are of high quality
  • They are easy to work with, even for a newbie like me
  • They all support the RAD concept
  • The prices are reasonable given what we get for the money

First out is the tool for creating Ribbon UI in an easy way. It’s a visual designer tool that generates the required code to show and use the Ribbon UIs.

Interesting, when creating the Ribbon UI and the code for it we actually run in Debug mode.

The elements of the control are as the following picture shows:

RibbonElements

It’s easy to keep these three elements in mind. Next, let us have a look on the control itself. The following screen shot views the Ribbon UI tool:

RibbonStart
To start to add Tabs, Sections and Buttons we simple click on the Reorder Ribbon button. When adding new elements we can at the same time manipulate the added item. The following shows tries to show it:

RibbonUI1

When all the elements have been added to the Ribbon it can look as the following screen shot:

RibbonUIFinish

The last step to do is to generate the code to create the Ribbon UI. Click the button To XML/Xojo and it will very fast generate the required code to build the customized Ribbon UI.

RibbonUIFinal

The next and final step is simple to cut & paste the generated Xojo code to the Open event of  the RibbonCanvas objectet.

 Dim T As RibbonTab
 Dim S As RibbonSection
 Dim B As RibbonButton

 //Tab 1
 T = New RibbonTab("Home")
 me.Tabs.Append T

 S = New RibbonSection("Help")
 T.Sections.Append S

 B = New RibbonButton("btnDBHelp", "Database", Ico("database-help"), Nil)
 B.IconName = "database-help"
 S.Buttons.Append B
 B = New RibbonButton("btnQHelp", "Query", Ico("query-help"), Nil)
 B.IconName = "query-help"
 S.Buttons.Append B
 B = New RibbonButton("btnRHelp", "Report", Ico("report-help"), Nil)
 B.IconName = "report-help"
 S.Buttons.Append B

 S = New RibbonSection("Record")
 T.Sections.Append S

 B = New RibbonButton("btnAdd", "Add", Ico("button_green_add"), Nil)
 B.IconName = "button_green_add"
 S.Buttons.Append B
 B = New RibbonButton("btnUpdate", "Update", Ico("button_green_down"), Nil)
 B.IconName = "button_green_down"
 S.Buttons.Append B
 B = New RibbonButton("btnDelete", "Delete", Ico("button_red_delete"), Nil)
 B.IconName = "button_red_delete"
 S.Buttons.Append B

 S = New RibbonSection("Maintenance", "Maintenance")
 T.Sections.Append S

 B = New RibbonButton("btnDBCompress", "Compress Database", Ico("compress_database"), Nil)
 B.IconName = "compress_database"
 S.Buttons.Append B
 B = New RibbonButton("btnTableCompress", "Compress Table", Ico("compress_table"), Nil)
 B.IconName = "compress_table"
 S.Buttons.Append B
 B = New RibbonButton("btnDBBackup", "Backup Database", Ico("database_backup"), Nil)
 B.IconName = "database_backup"
 S.Buttons.Append B

 S = New RibbonSection("Query")
 T.Sections.Append S

 B = New RibbonButton("btnQuery", "Query", Ico("query"), Nil)
 B.IconName = "query"
 S.Buttons.Append B
 B = New RibbonButton("btnLookup", "Lookup", Ico("query_lookup"), Nil)
 B.IconName = "query_lookup"
 S.Buttons.Append B
 B = New RibbonButton("btnQueryDB", "Query Database", Ico("query-database"), Nil)
 B.IconName = "query-database"
 S.Buttons.Append B
 B = New RibbonButton("btnExecute", "Execute", Ico("query-execute"), Nil)
 B.IconName = "query-execute"
 S.Buttons.Append B

 S = New RibbonSection("Report")
 T.Sections.Append S

 B = New RibbonButton("btnReport", "Report", Ico("report"), Nil)
 B.IconName = "report"
 S.Buttons.Append B
 B = New RibbonButton("btnOpenReport", "Open Report", Ico("report_open-add"), Nil)
 B.IconName = "report_open-add"
 S.Buttons.Append B
 B = New RibbonButton("btnMailReport", "Mail Report", Ico("report_open-mail"), Nil)
 B.IconName = "report_open-mail"
 S.Buttons.Append B

me.Height = me.BestHeight

As part of the solution there is also a support function to work with the added icons:


Ico(Name As String, Debug As Boolean = False) As Picture

If IconList.HasKey(Name) then
 Return IconList.Value(Name)
 elseif Debug then
 #if DebugBuild
 break
 #endif
 End If

 Return New Picture(1, 1, 32)
 Return Nil

As we can see, it’s a quite straight forward code. It simple to follow and to maintenance it.

Here are the interesting links to Jérémie’s site and productpage:

Enjoy!

Kind regards,

Dennis

Edit Note: Of course, I should also mention that the professional icons in use are made by Axialis.

Older Posts »

The Silver is the New Black Theme. Blog at WordPress.com.

Follow

Get every new post delivered to your Inbox.

Join 37 other followers