Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Excel Function in VB.NET
Message
 
À
23/03/2007 14:43:37
Information générale
Forum:
ASP.NET
Catégorie:
Autre
Versions des environnements
Environment:
VB 8.0
OS:
Windows XP SP2
Network:
Windows 2000 Pro
Database:
MS SQL Server
Divers
Thread ID:
01207895
Message ID:
01207936
Vues:
19
Gabriel,

You can do it similar to the way it can be done in VFP:
.....
oExcel= CREATEOBJECT("Excel.Application")
oExcel.Visible=.t.
oExcel.Workbooks.Open(...)
.......
oExcel.ActiveCell.Formula = '=FORECAST(30,A2:A6,B2:B6)'
? oExcel.ActiveCell.value
.....
Good Luck

>Hi over there,
>
>I'm need to use the excel function call "Forecast" in my proyect in VB.Net
>and i don't know how to do this.
>
>i'm trying this 'cause i don't find any vb.net function that do the same.
>
>Gracias por anticipado.
>
>Saludos desde Santo Domingo.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform