How to pass parameters to procedures from Access to Excel

Article View: comp.databases.ms-access

Article #400

Back to comp.databases.ms-access Previous Next

#400

From: Desmond Leung
Date: Mon, 18 May 1998 00:00

14 lines
1272 bytes

Hi all,

I want to write some OLE automation procedure from Access95 to Excel95.
Does anyone know how to pass any parameters from procedure in Access95
to procedures written in Excel95.

I do not want to write those parameters on the worksheet and then read it
from procedure
in Excel 95!

Many Thanks,

Desmond Leung

Technical Details

Message-ID: <6joa55$9ej$1@dover.cityu.edu.hk>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 101bdd,9ee6467ae382e0e1,start
X-Google-Attributes: gid101bdd,public
X-Google-Thread: 111a5a,9ee6467ae382e0e1,start
X-Google-Attributes: gid111a5a,public
X-Google-Thread: ff0ac,9ee6467ae382e0e1,start
X-Google-Attributes: gidff0ac,public
X-Google-Thread: 10cc0d,9ee6467ae382e0e1,start
X-Google-Attributes: gid10cc0d,public
X-Google-Thread: 102b1d,9ee6467ae382e0e1,start
X-Google-Attributes: gid102b1d,public
From: "Desmond Leung" <ckkleung@cs.cityu.edu.hk>
Subject: How to pass parameters to procedures from Access to Excel
Date: 1998/05/18
Message-ID: <6joa55$9ej$1@dover.cityu.edu.hk>
X-Deja-AN: 354180945
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.2106.4
Organization: City University of Hong Kong
Newsgroups: comp.databases.ms-access,de.comp.datenbanken.ms-access,es.comp.bd.ms-access,microsoft.public.access.forms,microsoft.public.access.odbcclientserver