1 click macro tool: Problem/Incident Management - create daily reports and compile them in 1 to create the monthly report in excel

Description

This tool is a bundle of those 3 other tools:

To resume, this tool contains 3 files, 1 access and 2 excels:

  • 1 excel file (dailyreport), by 1 click, to create a daily report about issues (incidents, problems, outages, major incidents, etc.)
  • 1 access file (compileallfiles), by 1 click, will compile all daily reports into 1 single excel file
  • And 1 excel file (monthlyreport), by 1 click, will create the monthly report based on this single file
macro compile create macro compile create

 

Requirement

Microsoft Excel and Microsoft Access minimum version for Windows 7 to open the excel/access macro files.

Basic knowledge of VBA coding macro. You may need to edit the macro to adapt this tool to your need. Comments are available in the macro to help but you will need a minimum basic knowledge of VBA coding macro.

 

Installation

All files should be in the same folder.

The tool is zipped so you will need to unzip it with the Microsoft Zip tool installed by default in your Microsoft Windows, read how to zip and unzip files in the Microsoft support website.

If the macro option is turned off in your Microsoft Excel program, you have to turn it on, read enable or disable macros in Office files in the Microsoft support website.

To edit the excel macro, read Create, run, edit, or delete a macro in the Microsoft support website

To edit the access macro, read Use a command button to start an action or a series of actions in the Microsoft support website

 

Support

A 7 days free support to adapt this tool that includes only:

  • Updating only names of your daily excel file in the macro for access
  • Updating only names of the extracted 1 single excel file in the macro for access
  • Updating the range and cells for excel
  • Updating the pivots/tables/charts for excel
  • Updating the sheet names for excel
  • Updating only names of the code/macro/functions/vba for excel

It doesn’t include:

  • Modifying the code/macro/functions/vba/pivots/tables/charts
  • Creating new code/macro/functions/vba/pivots/tables/charts
  • Other minor and major changes of the code/macro/functions/vba/pivots/tables/charts/file
  • All issues with your Microsoft Excel/Access programs and any other programs

Feel free to contact me at itmet@itmanagementetools.com to improve this tool based on your need:

  • I will provide you a quote and the delivery time based on the information.
  • I will start to work only after accepting the quote and paying 50% via paypal.
  • Once finished, I will send you the tool after paying the remaining 50% via paypal.
  • Once started, any modifications can modify the price, if so:
    • New quote will be provided
    • After acceptance, I will start to work again
  • A 30 days free support

Note for the paid version

The macro of the “compileallfiles” file is importing the data of the 3 sample daily files to generate the “compileresults” file. The macro of the “monthlyreport” file is importing the “compileresults” file to create the February report for 2019 to be executed on March so if you buy this tool after this date and you want to use the samples for testing, you will need to change the date of those samples before to use the macro. For instance, you buy it on June 2534 so change on columns O, P and T:

  • The year from 2019 to 2534
  • 02 (February) to 05 (May)
  • 01 (January) to 04 (April)
  • 03 (March) to 06 (June)

Once done, just click the button of the “compileallfiles” file.

 

Samples Access/Excel files without macros/formulas to download Intranet issue webpage to see
Price 6.90 euros
 

Interesting Management