We present solution models for the rhyolite-H2O-CO2 and basalt-H2O-CO2 systems at magmatic temperatures and pressures below ~ 5000 bar. The models are coded as macros written in Visual Basic for Applications, for use within MicrosoftR Excel (Office'98 and 2000). The series of macros, entitled VOLATILECALC, can calculate the following: (1) Saturation pressures for silicate melt of known dissolved H2O and CO2 concentrations and the corresponding equilibrium vapor composition; (2) open- and closed-system degassing paths (melt and vapor composition) for depressurizing rhyolitic and basaltic melts; (3) isobaric solubility curves for rhyolitic and basaltic melts; (4) isoplethic solubility curves (constant vapor composition) for rhyolitic and basaltic melts; (5) polybaric solubility curves for the two end members and (6) end member fugacities of H2O and CO2 vapors at magmatic temperatures. The basalt-H2O-CO2 macros in VOLATILECALC are capable of calculating melt-vapor solubility over a range of silicate-melt compositions by using the relationships provided by Dixon (American Mineralogist 82 (1997) 368). The output agrees well with the published solution models and experimental data for silicate melt-vapor systems for pressures below 5000 bar. ?? 2002 Elsevier Science Ltd. All rights reserved.