Previous "upwork.com". Enjoying coding since 1995 ; DOS-Lotus 123 spreadsheets to: VBA Excel macros,VB.

Encapsulating VB software with VBA Automation/ Macros (Excel,Word,Access,CSV), HTML, PDF ...is my forte.

???EXCEL???
* Worksheet functions: Lookup, Math, Text, Logical, Array, Linking Formulas, Validation.
* Controlling input/output with COOL USERFORMS and BUTTONS,Right click menu.
* Setting up Printing / Exporting options via PDF, XLSX,CSV,TXT..
* Arranging/Manipulating/Linking/Structuring/Worksheet Data.
???VBA???
And for using Excel for more than number crunching there comes VBA. Here are some of VBA-Excel scripting (Macros) skills:
* Producing results in one click of all the skills described above.
* Working with Ranges
* Creating UDF (user defined functions)
* Automating sorting, subtotals, workbook and worksheet operations.
* Looping- For Next, Do Loop, For-Each
* Event programming
* Advanced Userforms, graphics, usercontrols
* File operations csv, txt, pdf, mdb....
* Combining, Filtering, Splitting, Exporting workbooks
* Reading from Web
* Error handling
* creating keyboard shortcuts custom menus / Toolbars to run macros

* VBA Automation Excel-Access-Word-Pdf -HTML-CSV-TXT- VCF Data
* VB, , SQL,Complex Excel spreadsheets/Formulas
* C++,DOS ( Batch )

• Windows desktop softwares and utilities (MSI/CAB/EXE)
• Standalone Setup (MSI/CAB/EXE) for Excel files(incl. all Forms and Controls).
• Data Scraping from pdf, softwares and websites through VBA
• Cool VBA Forms and controls.
• Conversion of data To and From different databases / files i.e.
html, pdf, mdb, doc, docx, xls, xlsm, csv, txt, xml etc.
• Automation of Excel,Word.

Attachments (Click to Preview)