2002•Journal of Zhejiang Ocean UniversityRequires access

An Illustration for Using Excel Object in VB

Guang Li

Open publisher page 0 citations

Abstract

This article gives an example of transferring Excel object in VB, using VB to program and putting the original data, the intermediate data and the results into Excel file to solve the linear equations. Meanwhile it introduces ways to use VB to transfer Excel, to put the data into the Excel cells, to format and numerically calculate the contents of the cells, to and send the calculated results from Excel back to VB.

About this research paper

What this paper is about

This article gives an example of transferring Excel object in VB, using VB to program and putting the original data, the intermediate data and the results into Excel file to solve the linear equations. Meanwhile it introduces ways to use VB to transfer Excel, to put the data into the Excel cells, to format and numerically calculate the contents of the cells, to and send the calculated results from Excel back to VB.

Why it matters

A significance statement is not available in the OpenAlex record.

Key contribution

A contribution statement is not available in the OpenAlex record.

Method / approach

Method details are not available in the OpenAlex metadata.

Main findings

Findings are not separately available in the OpenAlex metadata.

Limitations

Limitations are not available in the OpenAlex metadata.

Applications

Application details are not available in the OpenAlex metadata.

Available abstract

This article gives an example of transferring Excel object in VB, using VB to program and putting the original data, the intermediate data and the results into Excel file to solve the linear equations. Meanwhile it introduces ways to use VB to transfer Excel, to put the data into the Excel cells, to format and numerically calculate the contents of the cells, to and send the calculated results from Excel back to VB.

Key concepts: Ms excel, Computer science, Object (grammar), Microsoft excel, Visual Basic, Computer graphics (images), Transfer (computing), Data file

Related papers

Back to paper searchBrowse research topicsOriginal source
An Illustration for Using Excel Object in VB — Research Paper | ScholarLens