Article View: pl.comp.lang.vbasic
Article #104601VB.NET Excel - odczyt z zamknietego pliku
From: Janusz
Date: Sun, 11 Apr 2010 19:03
Date: Sun, 11 Apr 2010 19:03
16 lines
1387 bytes
1387 bytes
W excelu odczytuje komorke "B2" w zamknietym pliku
GetValue=Application.ExecuteExcel4Macro("'C:\Katalog[Plik.xls]Arkusz1'!R2C2")
i to mi dziala.
Teraz chcialbym to samo z poziomu vb.net:
Dim oXL As New Excel.Application
GetValue=oXL.ExecuteExcel4Macro("'C:\Katalog[Plik.xls]Arkusz1'!R2C2")
a to zwraca mi "-2146826259" (co oznacza chyba #NAME?)
Jaki argument podac w funkcji?
Janusz
Technical Details
Message-ID:
<hpt6cf$gpb$1@atlantis.news.neostrada.pl>Path:
mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.gazeta.pl!newsfeed.pionier.net.pl!news.glorb.com!news-out.readnews.com!transit3.readnews.com!nx02.iad01.newshosting.com!newshosting.com!newsfeed.neostrada.pl!unt-exc-02.news.neostrada.pl!atlantis.news.neostrada.pl!news.neostrada.pl!not-for-mailShow Full Headers
Complete Article Headers
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.gazeta.pl!newsfeed.pionier.net.pl!news.glorb.com!news-out.readnews.com!transit3.readnews.com!nx02.iad01.newshosting.com!newshosting.com!newsfeed.neostrada.pl!unt-exc-02.news.neostrada.pl!atlantis.news.neostrada.pl!news.neostrada.pl!not-for-mail From: Janusz <sinftp@op.pl> Newsgroups: pl.comp.lang.vbasic Subject: VB.NET Excel - odczyt z zamknietego pliku Date: Sun, 11 Apr 2010 21:03:26 +0200 Organization: TP - http://www.tp.pl/ Lines: 16 Message-ID: <hpt6cf$gpb$1@atlantis.news.neostrada.pl> NNTP-Posting-Host: ajy147.neoplus.adsl.tpnet.pl Mime-Version: 1.0 X-Trace: atlantis.news.neostrada.pl 1271012560 17195 83.26.2.147 (11 Apr 2010 19:02:40 GMT) X-Complaints-To: usenet@news.neostrada.pl NNTP-Posting-Date: Sun, 11 Apr 2010 19:02:40 +0000 (UTC) User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; pl; rv:1.9.1.9) Gecko/20100317 Thunderbird/3.0.4 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 7bit