implemt VB on Excel

[Anavim]

hi !

i want to know where i can find information for implemt VB on Excel .

for example :

1. how i connect to the excel file ?
2.how i import the data ?
3.write to the Excel .
4.refer to specific sheet in the *.xls file .
.
.
......

I know how to work with SQl but in this issue i need to work with excel .

so if ytou know on any site ,place ,articals please let me know .

regards ,

[dlm]

Hi,

An easy way to know wich code you have to use, is by Recording a new macro in Excel, save the macro.
When you want to play the macro, you can choose the macro and edit it instead of running it...and so you can view your VB code to use...