Asking for the connectivity of excel

Dear Sir,
Please let me know about the connectivity of excel in VB i.e my
Front-end will be in VB6.0,but my back-end calculation will be in Excel
Sheet (Coding).Please let me know at your convenience.
Sweta....


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Sweta,
If by connectivity you mean - how you will use the functions in Excel from
VB then you have to treat Excel just like any other ActiveX object. So in
your program you create a reference to Excel. Your code starts off creating
an Excel application and then the other objects in Excel and using the object
model of Excel.
Hope this answers your question.
Alok

"Sweta Kumar" wrote:

>
> Dear Sir,
> Please let me know about the connectivity of excel in VB i.e my
> Front-end will be in VB6.0,but my back-end calculation will be in Excel
> Sheet (Coding).Please let me know at your convenience.
> Sweta....
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!
>

You need to use automation. What specifically do you want to know?

This article might get you started


http://msdn.microsoft.com/archive/de...automation.asp
OLE Automation: Communicating with Other Applications




--

HTH

RP
(remove nothere from the email address if mailing direct)


"Sweta Kumar" <swetayan@rediffmail.com> wrote in message
news:e0QBBawKFHA.4092@TK2MSFTNGP10.phx.gbl...
>
> Dear Sir,
> Please let me know about the connectivity of excel in VB i.e my
> Front-end will be in VB6.0,but my back-end calculation will be in Excel
> Sheet (Coding).Please let me know at your convenience.
> Sweta....
>
>
> *** Sent via Developersdex http://www.developersdex.com ***
> Don't just participate in USENET...get rewarded for it!