Update 2020-12-13: I published an infomercial video on the 1.1 update of our Find and Replace for Microsoft Access tool. This is an opportunity to see some of the cool new features in action without even downloading the free trial version.
mz tools 3 0 for vba download for 12
Note: The IDE does require the WebView2 runtime as the development environment uses the HTML-based Monaco code editor. The WebView2 runtime comes preinstalled with Windows 11 and certain Windows 10 software, such as Office 365. If you don't have it, you can download it here:
And then the user should download and install .NET Framework 2.0. Needless to say, this is mostly inconvenient and can hurt sales, so I thought it would be nice if MZ-Tools 8.0 for VBA could use whatever higher .NET Framework was installed on Windows (such as .NET Framework 4.0 on Windows 8 or higher).
Version 2.5.1 was released August 22, 2020. Since then, the installer was downloaded over 11,600 times; we are now 420 commits and 650 modified files later, and the time has come to deliver all that work into a convenient little installer package and move on to the next dev/release cycle.
1) I use Excel as a flat database with columns & dropdowns defining the broadest grouping say VBA, Formulas, Excel Application, Pivot Tables eg "VBA", then the next column broad grouping eg "Copying Ranges" , then another eg "within the same workbook" and then the detail of the tip plus links if any plus a comment box for long entries. Autofilter and Ctrl+F find allows fairly good access. Perhaps there are other tools but if you are an Excel believer you have to make this work and make it a project in itself that you tinker with over time. I tried MindMaps and MS Notes in the past but it gets all too hard as the topic is just too big.2) I save more complex tips or articles with illustrations as web archive files in structured windows folders - then search these with Windows or maybe there are better tools like Ultrasearch3) Use MZ Tools to save VBA code snippets - this is a double up for me as these snippets are also in my Excel file usually in a comment box associated with a topic but I reserve the code I put into MZ Tools (fantastic tool for VBA it really is) as the standard I use for a particular situation.
Essential tools for data analysis and tables management for novice and advanced Excel's users. A set of tools that will strengthen your Microsoft Excel to manage data bases and huge tables in your spreadsheets. Tools for Excel Tables is an addin
Systerac Tools present 16 valuable tools that help you tweak your Windows 7 for optimum performance. With the touch of a button you will be able to immediately identify any problems and weak points and correct them with the safety that only Systerac can
An incredible package of tools for Windows 7, Windows Vista and Windows XP that will improve your PC performance, speed up your programs and Internet connection, diagnose pc problems and tweak your Vista PC for optimal results.
These early Excel magic numbers vary somewhat based on certain features of the file or version of Excel.[12] The newer compound file basically became a wrapper for the older spreadsheet encoding format. In addition to the specification document provided by Microsoft, another great reference is the Library of Congress's file format description of BIFF.[13]To get a closer look at exactly what the components of a BOF record are and what they mean, without having to carefully read the specification, one needs to use a tool that has the capability to parse and display the data. Each of the various tools that fill this role have pluses and minuses. Therefore, each tool is outlined here. The first is OffVis. This is a combination hex editor and compound file parser. It is an older Microsoft product which is still available for download.[14] A newer version of OffVis is also available on Github, but because it is distributed in binary form and not directly from Microsoft, appropriate caution should be exercised.[15] The global BOF record as parsed by OffVis is highlighted in Figure 5.
Great set of tools, I have noticed while checking PDF files for embedded links (i.e. URI tags), some PDFs contain hyperlinks but do not contain the URI tag, is there an alternative method of embedding hyperlinks, should I be searching for some other keyword?
Very cool man, I tried to use PDF tools to unwind a drive-by ZeuS pdf infection. Unfortunately, it gave me some problems because I was using a newer version of Python (and it looks like the El Fiesta Exploit kit might use some kind of different zLib encoding to compress its payloads). Good stuff though! -engineering-zeus/
Didier Great Tool. I have incorporated this tool into our EnCase Integrated Threat Toolkit (EITT) and our customers absolutely love this tool. I have a need for a tool that can parse all office docs looking for embedded objects just like your PDF tools do. Do you currently have a tool that would do this or is there a way to customize this tool to include all office docs. thanks.
I recently received a PDF document that I have attempted to analyze using your tools. When opened, it was obvious that the document has a link to a credential harvesting site that it tempts users to click on. However, using pdf-parser, I am unable to locate the URI object. I attempted to decompress the 4 object streams but received errors relating to unexpected compression method. I then attempted to follow the method you posted regarding the handling of special PDF compression methods but also to no avail. Is this a new technique or is there something I have missed? Of note, there appears to be some form of DRM/encryption also applied as there are also 2 /Encrypt objects. I have uploaded the file to VT (SHA 256: 7d2b615630efd2fa3713d97e57afb9972f43e7d4a67cc706af7c789dd1dbe47f) if you are interested in taking a look.
The updated, full-featured NIST MS Search Program for Windows has a fullrange of integrated tools. The new updated version of thiswidely used, full-featured software is designed for identifyingcompounds from their mass spectra and for exploring mass spectrallibraries. It also contains tools for deconvoluting gas/liquidchromatograms and interpreting mass spectra.Tip: If you've used older versions of NIST MS Search (especially before 2005), seeall the features that have been added to the last four editions.Library Searching via Multiple Search Modes
Chemical Identity
Structure Similarity
Impurity Reduction
Neutral Loss
Four Peak Types
Library Building
GC/MS Deconvolution
MS Interpretation
Chemical Substructure Analysis
Chemical Substructure Identification
Molecular Weight Estimation
Chlorine/Bromine Analysis
Isotope/Formula Generator
Integration with multiple Instrument Data Systems
OverviewThis software provides a flexible means of accessing data in the NISTand User libraries including:chemical identification by optimized, documented spectrum-matching methods,
analyzing mass spectra of compounds not in the library using library data,
finding spectra with pre-selected characteristics,
viewing spectra by name, formula, CAS registry number, molecular weight,or ID number,
User library building and maintenance, and
integration with a number of commercial GC/MS data systems and spectralanalysis tools.
Windows OrganizationWhen the program is first started, seven tiled windows appear on thescreen (the Desktop), each with its own data and behavior. The behaviorof any Window may be modified by making it active (clicking on it) andthen pressing the AdjustWin button at the bottom of the Desktop. As you become familiar with program operation, you may wish to change thedimensions of some Windows or even close some of them to create a customDesktop. When the program is restarted, it will begin with the mostrecent Desktop. To save a window-arrangement Desktop for future use,select Desktop from the Menu Bar and then Save As from the resulting Menu. Prior Desktops may be restored using one of the predefined names or yourown name. Such arrangements describe the geometry and type of informationshown in each Window, not the actual data contained in it. To restorea previous hit list, select it from the list at the top of the Hit ListWindow.Library Searching - Identify unknown compounds and substructuresusing fully documented and optimized procedures, or search by a wide rangeof compound and spectral properties.Library Building - Maintain your own libraries, add your ownchemical structures and search using the same optimized procedures developedfor NIST.Flexible User Interface - Set multiple Desktop configurationswith up to seven independently configured windows to examine search resultsand match your needs.Use with Your Instrument Data Systems - Direct transfer betweena number of commercial data systems and the NIST Search Program.Adding User-Drawn StructuresUsers may import their own chemical structureswith selected user spectra. This is done in the Tools/Librarian sectionof the program by connecting a user-drawn structure in standard MOL-fileformat with a user spectrum. Such structure-drawing programs arewidely available (for example, ISIS/Draw may be freely downloadedfrom ). As before, if a userspectrum is given its CAS registry number and the Main Library has a structurefor it, this structure will automatically be shown with user spectra unlessthe user has attached an imported structure to the spectrum.Aids for Automation and ReportingA variety of methods for automated searching and reporting of resultsare available. From the File menu selection, if Print automationis on, printing will follow each library search. A set of print optionsis also available from the "User Search Options" Window (select Search,then User spectrum). This is of particular use when using this NISTProgram with other data acquisition programs.What's New in NIST20Library improvements 2ff7e9595c
Comments