VBA on Office suite / Visual Basic for application
Developed / consultant VBA macro on MS Excel
- to enhance excel task to highest productive working (easier and faster. espectially for repeatative task,routine task)
- develop a formula for a specific function that not provide by excel
- convert /manipulate text file to data record
- convert /manipulate web page to data record by Firefox extension. for example VLAP
- connect to UNIX machine for download , upload data ,send command to unix
- RS232 RS422 RS485 communication to PC / microcontroller / RS232 device
example: control oscilloscope prototypeclick
- If your machine/equipment can control over RS232 port, but the command that provide by equipment not enough to support your job ,you can send a mail to us to finding better solution
-
developed / consultant VBA macro on MS Word, Powerpoint, MS-Project.
Ideally for creating a large number of document / report (with fix style or fix pattern).
For example, a word file autogenerated from the calculation of Excel files. click
- developed / consultant VBA macro with Visio
Better solution for creating complexity geometry diagram click
Visual Basic / Matlab /Minitab
- developed / consultant
visual basic Matlab's M file
- developed / consultant minitab's macro
if your task require minitab to calculation a hugh statistical data sets ,try the macro to faster your task done
Microcontroller / Electronic
- developed / consultant /modified the C ,
assembly program on PIC microcontroller (or the legacy like Z180 ,MCS51)
- Transmission /encoding /decoding infrared Remote control on various protocol like RC5/philips ,Sony SIRC, JVC ,Panasonic ,etc. This can add feature to your product with remote controlable.
- infrared distance sensor related.
- datalogger related.
Any question / comment / need support pls email to vbaserv [at] yahoo.com Home