Calling Modules & Macros from outside Access 
Author Message
 Calling Modules & Macros from outside Access


Quote:
> I want to call an Access 97 Module from VBS, VBA, JavaScript (ECMA std), Cold
> Fusion & possibly Perl. I want to do this without instatiating an instance of
> Access.

Not possible. To run Access code, Access must be in memory.

-- Ken



Fri, 15 Jun 2001 03:00:00 GMT  
 Calling Modules & Macros from outside Access
Hello VerGin

You should be able to convert the access code into a VB5 or VB6 library and
then call that.

Matthew MacFarland

Quote:
>I want to call an Access 97 Module from VBS, VBA, JavaScript (ECMA std),
Cold
>Fusion & possibly Perl. I want to do this without instatiating an instance
of
>Access.

>I thought that I could use the CALL statement, but I am unable to get it to
work
>correctly.

>I have successfully accessed other collections and objects from the
languages
>mentioned, just not Modules or Macros.

>Anyone have any ideas?



Fri, 15 Jun 2001 03:00:00 GMT  
 Calling Modules & Macros from outside Access

Quote:
>It surprises me that I can call so many other parts of the access db without
>instantiating it, but not run a module.

Not really: modules and macros exist in order to support the GUI,
which has nothing to do with the data, which is what Jet's job is.
Don't forget you can do a great deal of data hiding with with SQL and
precompiled queries.

Best wishes

Tim F

--



Sat, 16 Jun 2001 03:00:00 GMT  
 
 [ 3 post ] 

 Relevant Pages 

1. Calling a Function in an MS Access Class/Form/Module from an outside application

2. Call module functions from outside of module?

3. Calling Macro in Another Module?

4. Answer: User Defined Function in Query called from outside Access

5. How to call (and execute) the DoCmd.RunCommand from outside MS-ACCESS

6. Call Access Module from Data Access Page

7. Access 2000 - calls to Access.exe to document macros

8. Modules/Macros to add prior to using Access 2000

9. Run word macro from Access module code

10. Run Excel Macro from within Access module

11. Req advice on how to activate Excel Macro using Access Module (Msoffice 97)

12. Excel Macro to Access Module

 

 
Powered by phpBB® Forum Software