Re: export kwerendy do pliku csv

Article View: pl.comp.bazy-danych.msaccess

Article #137322

Back to pl.comp.bazy-danych.msaccess Previous Next

#137322

From: MaciejF
Date: Tue, 29 Nov 2016 13:45

23 lines
2495 bytes

W dniu poniedziałek, 28 listopada 2016 21:57:17 UTC+1 użytkownik Jan Koc napisał:
> Wracam !!
> Nie udaje mi się tego poprawnie zrobić.
> Kod jest następujący:

> 
>     'Set intial filename
>     fd.InitialFileName = "x:\export_" & Format(Date, "yyyymmdd") & ".csv"

Może zmień na:
fd.InitialFileName = "x:\export_DPD.txt"

Wypróbuj poniższe.
Dołącz swój zmodyfikowany kod:

Dim AJ As String 
Dim AB As String 
      AJ = "X:\Export_DPD.txt" 
      AB = "X:\Export_DPD.csv" 
      fSaveAsXlsx AJ, AB 

Pozdrawiam
MF

Technical Details

Message-ID: <a5ca3ae5-6d98-4c89-b3bf-0e8d06822c76@googlegroups.com>

Path:

mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!newsfeed.pionier.net.pl!news.glorb.com!n6no2881254qtd.0!news-out.google.com!j8ni11836qtc.0!nntp.google.com!p16no2880128qta.1!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail

References:

<39d994b6-e28e-4fc2-a084-f06f776fd643@googlegroups.com> <1e537968-eeb9-4b13-b50b-b20a65c94981@googlegroups.com> <5adc9bd5-02aa-431a-9da5-4436331981d0@googlegroups.com> <e2bcce68-05b7-4f32-a98d-c29be8945003@googlegroups.com> <f0871dfd-9ee2-43a6-a20a-0c3c8c7b7c9e@googlegroups.com> <efb3385e-a83b-417d-ad7c-0ecf45246ed5@googlegroups.com> <23f5c5ff-a594-4fb9-8eb3-477cd7eebce0@googlegroups.com> <499a75f3-cb1d-45d9-b7e2-40edd8cf771f@googlegroups.com> <cfdcc8ae-3636-45a6-8e98-354ced6c90c0@googlegroups.com> <042100af-c425-4d32-a758-960f0de71417@googlegroups.com> <a6f43a6d-e9e3-47b6-843e-bb7903bbcdcb@googlegroups.com> <f9cd55f6-4b7b-4c72-82eb-4ddea936f4ed@googlegroups.com> <31f73f11-c349-4c21-abae-26b43a8882b7@googlegroups.com> <a64dbffe-2a58-4aab-8c40-f8b48c875bea@googlegroups.com>

Show Full Headers

Complete Article Headers

X-Received: by 10.36.103.2 with SMTP id u2mr4353703itc.30.1480427142798;        Tue, 29 Nov 2016 05:45:42 -0800 (PST)
X-Received: by 10.157.48.39 with SMTP id d36mr930648otc.1.1480427142738; Tue, 29 Nov 2016 05:45:42 -0800 (PST)
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!newsfeed.pionier.net.pl!news.glorb.com!n6no2881254qtd.0!news-out.google.com!j8ni11836qtc.0!nntp.google.com!p16no2880128qta.1!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups: pl.comp.bazy-danych.msaccess
Date: Tue, 29 Nov 2016 05:45:42 -0800 (PST)
In-Reply-To: <a64dbffe-2a58-4aab-8c40-f8b48c875bea@googlegroups.com>
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=213.241.94.194; posting-account=kc7ZIQoAAAB5PkdJgxjq1dd8jnBK4MVp
NNTP-Posting-Host: 213.241.94.194
References: <39d994b6-e28e-4fc2-a084-f06f776fd643@googlegroups.com> <1e537968-eeb9-4b13-b50b-b20a65c94981@googlegroups.com> <5adc9bd5-02aa-431a-9da5-4436331981d0@googlegroups.com> <e2bcce68-05b7-4f32-a98d-c29be8945003@googlegroups.com> <f0871dfd-9ee2-43a6-a20a-0c3c8c7b7c9e@googlegroups.com> <efb3385e-a83b-417d-ad7c-0ecf45246ed5@googlegroups.com> <23f5c5ff-a594-4fb9-8eb3-477cd7eebce0@googlegroups.com> <499a75f3-cb1d-45d9-b7e2-40edd8cf771f@googlegroups.com> <cfdcc8ae-3636-45a6-8e98-354ced6c90c0@googlegroups.com> <042100af-c425-4d32-a758-960f0de71417@googlegroups.com> <a6f43a6d-e9e3-47b6-843e-bb7903bbcdcb@googlegroups.com> <f9cd55f6-4b7b-4c72-82eb-4ddea936f4ed@googlegroups.com> <31f73f11-c349-4c21-abae-26b43a8882b7@googlegroups.com> <a64dbffe-2a58-4aab-8c40-f8b48c875bea@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <a5ca3ae5-6d98-4c89-b3bf-0e8d06822c76@googlegroups.com>
Subject: Re: export kwerendy do pliku csv
From: MaciejF <maciejfr@onet.pl>
Injection-Date: Tue, 29 Nov 2016 13:45:42 +0000
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

Reply to Parent Message