VB6: Manage Excel Reports Not By Automation

By | 2017-03-21

Introduction Ever since I wrote the first VB6 article and MS Excel automation I have had this type of article in my mind. As this article shows, it’s possible to interact with workbooks without having MS Excel installed even with an old tool like classic VB. Here the classic Microsoft ActiveX Data Object (ADO) model is used to retrieve data… Read More »

admin

Xojo: Manage Excel Reports Through Automation

By | 2017-03-15

Introduction Here I go again! This time I use Xojo to control and manipulate MS Excel’s files with. Here I use the add-in for MS Office that is shipped with Xojo. It requires that MS Excel is installed. At present I look through my add-ins to see if I still have the add-in for MS Excel and that… Read More »

admin

Xojo: Call for MS Excel – Another Spreadsheet is Opened!

By | 2017-03-14

On my computer I have MS Excel installed together with several other Spreadsheet software. Among the other Spreadsheet software installed I have WPS Office installed. Don’t recall how I got it… When I ran the following code in Xojo I assumed MS Excel would have been loaded, right? The following screenshot shows that the file, a MS Excel… Read More »

admin

DevExpress: Manage Excel Reports Through Automation

By | 2017-03-03

Introduction In the past the common approach to manage Excel files was to install MS Excel on the server. For years it was applied despite Microsoft disagreement to do so. Today the situation is totally changed. Many third-part vendors provide us with solutions that do not require MS Excel to be available at all. For me automation has… Read More »

admin

VB6: Down the memories line – Automation of MS Excel

By | 2017-02-11

When I wrote the article about B4J and MS Excel I got a stronger feeling on publishing the report solutions based on Classic VB (VB6).  Here it is and I’m happy to share it with You. Despite all the great new developing tools outhere I still prefer to use Classic. Why? Because it’s still an excellent RAD-Tool. The following code is used… Read More »

admin

MS Excel not Your Default Program…

By | 2017-02-08

I couldn’t resist posting this message: What I guess is that everyone else who pretend to be nerd has MS Excel as its default program for viewing and editing spreadsheets 🙂 The question is, what other spreadsheet program is my default? Well, in an upcoming blog I will reveal it! Stay tune, Dennis

admin

B4J: Generate Excel Reports

By | 2017-01-24

Introduction The real power for using MS Excel workbooks as reports lays in the fact that we can create templates. A template in MS Excel is saved with the file extension *.xltx (*.xlt for older versions, 2007 and earlier) where the “t” stands for template. The key feature with it is that whenever we open it via code… Read More »

admin

B4J: The True Successor of MS VB6

By | 2017-01-10

The title may be surprising but let me extend it further in this blog article. The first question we should ask us is: What is B4J? A development tool for cross platform development, i e B4J creates solutions for Windows, Linux, Apple et al. It also creates Console applications. It’s also a server side development platform mainly for… Read More »

admin

Welcome to WinTools!

By | 2016-12-17

Things should be fun to do and that’s why I have set up this blog. Actually, the blog should be viewed as a fun hobby to me because I like to write, share and discuss software development. It’s all about Window Tools which includes several platforms like Windows, Mobile (Android) and Zorin (Linux) and several languages that I use for… Read More »

admin