• excel_combi

    VBA macro combines multiple Excel files from a selected folder into a single workbook, seperated as tabs.

    VBA combine_files.txt

  • bionic_vba_converter

    Bionic Document Converter – use VBA to apply the Bionic Reading technique to selected text in documents.

    VBA bionic_VBA.txt

  • barcode_generation

    Easily convert data to barcode. Note: file requires Fre3of9x Font

    Basically, whatever you scan or type into column A will be in text format (to reduce Excel’s unwanted automation of converting data to number) and have conditional formatting to highlight duplicates. You’ll then press the magic button and barcodes will be generated in column B. Delete data from column A and press the button again, and all barcodes will disappear too. This makes data barcode ready by inserting asterisks before and after data, then applying font changes

    CODE sub_apply_formula.txt

    README barcode_vba_README.txt

    FONT font_Fre3of9x

  • amazon_price_scraper_excel

    Microsoft Visual Basic for Applications – Tools – References – enable Microsoft XML, v6.0
    Add Module –

    Excel – copy Amazon product link to cell
    Excel – formula – amazon_price(refer to link cell)

    VBA Module_pricechecker.txt