Article View: free.it.visual-basic
Article #3119Puntare da una cella di Excel.
From: Lucia Rita Carfagno
Date: Tue, 15 Oct 2002 16:55
Date: Tue, 15 Oct 2002 16:55
21 lines
1626 bytes
1626 bytes
Un saluto cordiale a tutto il NG.
Ho adoperato il codice seguente per richiamare un foglio specifico di excel
nel mio programma in Visual Basic ver.6.0:
Dim appbudget As Excel.Application
Dim budget As Excel.Workbook
Dim budgetsheet As Worksheet
Set appbudget = CreateObject("Excel.Application")
Set budget = appbudget.Workbooks.Open("c:\Bilancio di previsione.xls")
Set budgetsheet = budget.Sheets("BIL.PREV.")
budgetsheet.Activate
appbudget.Visible = True
Ora perοΏ½ mi urgerebbe puntare ad una cella specifica all'interno del foglio
di lavoro, οΏ½ possibile questo? Oppure sto chiedendo troppo al VB e.....a me?
Grazie mille
Ciao Rita
Technical Details
Message-ID:
<7MXq9.35093$RO.862812@twister1.libero.it>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-04!supernews.com!news.maxwell.syr.edu!nntp.infostrada.it!twister1.libero.it.POSTED!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ITALIAN,ASCII X-Google-Thread: f94ee,58632ad4a9fd5437,start X-Google-Attributes: gidf94ee,public X-Google-ArrivalTime: 2002-10-15 09:58:02 PST Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-04!supernews.com!news.maxwell.syr.edu!nntp.infostrada.it!twister1.libero.it.POSTED!not-for-mail From: "Lucia Rita Carfagno" <carfagno@unimol.it> Newsgroups: free.it.visual-basic Subject: Puntare da una cella di Excel. Lines: 25 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 Message-ID: <7MXq9.35093$RO.862812@twister1.libero.it> Date: Tue, 15 Oct 2002 16:55:31 GMT NNTP-Posting-Host: 62.98.215.195 X-Complaints-To: abuse@inwind.it X-Trace: twister1.libero.it 1034700931 62.98.215.195 (Tue, 15 Oct 2002 18:55:31 MET DST) NNTP-Posting-Date: Tue, 15 Oct 2002 18:55:31 MET DST Organization: [Infostrada]