Application of visual basic in high-throughput mass spectrometry-directed purification of combinatorial libraries

Area of Science:

• Analytical Chemistry
• Computational Chemistry
• Medicinal Chemistry

Background:

• High-throughput purification (HTP) is crucial for combinatorial library synthesis.
• Manual sample submission and data handling in HTP processes are time-consuming and prone to errors.
• Efficient data management is essential for accelerating drug discovery and development.

Purpose of the Study:

• To develop and implement a customized electronic system for sample submission in HTP.
• To improve the efficiency and accuracy of data handling for preparative liquid chromatography-electrospray ionization mass spectrometry (LC-ESI-MS).
• To enable on-line verification and retrieval of purification data for medicinal chemists.

Main Methods:

• Development of Visual Basic and Visual Basic for Applications (VBA) programs using Microsoft Visual Basic 6 and Excel 2000.
• Integration of these programs into the HTP workflow for electronic data submission.
• Implementation of functions for on-line status verification and data retrieval.

Main Results:

• Successful implementation of a seamless electronic sample submission and data handling system for HTP.
• Significant reduction in paperwork and manual data manipulation, leading to increased work efficiency.
• Medicinal chemists gained on-line access to purification status and postpurification data.

Conclusions:

• The developed user-friendly and cost-effective software significantly enhances efficiency in HTP processes.
• Electronic submission and data management improve workflow automation and reduce operational bottlenecks.
• This approach facilitates faster and more reliable purification of combinatorial libraries for drug discovery.