New milestone version, 3.0, with the following improvements: - Code updated to support Office 2016-21 (32 and 64-bit) in MSI-based and Click-To-Run installations of Office 365 cloud-based services. - Code changed in both utilities improving its integration with the latest version of Popup Calendar for Excel already available on this site. |
Fixed an issue in the Popup Calendar for Excel utility on Windows 11 where it or its icon appeared far from the cell that caused the popup. |
Fixed two issues in the Excel Free utility, ExcelFre.exe, where the Excel 365 window was hidden when opening an XL file and the association of its file extensions was not working in Windows 11. |
Fixed an issue in the Word Free utility, WordFree.exe, where the association of its file extensions was not working in Windows 11.
|
Fixed an issue in the PowerPoint Free utility, PptFree.exe, where the association of its file extensions was not working in Windows 11. |
Fixed an issue in the Access Free utility, AccFree.exe, where the association of its file extensions was not working in Windows 11. |
New milestone version, 2.0, with the following improvements: - Code updated to support Office 2016-21 (32 and 64-bit) in MSI-based and Click-To-Run installations of Office 365 cloud-based services. |
New milestone version, 4.0, with the following improvements: - Code updated to support Office 2016-21 (32 and 64-bit) in MSI-based and Click-To-Run installations of Office 365 cloud-based services. |
New milestone version, 2.0, with the following improvements: - Code updated to support Office 2016-21 (32 and 64-bit) in MSI-based and Click-To-Run installations of Office 365 cloud-based services. - The portable file, instead of XLS or XLSX, can be saved as a Word document in doc or docx format or, via Excel, as PDF, txt, csv and all other formats supported by Excel. - Improvements in the functions provided for the VBA project with the description of richer examples on the homepage. |
Fixed the problem where the {VK nn} code to send the API virtual key of decimal code nn in NORMAL WAY (downing and releasing) was not releasing a previously sent {VK_nn} code for ONLY DOWNING. |
Fixed problem when decompiling Excel files with template extension (.XLT or .XLTM). |
All utilities that already supported Office 2016 also supported Office 2019 in all tests without needing to be changed, except for quotes on forms and documents. |
In order to reduce false positive alerts, all EXEs and DLLs files, and all VBA code in the files distributed on the site are digitally signed with a certificate issued to Francisco Orlando Magalhães Filho by Sectigo RSA Code Signing CA, including, and especially, the XLtoEXE, DBtoEXE, DOCtoEXE, and PPtoEXE converters. The EXEs converted by them now also support their users' signature. |
Problems were fixed about error messages of zlib123.dll not found or corrupted in native Windows installations in non-Western languages.
|
Problems were fixed about error messages of zlib123.dll not found or corrupted in native Windows installations in non-Western languages. |
Problems were fixed about error messages of zlib123.dll not found or corrupted in native Windows installations in non-Western languages. |
Problems were fixed about error messages of zlib123.dll not found or corrupted in native Windows installations in non-Western languages. |
New milestone version with improvement and addition of new features that significantly increased the integration of the stopwatch with Excel sheet: - Excel cell can functions as another stopwatch button, similar to the Stop-Insert button, where the act of selecting the cell functions as to trigger, however conditions can be set so that the triggering happens. So, only trigger when selecting cells: (1) With Time Format, (2) With Empty Content, (3) In Active Sheet when Started, (4) In Active Row when Started, or (5) In Active Column when Started. The trigger behavior can also be set to: (1) Stop, Insert, and Close the stopwatch, (2) Stop, Insert, and Reset, (3) Stop, Insert, Reset, and Start, (4) Stop and Inset, or (5) Insert only. And it can also be set to insert the result: (6) In Current Active Cell or (7) In Active Cell When Started. All these options are described as well in the main menu, in "Excel Cell as Button" new sub menu. - Excel cell can functions as stopwatch display where the contents or count on the display echoes in the contents or value of the active cell when started with the following setting options: (1) Echo Only on Time Format Cells and/or (2 ) Autohide Stopwatch When Mouse Move Away. These options are described as well in the main menu, in "Excel Cell as Display" new sub menu. - If set for multiple instances and to anchor in the active cell when started, when selecting multiple cells and acting Stopwatch command, you can create an instance in each one of all selected cells at once. - Each of the Stop, Restart, Countdown (CntDown), Split/Snapshot, Copy, Paste, and Display Panel (dp) buttons in the interface now can be disabled when not useful, preventing them from being unduly pressed. - The fStopwatch() function in VBA was improved and now its arguments support all options of: Label Snapshots, skin setting, setting to Excel cells function as stopwatch buttons, setting to Excel cells function as stopwatch displays, and setting of events when a countdown expires. - The GetVersion () function in VBA was improved and now also returns the number of stopwatch instances currently running and can close them all at once. All these news are detailed on own Stopwatch homepage where they are followed by the text (New or Improved in version 4.0...) in red. Also on the homepage, existing and 16 new examples were gathered in a new topic named Examples of Using the Stopwatch. |
Fixed problem where, in case of error in the decompilation of a selected file via interface, this didn't back to a new attempt or to select another file. The waiting time for one locked file perhaps be released by the system was also increased. It was also implemented a new item on the homepage, Executing via Command Line, with examples. |
Now all utilities on the site are tested and suitable for Office 2016. |
Problems were fixed when inserting characters from non-western languages in the Start Alert setting and the quality of its icon was also improved. |
Problems were fixed when inserting characters from non-western languages in the Start Alert setting and the quality of its icon was also improved. |
Problems were fixed when inserting characters from non-western languages in the Start Alert setting and the quality of its icon was also improved. |
Problems were fixed when inserting characters from non-western languages in the Start Alert setting and the quality of its icon was also improved.
|
Code updated to support Windows 8 (32 and 64-bit) and Office 2013 (32 and 64-bit) in MSI-based and Click-To-Run installations of Office 365 cloud-based services. |
Code updated to support Windows 8 (32 and 64-bit) and Office 2013 (32 and 64-bit) in MSI-based and Click-To-Run installations of Office 365 cloud-based services. |
Code updated to support Windows 8 (32 and 64-bit) and Office 2013 (32 and 64-bit) in MSI-based and Click-To-Run installations of Office 365 cloud-based services. |
Code updated to support Windows 8 (32 and 64-bit) and Office 2013 (32-bit) in MSI-based and Click-To-Run installations of Office 365 cloud-based services. |
Code updated to support Windows 8 (32 and 64-bit) and Office 2013 (32-bit) in MSI-based and Click-To-Run installations of Office 365 cloud-based services. |
Code updated to support Windows 8 (32 and 64-bit) and Office 2013 (32-bit) in MSI-based and Click-To-Run installations of Office 365 cloud-based services. |
Code updated to support Windows 8 (32 and 64-bit) and Office 2013 (32-bit) in MSI-based and Click-To-Run installations of Office 365 cloud-based services. |
Code updated to support Windows 8 (32 and 64-bit) and Office 2013 (32-bit) in MSI-based and Click-To-Run installations of Office 365 cloud-based services. |
Code updated to support Windows 8 (32 and 64-bit) and Office 2013 (32-bit) in MSI-based and Click-To-Run installations of Office 365 cloud-based services. |
Code updated to support Windows 8 (32 and 64-bit) and Office 2013 (32-bit) in MSI-based and Click-To-Run installations of Office 365 cloud-based services.
|
Code updated to support Windows 8 (32 and 64-bit) and Office 2013 (32-bit) in MSI-based and Click-To-Run installations of Office 365 cloud-based services. |
Code updated to support Windows 8 (32 and 64-bit) and Office 2013 (32-bit) in MSI-based and Click-To-Run installations of Office 365 cloud-based services. |
Code updated to support Windows 8 (32 and 64-bit) and Office 2013 (32-bit) in MSI-based and Click-To-Run installations of Office 365 cloud-based services. |
Code updated to support Windows 8 (32 and 64-bit) and Office 2013 (32-bit) in MSI-based and Click-To-Run installations of Office 365 cloud-based services. |
Code updated to support Windows 8 (32 and 64-bit) and Office 2013 (32-bit) in MSI-based and Click-To-Run installations of Office 365 cloud-based services. In addition, some minor problems and inconsistencies from the first version were duly fixed. |
Code updated to support Windows 8 (32 and 64-bit) and Office 2013 (32-bit) in MSI-based and Click-To-Run installations of Office 365 cloud-based services. |
Code updated to support Windows 8 (32 and 64-bit) and Office 2013 (32-bit) in MSI-based and Click-To-Run installations of Office 365 cloud-based services. |
Code updated to support Windows 8 (32 and 64-bit) and Office 2013 (32-bit) in MSI-based and Click-To-Run installations of Office 365 cloud-based services. |
Code updated to support Windows 8 (32 and 64-bit) and Office 2013 (32-bit) in MSI-based and Click-To-Run installations of Office 365 cloud-based services. |
Code updated to support Windows 8 (32 and 64-bit) and Office 2013 (32-bit) in MSI-based and Click-To-Run installations of Office 365 cloud-based services.
|
Code updated to support Windows 8 (32 and 64-bit) and Office 2013 (32-bit) in MSI-based and Click-To-Run installations of Office 365 cloud-based services. |
Code updated to support Windows 8 (32 and 64-bit) and Office 2013 (32-bit) in MSI-based and Click-To-Run installations of Office 365 cloud-based services. |
Code updated to support Windows 8 (32 and 64-bit) and Office 2013 (32-bit) in MSI-based and Click-To-Run installations of Office 365 cloud-based services. |
Code updated to support Windows 8 (32 and 64-bit) and Office 2013 (32 and 64-bit) in MSI-based and Click-To-Run installations of Office 365 cloud-based services. |
Code updated to support Windows 8 (32 and 64-bit) and Office 2013 (32 and 64-bit) in MSI-based and Click-To-Run installations of Office 365 cloud-based services. |
Code updated to support Windows 8 (32 and 64-bit) and Office 2013 (32 and 64-bit) in MSI-based and Click-To-Run installations of Office 365 cloud-based services. |
Code updated to support Windows 8 (32 and 64-bit) and Office 2013 (32 and 64-bit) in MSI-based and Click-To-Run installations of Office 365 cloud-based services. |
Code updated to support Windows 8 (32 and 64-bit) and Office 2013 (32 and 64-bit) in MSI-based and Click-To-Run installations of Office 365 cloud-based services. |
Code updated to support Windows 8 (32 and 64-bit) and Office 2013 (32 and 64-bit) in MSI-based and Click-To-Run installations of Office 365 cloud-based services. |
Code updated to support Windows 8 (32 and 64-bit) and Office 2013 (32 and 64-bit) in MSI-based and Click-To-Run installations of Office 365 cloud-based services. |
Code updated to support Windows 8 (32 and 64-bit) and Office 2013 (32 and 64-bit) in MSI-based and Click-To-Run installations of Office 365 cloud-based services. |
Were added the following improvements: - Code updated to support Windows 8 (32 and 64-bit) and Office 2013 (32-bit) in MSI-based and Click-To-Run installations of Office 365 cloud-based services. - A command to disable and enable quickly while editing a sheet via the mouse right button (Context menu) or by a button in the Excel Standard toolbar (2007, 2010, or 2013 Ribbon Add-ins tab). A menu of options appears to disable all or for specific disablements. - Added two more options for specific disablements: Disable in Page Break Preview and Disable in Page Layout View. |
Code updated to support Windows 8 (32 and 64-bit) and Office 2013 (32 and 64-bit) in MSI-based and Click-To-Run installations of Office 365 cloud-based services. |
Code updated to support Windows 8 (32 and 64-bit) and Office 2013 (32 and 64-bit) in MSI-based and Click-To-Run installations of Office 365 cloud-based services. |
Code updated to support Windows 8 (32 and 64-bit) and Office 2013 (32 and 64-bit) in MSI-based and Click-To-Run installations of Office 365 cloud-based services. |
Code updated to support Windows 8 (32 and 64-bit) and Office 2013 (32 and 64-bit) in MSI-based and Click-To-Run installations of Office 365 cloud-based services. |
New milestone version with dozens of new and significant features. You can see a description of each one at the 'Features' item in own Stopwatch homepage where they are followed by the text (New or Improved in version 3.0...) in red. |
Improved to support also printing of chart sheets. In addition, some minor problems and inconsistencies from the first version were duly fixed. |
This utility is a COM add-in or add-in (.xla) programmed in VBA that makes it possible to generate an XLS (or XLSX) file from a sheet in an another XL file opened in Microsoft® Excel® that summarizes only the printable data in the set print area. The generated XLS and the original look the same in print as they do on the screen, but the generated XLS is more portable, because it contains only the data necessary to produce the print-out. Portable XLS generation is similar to PDF generation, but dealing with a spreadsheet offers some advantages: (1) Programs able to visualize basic XLS files are more widely installed than PDF viewers. (2) It's most faithful to the original, because it is still a spreadsheet. (3) Because it is spreadsheet, it allows greater editing flexibility if any changes or additions are necessary. |
Problems were fixed concerning the PPtoEXE running as a Unicode program in non-western languages. |
Problems were fixed concerning the DOCtoEXE running as a Unicode program in non-western languages. |
Problems were fixed concerning the DBtoEXE running as a Unicode program in non-western languages. |
Problems were fixed concerning the XLtoEXE running as a Unicode program in non-western languages and with XL filenames containing spaces and hyphens. |
New milestone version with dozens of new and significant features. You can see a description of each one at the 'EXE Format Features' item in own PPtoEXE homepage where they are followed by the text (New or Improved in version 2.0...) in red. |
New milestone version with dozens of new and significant features. You can see a description of each one at the 'EXE Format Features' item in own DOCtoEXE homepage where they are followed by the text (New or Improved in version 2.0...) in red. |
New milestone version with dozens of new and significant features. You can see a description of each one at the 'EXE Format Features' item in own DBtoEXE homepage where they are followed by the text (New or Improved in version 2.0...) in red. |
New milestone version with dozens of new and significant features. You can see a description of each one at the 'EXE Format Features' item in own XLtoEXE homepage where they are followed by the text (New or Improved in version 2.0...) in red. |
New milestone version with dozens of new and significant features like: adjustable size, multiple instances within a single instance of PowerPoint; decimals floating, limited up to nine in result or limited and fixed when entering; the skin can be set up in: color and background picture, display and controls transparency etc. |
New milestone version with dozens of new and significant features like: adjustable size, multiple instances within a single instance of Word; decimals floating, limited up to nine in result or limited and fixed when entering; the skin can be set up in: color and background picture, display and controls transparency etc. |
New milestone version with dozens of new and significant features like: adjustable size, multiple instances within a single instance of Access; decimals floating, limited up to nine in result or limited and fixed when entering; the skin can be set up in: color and background picture, display and controls transparency etc. |
New milestone version with dozens of new and significant features like: adjustable size, multiple instances within a single instance of Excel; decimals floating, limited up to nine in result or limited and fixed when entering; can auto-popup iconized in cell with fading; the skin can be set up in: color and background picture, display and controls transparency etc. |
This utility is a COM add-in or add-in (.xla) programmed in Microsoft® Visual Basic® for Application (VBA) that allows selectively resetting or copying from a sheet to another sheet or to a batch of sheets all the page settings defined by the Excel 'Page Setup ...' command including all the header and footer picture settings of the sheets previously saved. Therefore, you can set up all and any page setting in a sheet and save to be copied indefinitely in the future for other sheets, similar to a template. It also manages the header and footer pictures, making it possible to insert picture in any of six header/footer positions (18 positions, differentiating the first page and even pages in Excel 2007-10) and to move them along the page, down, up, right or left and under or over the sheet contents (ideal to simulate up to nine printed watermarks and nine printed stampmarks). It inserts picture from files saved on the disk, from texts inserted by the user, or from selections pointed by the user on any open sheet. Everything can be done via user interface or via functions provided to the user VBA project. |
As was done in Excel Free, the Access Free utility now supports * and ? wildcard characters in the DB file name passed via command line to open on Access. It also supports criteria via argument to filter a single file, if more than one file meets the wildcards. |
As was done in Excel Free, the PowerPoint Free utility now supports * and ? wildcard characters in the PP file name passed via command line to open on PowerPoint. It also supports criteria via argument to filter a single file, if more than one file meets the wildcards. |
As was done in Excel Free, the Word Free utility now supports * and ? wildcard characters in the DOC file name passed via command line to open on Word. It also supports criteria via argument to filter a single file, if more than one file meets the wildcards. |
The Excel Free utility now supports * and ? wildcard characters in the XL file name passed via command line to open on Excel. It also supports criteria via argument to filter a single file, if more than one file meets the wildcards. For example, to open the latest saved YourWorkbook*.xls from C:\MyDocuments\ folder on Excel 9.0 (2000) in a maximized window the command line would be: ...\ExcelFre.exe /V09 /WSmx /Wfc:4 C:\MyDocuments\YourWorkbook*.xls |
New version of Printed Watermark for Excel utility with the following additional features: - A picture can now be made from any selection on any open sheet and inserted as a watermark. The selection can be a cell, a cell range, an object, or a group of objects over the sheet (e.g., a chart, WordArt, a diagram, a shape, or AutoShape) - The picture can be centered now in three different area options: the total area of the paper, the area under cell sheet plus the header and footer area, or just the area under the cell sheet - In Excel 2007 or 2010, after the picture is centralized, it now can be optionally anchored on the left margin of the print area to follow any changes in its size - Forms and the code were reviewed and were more consistent to run on the different Excel versions (from the 2002 up to the 2010) |
Fixed a problem in the code where, in special and rare situations, the decompilation in Word and PowerPoint documents was not done satisfactorily. |
As was done in XLtoEXE, new features were also implemented to deal with the privilege elevation on Windows XP, Vista, and Seven. See how in the Db1.exe example. |
As was done in XLtoEXE, new features were also implemented to deal with the privilege elevation on Windows XP, Vista, and Seven. See how in the Presentation1.exe example. |
As was done in XLtoEXE, new features were also implemented to deal with the privilege elevation on Windows XP, Vista, and Seven. See how in the Document1.exe example. |
New features were implemented to deal with the privilege elevation on Windows XP, Vista, and Seven: - A converted EXE file that has in your name the text "Instl-", "-instl", "Runas-", or "-runas" in any position and form is always going to start asking for privilege elevation for Windows user account to administrator level. The EXE file can also be restarted automatically via VBA project to ask for elevation, making possible your VBA project start and work normally without administrator privileges, but with power to require elevation if necessary to execute some action or special feature - The converted EXE file now accepts command line and passes entirely to your VBA project - The EXE file can be closed and scheduled via VBA project to be reopened automatically after some time. In addition, a command line argument can be set to execute an action immediately and automatically after reopening. See how in the Book1.exe example. |
This utility is a COM add-in or add-in (.ppa) programmed in VBA that generates a special static or dynamic popup clock in Microsoft® PowerPoint® to pick and count times. It makes it possible to insert times and time ranges in PowerPoint in easy ways using only the keyboard or only the mouse, or both. It has dozens of features like: pops up in small size; pops up close to mouse cursor; display digital and/or analogic; period count of days, hours, minutes and seconds; supports multiple instances; can be called too directly from any VBA code in modal or modeless format; sound; 19 output formats in sensitive menu to... |
This utility is a COM add-in or add-in (.mdb) programmed in VBA that generates a special static or dynamic popup clock in Microsoft® Access® to pick and count times. It makes it possible to insert times and time ranges in Access in easy ways using only the keyboard or only the mouse, or both. It has dozens of features like: pops up in small size; pops up close to mouse cursor; display digital and/or analogic; period count of days, hours, minutes and seconds; supports multiple instances; can be called too directly from any VBA code in modal or modeless format; sound; 19 output formats in sensitive menu to... |
Now all utilities on the site are tested and suitable for Office 2010, including the Active Teach Ribbons. |
This utility is a COM add-in or add-in (.dot) programmed in VBA that generates a special static or dynamic popup clock in Microsoft® Word to pick and count times. It makes it possible to insert times and time ranges in Word in easy ways using only the keyboard or only the mouse, or both. It has dozens of features like: pops up in small size; pops up close to mouse cursor; display digital and/or analogic; period count of days, hours, minutes and seconds; supports multiple instances; can be called too directly from any VBA code in modal or modeless format; sound; 19 output formats in sensitive menu to... |
All utilities on the site, except the Active Teach Ribbons, are able to run in Office 2010 beta. |
This utility is a COM add-in or add-in (.xla) programmed in Microsoft® Visual Basic® for Application (VBA) that generates a special static or dynamic popup clock in Microsoft® Excel® to pick and count times. It makes it possible to insert times and time ranges in Excel in easy ways using only the keyboard or only the mouse, or both. It has dozens of features like: pops up in small size; pops up close to mouse cursor; display digital and/or analogic; period count of days, hours, minutes and seconds; can auto-popup when selecting predefined cells or with date format, can auto-popup iconized in cell without perturb the Excel cell cursor navigation; supports multiple instances; can be called too directly from any VBA code in modal or modeless format; sound; 19 output formats in sensitive menu to... |
Now, optionally, the printed watermark picture can be moved or enlarged beyond the paper limits (oversized). |
New version of VBA Code Decompiler and Compactor utility now with the following additional features: - Beyond Excel, PowerPoint, and Word, it also decompiles VBA code in Access databases - Automatically saves the last setting to be used as default in the next execution. All options, including folder path, are saved in an INI file next to VBADecompiler.exe or, when this is not possible, in the Windows temp folder. |
This utility converts Microsoft® Access® files from original formats (ADP, MDB, ADE, MDE, ACCDB, ACCDE...) to EXE format. Like original format files, the EXE files created are not independent of Access, but they allow you to define Access's properties before opening and improve the portability and functionality of your databases with or without macros and without macro alert. |
It is now possible to use the Shell function in VBA to run VBADecompiler.exe from within the Excel or Word application to decompile projects in files saved by the host application itself without having to close it. To enable this, some procedures in the code were revised. As a consequence, there is a general improvement in overall code stability. |
New milestone version with dozens of new and significant features like: multiple instances within a single instance of Access; allows to increase/decrease by inserting amounts in text boxes or picking from combo boxes; improvement in count reference date setting; the skin can be set up in: color and background picture, display and controls transparency, compact mode etc. |
New milestone version with dozens of new and significant features like: multiple instances within a single instance of Excel; 25 new output formats for dates and date ranges; allows to increase/decrease by inserting amounts in text boxes or picking from combo boxes; improvement in count reference date setting; can auto-popup iconized in cell with fading; the skin can be set up in: color and background picture, display and controls transparency, compact mode etc. |
New milestone version with dozens of new and significant features like: multiple instances within a single instance of PowerPoint; allows to increase/decrease by inserting amounts in text boxes or picking from combo boxes; improvement in count reference date setting; the skin can be set up in: color and background picture, display and controls transparency, compact mode etc. |
New milestone version with dozens of new and significant features like: multiple instances within a single instance of Word; allows to increase/decrease by inserting amounts in text boxes or picking from combo boxes; improvement in count reference date setting; the skin can be set up in: color and background picture, display and controls transparency, compact mode etc. |
All utilities on the site were properly tested for Windows 7 RC, and surprisingly there was no problem, except a small enlargement of Userfoms in COM add-ins and a small deviation in the CellEasyEntry cursor which was already promptly fixed and updated. |
Now it's possible to send codes with the following additional features not existent in VBA: {VK nn}- Sends the API virtual key of decimal code nn in NORMAL WAY (downing and releasing) {VK_nn}- Sends the API virtual key of decimal code nn ONLY DOWNING. |
Added three new options in the Fraction Description ComboBox where the decimal fraction can be spelled in pence, centavos only, and nn/100 only. All ideal for coins. |
Added three new options in the Fraction Description ComboBox where the decimal fraction can be spelled in pence, centavos only, and nn/100 only. All ideal for coins. |
Added three new options in the Fraction Description ComboBox where the decimal fraction can be spelled in pence, centavos only, and nn/100 only. All ideal for coins. |
Added three new options in the Fraction Description ComboBox where the decimal fraction can be spelled in pence, centavos only, and nn/100 only. All ideal for coins. |
Added three new options in the FracType argument where the decimal fraction can be spelled in pence, centavos only, and nn/100 only. All ideal for coins. |
Implemented a new tool, Online Dictionary, to define in a Web dictionary the word selected in the document or next to the cursor. If the word in the document is formatted as a text in English, the definition will be in Dictionary.com. If it is formatted as a text in Portuguese, the definition will be in iDicionário Aulete, but the code is open and ready for you insert or suggest other online dictionaries or other languages supported by Word. |
Fixed problem where the password provided via command line to open a protected file on the disk wasn't functioning. |
Now it's possible to capture a number in Word and insert its SpellNumber back without taking hands off the keyboard using only two keystrokes. |
Now it's possible to capture a number in Excel and insert its SpellNumber back without taking hands off the keyboard using only two keystrokes. |
The Word Free utility now allows specifying too the following file open options: read-only mode, password to open or write document or template, and add to recently used file Word list. This can be specified thru setting saved in INI file pushing the Shift key or thru argument in the command line in scripts and Windows shortcuts. |
The Access Free utility now allows specifying too the following file open options: exclusive mode and password to open. This can be specified thru setting saved in INI file pushing the Shift key or thru argument in the command line in scripts and Windows shortcuts. Fixed a bug too where there was alert when using an already opened Access Window with opened database. |
The Excel Free utility now allows specifying too the following file open options: read-only mode, password to open or write, add to recently used file Excel list, ignore read-only recommended and update links options. This can be specified thru setting saved in INI file pushing the Shift key or thru argument in the command line in scripts and Windows shortcuts. |
New version of VBA Code Decompiler and Compactor utility now with the following additional features: - Beyond Excel and Word, it also decompiles VBA code in PowerPoint presentations - If there is more than one installed version of Excel, PowerPoint or Word, a different version of the standard version can be specified to make the decompilation - All the code was revised and improved seeming more stable even though with codes in Excel workbooks . |
This utility converts PowerPoint files from original formats to EXE format (convert PPT to EXE, convert PPS to EXE, convert PPA to EXE etc.). Like original format files, the EXE files created are not independent of PowerPoint, but they allow you to define PowerPoint's properties before opening, and improve the portability and functionality of your presentations with or without macros. |
Three problems were fixed. In the first, it wasn't accepting to create new documents when using 'Exclusive Word window' conversion option generating error in VBA code. In the second, it was erasing earlier changes if it opens and exit without saving changes when using 'Save changes in a single DOC file' conversion option. And in the third, he was not taking into account the differences between documents, templates, and add-ins when opening and closing automatically attachments using 'Open all the attached DOC files too' conversion option. |
Three problems were fixed. In the first, it wasn't accepting to create new workbooks when using 'Exclusive Excel window' conversion option generating error in VBA code. In the second, it was erasing earlier changes if it opens and exit without saving changes when using 'Save changes in a single XL file' conversion option. And in the third, he was not taking into account the differences between workbooks and add-ins when opening and closing automatically attachments using 'Open all the attached XL files too' conversion option. |
This utility allows you to work with PowerPoint without macro alert for your known PP files that contain macros, while maintaining the highest virus security level settings for all others PP files increasing PowerPoint security and productivity. Other features include the ability to specify the PowerPoint version (where more than one PowerPoint version is installed) and the startup window style (normal, maximized, minimized or hidden). This is a useful tool for all PowerPoint users, from a normal user thought to power users and script programmers. |
New version of Access Free with the redesigned interface, improved documentation (homepage), and some additional features. It now allows specifying the Access window start style and to open always a new Access instance thru setting saved in INI file pushing the Shift key or thru argument in the command line in scripts and Windows shortcuts. Moreover, new command line arguments were created to associate and unassociate file extensions via script. |
New version of Word Free with the redesigned interface, improved documentation (homepage), and some additional features. It now allows specifying the Word window start style and to open always a new Word instance in normal or automation mode thru setting saved in INI file pushing the Shift key or thru argument in the command line in scripts and Windows shortcuts. Moreover, new command line arguments were created to associate and unassociate file extensions via script. |
New version of Excel Free with the redesigned interface, improved documentation (homepage), and some additional features. It now allows specifying the Excel window start style and to open always a new Excel instance in normal or automation mode thru setting saved in INI file pushing the Shift key or thru argument in the command line in scripts and Windows shortcuts. Moreover, new command line arguments were created to associate and unassociate file extensions via script. |
Now it's possible to send keypad keys with additional codes not existent in VBA. |
New milestone version with many new and significant features like: multiple instances within a single instance of Excel; similar controls in different instances can be attached to be triggered with a single click; reports of split time with labels (Label Snapshots), allowing set up of as many as 10 snapshot controls in the interface with different labels, background and front colors, and sounds; all settings of an instance can be saved in a file to be opened in another parallel or future instance; capture of positive or negative time in cells, positives for the stopwatch and negatives for the countdown; automatic start of the stopwatch, when a countdown expires; speak in robot voice, announcing second by second the last n seconds of a countdown; different behaviors of the Stop-Insert button can be set via menu; auto-popups can happen simultaneously in different cells; can be set up with independent sound from WAV files for each control, including the 10 Label Snapshots; the skin can be set up in color and background picture, in display and controls transparency, hiding title bar etc. |
Fixed problem of focus loss in the form to pick color for watermark text. |
Fixed problem in DOCtoEXE utility where, if a converted DOC is open from a day to the other, could there be functionality lost like saving changes. |
Fixed problem in XLtoEXE utility where, if a converted XL is open from a day to the other, could there be functionality lost like saving changes. |
This utility is a COM add-in or add-in (.mdb) programmed in VBA that generates a popup calculator in the Access with the following features: captures number or numbers in text selection; addition, subtraction, multiplication, and division; square root; memory; operation with constant; paper ribbon; pops up in small size and close to mouse cursor; modeless; can be called by the mouse right button; can be called too directly from any VBA code in modal or modeless; sound... |
Fixed problem in XLtoEXE utility where a false and inconsistent alert about unknown Excel version was emitted in Windows Vista. |
This utility is a COM add-in or add-in (.ppa) programmed in VBA that generates a popup calculator in the PowerPoint with the following features: captures number or numbers in text selection; addition, subtraction, multiplication, and division; square root; memory; operation with constant; paper ribbon; pops up in small size and close to mouse cursor; modeless; can be called by the mouse right button; can be called too directly from any VBA code in modal or modeless; sound... |
Now, if no selection, it is automatically extended looking for a number immediately to the left of the cursor. And yet, if in a selected text or pasted from Clipboard, is a table column or a mix of numbers and text, there is more than one number, all are duly filtered, validated, and listed in the 'Number' ComboBox. |
This utility is a COM add-in or add-in (.dot) programmed in VBA that generates a popup calculator in the Word with the following features: captures number or numbers in text selection; addition, subtraction, multiplication, and division; square root; memory; operation with constant; paper ribbon; pops up in small size and close to mouse cursor; modeless; can be called by the mouse right button or by a keyboard shortcut key set by the proper user; can be called too directly from any VBA code in modal or modeless; sound... |
Fixed problem when operating the button 'Size and Position' in systems using Windows Vista and Excel 2007. |
The grace period to test (free pass) increased from 2 to 30 days and some minor bugs were fixed. |
The grace period to test (free pass) increased from 2 to 30 days. |
The grace period to test (free pass) increased from 2 to 30 days and some minor bugs were fixed. |
The grace period to test (free pass) increased from 2 to 30 days. More 17 menu command positions were added too, totalizing now 1838. |
It was launched a new utility, the Popup Spell Number for Access. This utility is a COM add-in programmed in VBA that makes possible to capture number in Access, configure its respective Spellnumber (write out number as in Check writing protection) thru a friendly popup user interface and immediately insert in Access or send it to Windows clipboard to be pasted in any Access part or in other application.
This utility hasn't properly a Portuguese version, but it has a similar for the Portuguese that was launched too, the Extenso de Número para Access. |
This utility is a COM add-in (.dll) or add-in (.mdb) programmed in VBA that generates a popup calendar in the Access with the following features: pops up in small size; modeless; pops up close to mouse cursor; buttons to increase days, weeks, months and years; period count of days, weeks, months, and years; captures and inserts in the selection; copies output to Windows Clipboard; can be called too directly from any VBA code in Modal or Modeless format; sound; 25 output formats in sensitive menu to... |
Fixed problem in Excel Free utility, the ExcelFre.exe, that wasn't loading existent files on the Excel XLSTART folder when starting. |
It was launched a new utility, the Popup Spell Number for PowerPoint. This utility is a COM add-in programmed in VBA that makes possible to capture number in PowerPoint, configure its respective Spellnumber (write out number as in Check writing protection) thru a friendly popup user interface and immediately insert in PowerPoint or send it to Windows clipboard to be pasted in any PowerPoint part or in other application.
This utility hasn't properly a Portuguese version, but it has a similar for the Portuguese that was launched too, the Extenso de Número para PowerPoint. |
This utility is a COM add-in or add-in (.ppa) programmed in VBA that generates a popup calendar in the PowerPoint with the following features: pops up in small size; modeless; pops up close to mouse cursor; buttons to increase days, weeks, months and years; period count of days, weeks, months, and years; captures and inserts in the selection; copies output to Windows Clipboard; can be called too directly from any VBA code in Modal or Modeless format; sound; 25 output formats in sensitive menu to... |
Now final free version without beta test limits and fixed problem when printing preview in some Excel 2007 installations. |
This utility is a COM add-in or add-in (.dot) programmed in VBA that generates a popup calendar in the Word with the following features: pops up in small size; modeless; pops up close to mouse cursor; buttons to increase days, weeks, months and years; period count of days, weeks, months, and years; captures and inserts in the selection; copies output to Windows Clipboard; can be called too directly from any VBA code in Modal or Modeless format; sound; 25 output formats in sensitive menu to... |
The Access Free utility now allows specifying the Access version, if there is more than one installed on the computer, thru setting saved in INI file, pushing Shift key or thru argument in the command line in scripts and Windows shortcuts. |
Now it's possible to send codes with the following additional features not existent in VBA: ^%{DEL}- Sends 'Ctrl + Alt + DEL' keys to POWER OFF the computer, IF POSSIBLE ^%{DEL 1} - Sends 'Ctrl + Alt + DEL' keys to POWER OFF the computer, FORCIBLY ^%{DEL 2} - Sends 'Ctrl + Alt + DEL' keys to RESTART the computer, IF POSSIBLE ^%{DEL 3} - Sends 'Ctrl + Alt + DEL' keys to RESTART the computer, FORCIBLY ^%{DEL 4} - Sends 'Ctrl + Alt + DEL' keys to LOGOFF the user, IF POSSIBLE ^%{DEL 5} - Sends 'Ctrl + Alt + DEL' keys to LOGOFF the user, FORCIBLY. |
The Word Free utility now allows specifying the Word version, if there is more than one installed on the computer, thru setting saved in INI file, pushing Shift key or thru argument in the command line in scripts and Windows shortcuts. |
The Excel Free utility now allows specifying the Excel version, if there is more than one installed on the computer, thru setting saved in INI file, pushing Shift key or thru argument in the command line in scripts and Windows shortcuts. |
The Access Free utility now also deals with MDE extension files. |
It was launched a new utility, the Active Teach Ribbon for Access. This utility is a COM add-in programmed in VBA. It destines to Access users migrating to the 2007 version that, knowing the positions in the previous menu and toolbars structure, want to know instantaneously where they are in the Ribbon or want, eventually or not, to continue using menu and toolbars structure in the proper Access 2007 without making changes in the Ribbon that could disturb the adaptation to the new interface. |
Two problems were solved. The first one was Word focus loss in Windows Vista when a converted DOC was run from Explorer. The second one, the CPU use, while waiting for a user response or Word event, it was not optimized properly provoking unnecessary use peaks. |
Two problems were solved. The first one was Excel focus loss in Windows Vista when a converted XL was run from Explorer. The second one, the CPU use, while waiting for a user response or Excel event, it was not optimized properly provoking unnecessary use peaks. |
It was launched a new utility, the Active Teach Ribbon for PowerPoint. This utility is a COM add-in programmed in VBA. It destines to PowerPoint users migrating to the 2007 version that, knowing the positions in the previous menu and toolbars structure, want to know instantaneously where they are in the Ribbon or want, eventually or not, to continue using menu and toolbars structure in the proper PowerPoint 2007 without making changes in the Ribbon that could disturb the adaptation to the new interface. |
The Active Teach Ribbon for Word utility was duly tested in Windows Vista. A problem found in the installer was fixed. |
The Active Teach Ribbon for Excel utility was duly tested in Windows Vista without problems. |
Fixed small problems in the code and in the database where 66 possible positions in menus and toolbars of Word 2003 were still lacking to be taught in the new Word 2007 interface totalizing now 1296 positions. |
Fixed small problems in the code and in the database where nine possible positions in menus and toolbars of Excel 2003 were still lacking to be taught in the new Excel 2007 interface totalizing now 857 positions. |
It was launched a new utility, the Active Teach Ribbon for Word. This utility is a COM add-in programmed in VBA. It destines to Word users migrating to the 2007 version that, knowing the positions in the previous menu and toolbars structure, want to know instantaneously where they are in the Ribbon or want, eventually or not, to continue using menu and toolbars structure in the proper Word 2007 without making changes in the Ribbon that could disturb the adaptation to the new interface. |
Two improvements were made in the "Spell number (write out)" tool. Now the asterisk (*) sign means that the decimal fraction must be spelled in pennies. And the sign in place of $ sign mean that the unity name is the Euro coin. |
Some minor improvements were made in the user interface and a new option was added in the Fraction Description ComboBox where the decimal fraction is spelled in pennies. Ideal for coin. |
Some minor improvements were made in the user interface and a new option was added in the Fraction Description ComboBox where the decimal fraction is spelled in pennies. Ideal for coin. |
Added a new option in the FracType argument where the decimal fraction is spelled in pennies. Ideal for coin. |
It was launched a new utility, the Active Teach Ribbon for Excel. This utility is a COM add-in programmed in VBA. It destines to Excel users migrating to the 2007 version that, knowing the positions in the previous menu and toolbars structure, want to know instantaneously where they are in the Ribbon or want, eventually or not, to continue using menu and toolbars structure in the proper Excel 2007 without making changes in the Ribbon that could disturb the adaptation to the new interface. |
Were added the following improvements: - When in a cell value there is date and time, the time fraction will be preserved when editing date on CellEasyEntry - For the forgetful, always that the CellEasyEntry is activated, a message will appear on Excel status bar remembering that to show the setting form needs only to press Alt key and give a double click on active cell - Improved cell sheet navigation when the Excel "Move selection after Enter" option is activated. |
|
Created options, possible only in Excel 2007, to insert watermarks differently on the first page, on the odd pages, and on the even pages. |
The Printed Watermark for Excel utility was duly updated to run too with Excel 2007. |
The Cell Easy Entry for Excel utility was duly updated to run too with Excel 2007. |
The VBA Code Decompiler and Compactor utility was duly updated to run too with Office 2007 library. A priori, all the considerations done previously for this utility continue valid in VBA projects save in the new Office 2007 zip file formats. Only the reduction tax in the file final size on the disk can appear smaller due to zip compression, but internally the tax reduction continues similar to the previous Office versions file formats, meaning now, beyond less data to load, less data to uncompress. |
The Preview and Print Thru Email for Excel utility was duly updated to run too with Excel 2007. |
The XL Windows® Shortcut Creator utility was duly updated to run too with Excel 2007. |
The Popup Spell Number for Word utility was duly updated to run too with Word 2007. |
The Popup Spell Number for Excel utility was duly updated to run too with Excel 2007. |
The Popup Stopwatch for Excel utility was duly updated to run too with Excel 2007. |
The Useful Tools for Word were duly updated to run too with Word 2007. |
The Popup Calculator for Excel utility was duly updated to run too with Excel 2007. |
The Popup Calendar for Excel utility was duly updated to run too with Excel 2007. |
The DOCtoEXE utility was duly updated to handle too with Word 2007 and its new file formats. |
The XLtoEXE utility was duly updated to handle too with Excel 2007 and its new file formats. |
The Access Free utility was duly updated to handle too with Access 2007 and its new file formats. |
The Word Free utility was duly updated to handle too with Word 2007 and its new file formats. |
The Excel Free utility was duly updated to handle too with Excel 2007 and its new file formats. |
Were fixed minors bugs from the first version and added the following improvements: - A new option in the Fraction Description ComboBox where the fraction isn't spelled but written as a fraction with denominator of 100, 1000, 1000000... Ideal for coin when in fractions lesser than one cent or even in cents, although it isn't the most frequent. Example: Two and 256/1000 Dollars ($2.256) - Now unit name letter case before point contraction doesn't suffer changes anymore in function of changes in the Letter Case ComboBox, and - A new output option with the Spellnumber without brackets coming before the respective number between brackets duly formatted like in the example above. |
Were fixed minors bugs from the first version and added the following improvements: - A new option in the Fraction Description ComboBox where the fraction isn't spelled but written as a fraction with denominator of 100, 1000, 1000000... Ideal for coin when in fractions lesser than one cent or even in cents, although it isn't the most frequent. Example: Two and 256/1000 Dollars ($2.256) - Now unit name letter case before point contraction doesn't suffer changes anymore in function of changes in the Letter Case ComboBox, and - A new output option with the Spellnumber without brackets coming before the respective number between brackets duly formatted like in the example above. |
Added a new option in the FracType argument where the fraction isn't spelled but written as a fraction with denominator of 100, 1000, 1000000... Ideal for coin when in fractions lesser than one cent or even in cents, although it isn't the most frequent. Example: Two and 256/1000 Dollars ($2.256). And now unit name letter case before point contraction doesn't suffer changes anymore in function of the LetterCase argument. |
Added the LeftPos and TopPos arguments to the fStopwatch() function to position the stopwatch on the screen when it is called from any VBA code. It can be positioned in relation to the dynamic mouse cursor or in relation to the left top fix corner of the screen. |
Improved the "Paste only text without format" tool. Now too, if the Ctrl (or Shift) key is pressed when clicking, ONLY THE FORMAT of the text copied from any application will be applied in the selection. The Word hasn't a built-in tool for this functionality internally and externally from Windows clipboard, only internally something like this can be done using the Format Painter tool. |
It was launched a new utility, the Popup Spell Number for Word. This utility is a COM add-in programmed in VBA that makes possible to capture number in Word, configure its respective Spellnumber thru a friendly popup user interface and send it to Windows clipboard to be immediately pasted in any Word part or in other application.
This utility hasn't properly a Portuguese version, but it has a similar for the Portuguese that was launched too, the Extenso de Número para o Word. |
Now it's possible to send codes with the following additional features not existent in VBA: {PAUSE} - Pauses 1 second before sending the following keys {PAUSE n} - Pauses n seconds before sending the following keys {PRTSC} - Sends 'Print Screen' key to capture all screen %{PRTSC} - Sends 'Alt + Print Screen' keys to capture only active window. |
Fixed problem in XLtoEXE utility, where, when there is automation add-in connected in the Excel, the correspondent DLL file occasionally, depending of the setting done to the conversion, could be treated as XLA. |
Fixed problem in Excel Free utility, the ExcelFree.exe, where, when there is automation add-in connected in the Excel, the correspondent DLL file was treated as XLA. |
Improvements in Popup Spell Number utility for Excel: an insert command rose to insert the Spellnumber above, below, left, right or over selection; command to restore default setting and the Spellnumber can be put between brackets and still anteceded by the respective number duly formatted according with the unit. |
It was launched a new utility, the Popup Spell Number for Excel. This utility is an Excel add-in programmed in VBA that makes available the fSpellNumber() sheet function to all workbooks opened in your Excel. It too makes possible to capture number in Excel, configure its respective SpellNumber thru a popup user interface and send it to Windows clipboard to be immediately pasted in any Excel part (cell, formula bar, text box, comments etc.) or in other application.
This utility hasn't properly a Portuguese version, but it has a similar for the Portuguese that was launched too, the Extenso de Número para o Excel. |
Now, specially for who programs in VBA, the Popup Stopwatch for Excel can be called too directly from any VBA code thru the fStopwatch() function. This function is well documented in the proper homepage and it still has an example of a VBA application that uses it, a Stopwatch Sheet for Motocross Race. |
Now in interface and in alerts of each utility was created a link to on-line help thru of respective homepage. |
Created an option in the installer of CellEasyEntry.dll (COM add-in) enabling that installation is valid to all Windows Users including Limited Users. Thus, normally as before, the utility can be available only for the installer user or, optionally, for All Windows Users. |
It was launched a new utility, the VBA Code Decompiler and Compactor. This utility Decompiles and Compacts VBA code saved by Excel or Word, reducing the file size and the compilation conflict probability between different Office versions and still cleaning compilation garbage accumulated during the project phase that frequently generates errors and slowness when loading. |
The homepages of already existent utilities were improved with more details to act as on-line help too and all utilities now have their proper homepages. Homepages were created for: Printed Watermark for Excel, XL Windows® Shortcut Creator, Excel popup Calculator, Excel popup Calendar, Excel popup Stopwatch, VBA MsgBox with timer, VBA SetFileDateTime and GetFileDateTime functions, VBA spell numbers function, Text Box to input dates in VBA code, Text Box to input numbers in VBA code, and Independent SendKeys. |
Created an option in the installer of Printed Watermark for Excel enabling that installation is valid to all Windows Users including Limited Users. Thus, normally as before, the utility can be available only for the installer user or, optionally, for All Windows Users. |
Now Excel Popup Stopwatch automatically saves settings for later use. They are saved in an INI file created next to ExcelStopwatch.xla file in the first time that default settings are changed. |
Now it's possible realize simultaneous instances. Keys can be sent to more of one window simultaneously. |
Now Popup Calendar for Excel automatically saves settings for later use. They are saved in an INI file created next to ExcelCalendar.xla file in the first time that default settings are changed. |
Now Popup Calculator for Excel automatically saves settings for later use. They are saved in an INI file created next to ExcelCalculator.xla file in the first time that default settings are changed. |
Now, when the title window argument is empty (Quotation marks without text), the keys will be sent to the active window. |
Each add-in or COM add-in in this site has its automatic installation and uninstallation package programmed in VBA that makes fully easy the installation by macro laymen, but, if an expert visitor want the respective XLA or DLL out of the package to install manually or run without install, it now is available in isolated way in a ZIP too. |
Fixed problem in the add-in installers relative to OLE object extraction in the last Windows XP SP2 updating. The installers of the ExcelCalendar.xla, ExcelCalculator.xla, ExcelStopwatch.xla, CreateShortCut.xla, and PrintThruEmail.xla programmed in VBA in XLS files were duly converted to EXEs by the XLtoEXE that, between others features, accepts file attachment to generation of completed and sophisticated installer packages duly compressed, getting rid of the need of the use of OLE package embedded in sheet and becoming the installation more quick, easy and stable. |
Now, when splitting time in an Excel Sheet, the user note for the next or the last snapshot can be inserted in the proper utility interface, avoiding the focus loss when activating the sheet to the inclusion. |
Properties of the EXE file (name, path, size, date-time etc.) can be got from the VBA project of the converted DOC. See how in the Document1.exe example. |
Fixed problem in Cell Easy Entry utility for Excel where, sometimes, the Calculator and the Calendar versions were known as old although they're recent. |
Properties of the EXE file (name, path, size, date-time etc.) can be got from the VBA project of the converted XL. See how in the Book1.exe example. |
Fixed problem that raised error with the following message: "run-time error 13 Type Mismatch". This happened when the decimal separator was changed on Windows and it there is some number, inclusive from project, on the display using the previous separator. |
Inserted a new optional argument, LetterCase, to format letters in upper/lower case (1 - all lower case, default, 2 - Sentence case, only the 1º is upper, 3 - Title Case, 1º Upper in Each Word, and 4 - ALL UPPER). |
Inserted this 'What's New' log in RSS and HTML formats. |
Make, during event open procedure, the XLexe file folder as Excel active folder to be captured there by VBA code. It can be captured and stored in a public variable to be used anywhere later. |
Improved Useful Tools for Word installer and uninstaller, becoming them more easy and stable. The original Word DOC was duly converted to EXE by the DOCtoEXE to make fully easy the installation by macro laymen. |
Fixed problem where, if the root path were default, returned two slash in the path of the first suggested XL, raising error when convert it. |
Improved Text Box to Input Dates in VBA Code. Since it is not necessary to type separators, now, if it is typed or mistyped, it is interpreted as a wish to advance the cursor to the next position, in cycle, afterwards immediately after a separator. This is better to navigate along the date format than using arrow keys or mouse. |
Improved Text Box to Input Numbers in VBA Code. Since it is not necessary to type thousand separators, now, if it is typed or mistyped point, comma or semicolon in any keyboard, all are interpreted as the decimal separator. |
Fixed problem that raised error with the following message: "run-time error 13 Type Mismatch". This happened due a different Excel behavior in foreign languages when capturing values from empty cells. |
Inserted a new argument, OneThousand, to write 1,000 complete without omit 'one': True (Yes, 'one thousand') or False (No, 'thousand'). |
Fixed a problem in compression module that was happening in Windows XP SP2 that raised the following error message: "The instruction at 0x023e2b1a referenced memory at 0x00221712. The memory could not be read". |
Fixed a problem in compression module that was happening in Windows XP SP2 that raised the following error message: "The instruction at 0x023e2b1a referenced memory at 0x00221712. The memory could not be read". |
Inserted info in homepage about download file date-time and size in each utility. |
Like XLtoEXE for Excel users, DOCtoEXE was developed for Word users too. The conversion of DOC, DOT or RTF files to EXE format, moreover to maintain the original format features, inclusive for editing thru the Word, adds others functionalities where the autocompression and the control over the Word highlight. |
Starting this log and its project. This is a milestone too, it is the first event after my last MVP activities report. |