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

May 30, 2013

SQLabs SQLite Tools

Filed under: .NET & Excel, Apps for Office, COM Add-ins, Database, Excel, LiveCode, Real Basic Developing, SQLite — Dennis M Wallentin @ 5:42 pm

We all get some favorite tools, tools that we use on a regular basis. They usually do the work fast and effective. I still use SQLite databases and have done it more then eight years or so. The SQLite database is great for a various tasks, especially as an embedded database. It’s easy to work with in all the environments I move between, VB6 / VB.NET / LiveCode / Real Studio (Xojo) / PowerBasic & EZ GUI / NSB AppStudio.

The key to successfully use SQLite in different solutions is the tools I administrate SQLite databases with. For some years ago I stumbled over a site that caught my interest, http://www.sqlabs.net/.

When looking into it I read about some tools that could help me manage SQLite databases. The first tool was the SQLite Manager which turned out to be a powerful database management tool. The following picture is a screen shot of it:

SQLiteManager

Next, I needed to port two databases, i e so called Access database and then I tried the SQLite Converter. Success! Since then I always use SQLabs’s Converter. Yes, the below screen shot shows the SQLite Converter in action:

SQLiteConverter

For a year ago or so SQLabs published an excellent offer for their relational database management system (DBMS) named to cubeSQL:

  • A Developer key :  Unlimited connections key but requires you to restart the server every 4 hours or
  • A Freeware key: Max 3 concurrent connections key without any time limitation.

Some months later, after the publish, I needed a server for my SQLite databases. I then remembered this kind offer. Now I nearly cannot live without it.

The following screen shot shows the cubeSQL in action:

cubeSQL

In my personal opinion these tools are highly recommended and the price of each SQLite tool should not scare anyone away.

They, SQLabs, also offer some more tools that may be is of interest.

For more information, please visit their site: http://www.sqlabs.net/

Enjoy!

Kind regards,
Dennis

April 7, 2013

Time to move on – Exit MVP Program

Filed under: .NET & Excel, .NET Books, Apps for Office, COM Add-ins, Excel, SQL Server, VSTO & Excel, VSTO Books, XLLs — Dennis M Wallentin @ 4:27 pm

Around 2005 – 2006 I peaked with MS Excel, since then I have slightly moved away from it year to year. In 2010 I was honored to become part of Microsoft’s MVP-program.

Of course, it was interesting to get another position and more closed to Microsoft in general, the production team in particularly. However, I never got excited about it as I was moving away from MS Excel. In addition, I didn’t put much efforts to support the online community in various forms.

Given the circumstances I finally took the decision to not be up for the next renewal process. Looking back I can conclude that it has been an amazing time, from the 80’s and until now. I have also achieved more than what I thought was possible. In other words, I have nothing more to proof. So I can walk away and looking ahead for new adventures in the world of softwares.

But before I close the MS Excel book I have one thing I would like to point out and to discuss. Let me first conclude that Microsoft have never really been loyal to the group of developers for MS Excel. It’s regretful as the group have a strong commitment and interest of developing MS Excel further.

In the beginning we got the macro language, XLM, which we started to use more and more. Then VBA and VB6 came and Microsoft asked us to drop XLM in favor of these two Basic languages. 10 years later VB6 was depreciated and since then VBA also risk to be depreciated. Microsoft asked us to replace them with .NET and VSTO. 10 years later .NET and VSTO face the same situation as VB6, i.e to be depreciated. Microsoft now ask us to start develop with Apps for Office. Given the short history, i.e about 20 years, it’s remarkable the number of changes Microsoft have done.

In my opinion, Microsoft’s trust capital is now below zero due to lack of loyalty Microsoft show the group of MS Excel developers. The question is not about Apps for Office rather what will come next?

But it’s no longer of interest for me. I’m moving along and I set focus on other tools and platforms. The blog will change its name and extend its contest with other tools including other platforms. Actually, I will go back to VB6, pick up new tools like PowerBasic and PureBasic which will allow me to write everything in code, including the UI.  Other tools I have picked up is Real Studio and LiveCode together with my two favorites databases; Valentina and Ninja Pro.

I have uninstalled Office 2013 and replaced it with the 2000 version. I may re install it later on in case I find Apps for Office interesting unless it has been already replaced with something new!

It has been a fantastic time in my life to be part of the online Excel community and be part of an exciting time for MS Excel. My English has been improved with >90 %.  I have some good friends around the globe . So without mention any names I would finally say:

Thank You all!

Kind regards,
Dennis

March 31, 2013

MarieDB

Filed under: .NET & Excel, COM Add-ins, Excel — Dennis M Wallentin @ 2:12 pm

How many know about the database MarieDB? The database is growing faster and faster. It takes market shares from MySQL.  Why just from MySQL?

MarieDB is a drop-in replacement for MySQL. It means that we can access and work with as it was a MySQL database. The differences between them are improvements made in MarieDB.

Among the people that stand behind MarieD is Michael “Monty” Widenius the creator of MySQL. The issues with MySQL license model have pushed more and more corporates and individuals to switch to MarieDB. The future of MySQL can now be questioned, especially when Oracle is involved.

The start page of MarieDB: https://mariadb.org/

The start page for AskMonty Knowledge Base: SkySQL: https://kb.askmonty.org/en/

MariaDB-seal

Enjoy!

Kind regards,
Dennis

March 28, 2013

Combinatorics Using Excel Formulas

Filed under: .NET & Excel, COM Add-ins, Excel, XLLs — Dennis M Wallentin @ 8:45 pm

I have the honor to know Roberto Mensa via Linked In. He is strongly committed to explore, develop, improve and to discuss formulas in Excel. The site is fully dedicated to Excel formulas. If You’re serious about MS Excel then this site is a must.  Of course, he is not alone, another great contributor is Krisztina Szabó aka Kris.

The virtual spot has the name E90E50 fx. I have no ideas for what it stand for…

Anyway, You may start at the following point: E90E50 fx.

The link points to the main page. However, the latest contribution is Combinatorics using Excel formulas.

Make sure You have some hours free to take part of the contribution. Don’t forget to bring coffee to the computer.

Enjoy and have a nice Easter Weekend!

Kind regards,
Dennis

March 24, 2013

Clean Up!

As part of my maintenance, in order to keep the computer fresh, is to regular run the built-in tool Free up disk space.

The tool is accessible via the following commands:

  • Start Button > Control Panel > System and Security > Administrative Tools > Free up disk space

After running it the following dialog is showed:

CleanUp

Yes, I admit it was some time ago since I last executed the clean up process. However, I cannot understand how Temporary Files can grow to a size of 30 GB?

In addition, does anyone know if it exist a small utility that can automatically clean up Temporary Files?

The general recommendation is to not forget to run the Free up disk space on a regular basis!

Kind regards,
Dennis

Older Posts »

Create a free website or blog at WordPress.com.