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

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 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.

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.

March 18, 2013

Great News From Paradigma Software & Syncfusion Inc

Paradigma Software released version 5.0 of its Valentina Database and tools. The hard databases competition is an advantage for us developers; we get better tools and more for our money.

Paradigma Software continue to offer some great tools for free;

  • An updated and more powerful Valentina Studio which now also supports MySQL DB, PostgreSQL DB. And since prevously version Valentina Dbs and SQLite Dbs
  • An updated and more powerful Valentina Server / 5

Of course, Paradigma Software also offers Premium products such as  Valentina Server , Valentina Studio Pro and a great number of ADKs and Report ADKs  for nearly all existing developing platforms.

For more information please visit:

Valentina DB5

Syncfusion, Inc, have also released new versions of their first class components for the .NET platform, WinRT and Windows Phone (Beta). Check it out at:

syncfusion_logo_slogan_300px

Kind regards,
Dennis

PS: I have no commercial interest in any business. I’m just a pleased customer who believes that high quality tools and components should be expoxed to other developers.

February 22, 2013

POEditor: An Excellent Translation Tool!

It’s very exceptionable that I get thrilled over a software. The last time must be the first version of Excel 2.1d, that’s nearly 30 ago, I got in my hand!

I can only say that it’s an excellent software and it’s also free. It’s so good that I say its speak for itself.

The URL to POEditor is: http://poeditor.com/

Enjoy!

Kind regards,
Dennis

February 21, 2013

Black clouds over MS Office 2013

Filed under: .NET & Excel, Apps for Office, Excel, Tools, VSTO & Excel — Dennis M Wallentin @ 4:47 pm

I’m getting worried over what’s going on. For every new version of Office and Excel there has been a positive tone in the online community and an excitement with the new features.

But that’s not really true with MS Office 2013. The terms to use a license shrink and some features are no longer available in some packages like Office Professional effectively prevent all happiness with the new version.

Instead of going on with the details I give two URLs that explain the new issues with Office 2013.

If we view it friendly we could say that both the new license agreement and the lack of some tools are due to that the new version actually targets smart devices and pads. It makes sense that softwares are tight to the devices in a different way than to the Desktop platform.

However, the future is not here yet so still the Desktop platform plays a critical role and will still do it for some time.

The only reasonable conclusion is to not upgrade to MS Office 2013.

  • If we have MS Office 2010 there is no reason to upgrade to MS Office 2013.
  • If we have MS Office 2003 or MS Office 2007 then consider to upgrade to MS Office 2010 but not MS Office 2013.

The above two alternatives offer best value for our money and still support our business very well.

It will also send a clear message to Microsoft: Do it again! Do it right!

Kind regards,
Dennis

Older Posts »

Blog at WordPress.com.