Re: odczyt danych z arkusza excela

Article View: pl.comp.lang.vbasic

Article #92228

Back to pl.comp.lang.vbasic Previous Next

#92228

From: tomb
Date: Thu, 20 Oct 2005 15:22

29 lines
1855 bytes

Dzieki za odpowiedz,

po zastosowaniu Twojej instrukcji  w petli :

 p_kraj(z, i) = Cells(z + 6, i + 3).Value

wyrzuca mi Run-time error'1004':
Method 'Cells' of object  ' _Global ' faild

A widzac, nie powiazales  metody Cells z objektem Excela,

to dopisalem:

p_kraj(z, i) = Cstr( App.Excel.Worksheets(1).Cells(z + 6, i + 3))

i tym razem wyrzuca mi:
Run-time error '13:
Type mismatch

Tablica jest zadeklarowana Jako string to czemu 'Type mismatch' ?

Drugie pytanie Czy  metoda:

AppExcel.Range("C6:U68").Select

nie jest szybsza niz odczyt pojedynczych komorek w 2 petlach??

Pzdr,
Tomek

Technical Details

Message-ID: <1129821758.325818.84220@g43g2000cwa.googlegroups.com>

Path:

mbox-mo1.pugleaf.net!number1.nntp.dca.giganews.com!border1.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!g43g2000cwa.googlegroups.com!not-for-mail

References: <1129802722.048515.297260@g43g2000cwa.googlegroups.com> <1129804852.338526.69360@g49g2000cwa.googlegroups.com>

Show Full Headers

Complete Article Headers

Path: mbox-mo1.pugleaf.net!number1.nntp.dca.giganews.com!border1.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!g43g2000cwa.googlegroups.com!not-for-mail
From: "tomb" <tomb.fish@gmail.com>
Newsgroups: pl.comp.lang.vbasic
Subject: Re: odczyt danych z arkusza excela
Date: 20 Oct 2005 08:22:38 -0700
Organization: http://groups.google.com
Lines: 30
Message-ID: <1129821758.325818.84220@g43g2000cwa.googlegroups.com>
References: <1129802722.048515.297260@g43g2000cwa.googlegroups.com> <1129804852.338526.69360@g49g2000cwa.googlegroups.com>
NNTP-Posting-Host: 161.85.127.140
Mime-Version: 1.0
X-Trace: posting.google.com 1129821763 22059 127.0.0.1 (20 Oct 2005 15:22:43 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 20 Oct 2005 15:22:43 +0000 (UTC)
In-Reply-To: <1129804852.338526.69360@g49g2000cwa.googlegroups.com>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.12) Gecko/20050915 Firefox/1.0.7,gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: g43g2000cwa.googlegroups.com; posting-host=161.85.127.140; posting-account=Tuw8sg0AAADaGGW335NEUZaJ54hVx8yM
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit

Reply to Parent Message