Sortowanie w EXCEL-u ale z poiiomu Acces-a

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

Article #137837

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

#137837

From: siwy5
Date: Fri, 14 Apr 2023 12:19

9 lines
1693 bytes

Witam,

"Wysyłam" do Excella:
app.Application.Worksheets(zakladka).Range("A7:AB20").Sort Key1:=Range("AB7"), Order1:=1, Header:=0, OrderCustom:=1, MatchCase:=False, Orientation:=1, DataOption1:=0

i oczywiście Access frazę  ...Range("AB7")... widzi jako funkcję ACCESS-a 
Jak to "wysłać aby Access nie interpretował ...Range("AB7")... jako włąsnej funkcji?
Pozdrawiam
Daniel

Technical Details

Message-ID: <95a99945-1cf3-49ac-a9cc-1cd90f03c1d3n@googlegroups.com>

Path:

mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!newsfeed.pionier.net.pl!2.eu.feeder.erje.net!3.us.feeder.erje.net!feeder.erje.net!usenet.blueworldhosting.com!diablo1.usenet.blueworldhosting.com!peer03.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Received: by 2002:a05:6214:1874:b0:5ef:4a0f:d48 with SMTP id eh20-20020a056214187400b005ef4a0f0d48mr375779qvb.2.1681474755727;        Fri, 14 Apr 2023 05:19:15 -0700 (PDT)
X-Received: by 2002:a81:ed11:0:b0:54f:a986:3f94 with SMTP id k17-20020a81ed11000000b0054fa9863f94mr3576890ywm.3.1681474755489; Fri, 14 Apr 2023 05:19:15 -0700 (PDT)
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.icm.edu.pl!newsfeed.pionier.net.pl!2.eu.feeder.erje.net!3.us.feeder.erje.net!feeder.erje.net!usenet.blueworldhosting.com!diablo1.usenet.blueworldhosting.com!peer03.iad!feed-me.highwinds-media.com!news.highwinds-media.com!news-out.google.com!nntp.google.com!postnews.google.com!google-groups.googlegroups.com!not-for-mail
Newsgroups: pl.comp.bazy-danych.msaccess
Date: Fri, 14 Apr 2023 05:19:15 -0700 (PDT)
Injection-Info: google-groups.googlegroups.com; posting-host=185.251.37.138; posting-account=2H1BSAoAAADt5XeMBdV47foqa1rmVY0f
NNTP-Posting-Host: 185.251.37.138
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <95a99945-1cf3-49ac-a9cc-1cd90f03c1d3n@googlegroups.com>
Subject: Sortowanie w EXCEL-u ale z poiiomu Acces-a
From: siwy5 <banasdaniel@poczta.onet.pl>
Injection-Date: Fri, 14 Apr 2023 12:19:15 +0000
X-Received-Bytes: 1509
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit