In my experience, these above modules are quite useful to automate stuff. With stand-alone, they are not really related to each other. But when combining, those modules could work well in some contexts.
Installation:
Import .bas
and .frm
files into your project (Open VBA Editor, Alt + F11; File > Import File)
Features:
- Office version: 2013, 2016, 2019 and 365
See how it works below
Loop through each file in a folder/subfolder recursively to get information inside. Can be used in many cases such as copy value from the same formatted files, reshape, or simply just open then close them.
Modules: LoopFolder.bas, VisibleCell.bas
Send an email containing FB03 SAP Tcode information (Company Code, Fiscal Year, Document Number) to another account (usually to a PC can run SAP). Then open SAP and auto-input those strings in order to download hard copies. Finally, zip and reply to the receipt email.
Modules: OutlookControl.bas, SAPControl.bas, ZipFiles.bas
List email information and Move/Copy them to another directory by Treeview Nodes
in Userform.
Please tick all below References and show Userform before using modules.
Modules: FileArrangement.bas, EmailRetrieve.bas, DragDrop.frm
Communication between Excel and Database via ADOdb
connection. Loop through each row in selected range (visible cells only), push update to server, pull the newest table back and restore filters.
Please add "Microsoft ActiveX Data Objects 6.1 Library" to apply ADODB early binding.
Modules: EventMenu.bas, ReduceSize.bas, ADODB.bas
Missing data in some cells. Sort reference columns and input IF function into blank cells.
Modules: FillMissing.bas
Please feel free to fork, comment or give feedback to ng.tridung97@gmail.com