Call VBA procedure with VB Script

[Autoeng]

Is it possible to execute a VBA procedure from VB Script?

Autoeng

 

[dougcranston]

Autoeng

What app are you referring to?

I have created some VBA modules that can be triggered by a Macro.

You can then call the MACRO from the commandline when executing MS Access, and it in turn runs the VBA. Whether this would work in MS Word or MS Excel or any other VBA enabled app could not say.

DougCranston

 

[Autoeng]

I am using Data Access Pages to interface with an Access backend. The need is to initiate a download of data created by a query.

Autoeng

 

[dougcranston]

Ok.

You have an Access backend.

You said your using Data Access Pages. Are you using ADO?

You can create a VBScript that can connect to the MDB, run a query and create a file that can be emailed, and I suppose FTP'd assuming this is running on a server.

If your running or will be running tha app on your workstation it too can connect to a MDB via ADO, pull the data, create and Excel spreadsheet (assuming you do not exceed 65000 lines or use Filesystemobject to write it to a file.

And again it can be triggered via AT or Task Scheduler.

DougCranston