Re: Excel i VBA

Article View: pl.comp.lang.vbasic

Article #92395

Back to pl.comp.lang.vbasic Previous Next

#92395

From: Piotr Lipski
Date: Tue, 25 Oct 2005 13:00

15 lines
1243 bytes

Dnia Tue, 25 Oct 2005 12:52:08 +0200, LECH DUBROWSKI napisał(a):

>> NTG
>> W excelowym helpie poszukaj informacji nt. tabel przestawnych.
> 
> Tabele przestawne znam ale czlowiek chce dostac makro w VBA

No to zrób tabelę przestawną i napisz w VBA

Worksheets("Arkusz1").PivotTables("Tabela1").RefreshTable

Będzie wilk syty i owca cała...

-- 
PL

Technical Details

Message-ID: <djla6i$b8h$1@news.onet.pl>

Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!newsfeed.gazeta.pl!news.onet.pl!not-for-mail

References: <djku90$gf2$1@nemesis.news.tpi.pl> <djl342$cgu$1@atlantis.news.tpi.pl> <djl3fh$e2r$1@atlantis.news.tpi.pl>

Show Full Headers

Complete Article Headers

Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!newsfeed.gazeta.pl!news.onet.pl!not-for-mail
From: Piotr Lipski <piotr.lipski@nie.p0czta.spamuj.b0.onet.w.ryj.pl>
Newsgroups: pl.comp.lang.vbasic
Subject: Re: Excel i VBA
Date: Tue, 25 Oct 2005 15:00:29 +0200
Organization: Onet.pl
Lines: 15
Sender: Piotr Lipski <>
Message-ID: <djla6i$b8h$1@news.onet.pl>
References: <djku90$gf2$1@nemesis.news.tpi.pl> <djl342$cgu$1@atlantis.news.tpi.pl> <djl3fh$e2r$1@atlantis.news.tpi.pl>
NNTP-Posting-Host: farmfrites.ext.ids.pl
Mime-Version: 1.0
X-Trace: news.onet.pl 1130245139 11537 213.77.126.170 (25 Oct 2005 12:58:59 GMT)
X-Complaints-To: usenet@news.onet.pl
NNTP-Posting-Date: Tue, 25 Oct 2005 12:58:59 +0000 (UTC)
X-Sender: k8V2QDKeTIFe2ZofQR+7UwJQvFq7Hofm8IvhXReqMQ4=
User-Agent: 40tude_Dialog/2.0.15.1pl
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Reply to Parent Message