Export / Import Excel Document coding

shiroamada
06-04-2005, 01:23 PM
I want to ask, any one know the coding import MS excel document inside vb coding. What I mean is, I want create a button, name "Export". I want export my data to MS excel format. Anyone know that?

Shurik12
06-04-2005, 01:33 PM
Could you explain/rephrase what you mean by
"import MS excel document inside vb coding" "...I want export my data to MS excel format"...?

shiroamada
06-04-2005, 10:06 PM
it mean, I want to have a function that can export excel document. I want to create a program that can export data to MS excel format. what is the coding to write that?

Flyguy
06-05-2005, 02:27 AM
The most simple way is using office automation.
In that case you use Excel and fill the sheets in code.

Other option is using ADO and write a plain excel file.

The last option I am aware of is ExcelClass which can create single sheet Excel files in the old version 2 format of Excel. This class can be found in the .. thread.

herilane
06-05-2005, 12:05 PM
Tutorials for both Excel automation and using ADO with Excel files can also be found in Tutors' Corner.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum