scheduling access

Here is a short list of some program ID's:

+========================+======================== =================+
| Office Server | CLSID Key |
+========================+======================== +
| Access.Application | {73A4C9C1-D68D-11D0-98BF-00A0C90DC8D9} |
+------------------------+-----------------------------------------+
| Excel.Application | {00024500-0000-0000-C000-000000000046} |
+------------------------+-----------------------------------------+
| FrontPage.Application | {04DF1015-7007-11D1-83BC-006097ABE675} |
+------------------------+-----------------------------------------+
| Outlook.Application | {0006F03A-0000-0000-C000-000000000046} |
+------------------------+-----------------------------------------+
| PowerPoint.Application | {91493441-5A91-11CF-8700-00AA0060263B} |
+------------------------+-----------------------------------------+
| Word.Application | {000209FF-0000-0000-C000-000000000046} |
+------------------------+-----------------------------------------+


Source: http://support.microsoft.com/kb/244264


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/ex...tributors.html
__________________________________________

"David W. Fenton" wrote:

patti wrote in
:

I will research VBScript. Any advice on where to start?

Try just pasting your code into a VBS file and running it. That
should tell you what doesn't work. At that point you'd then need to
find the ProgIDs of the apps you're automating in order to use
CreateObject. It might be easier to do that in combination with
Access and its references (i.e., use the reference dialog to find
the name of the TLB/DLL/OCX in use, then search for that in the
Registry).

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Tom Wickerath AOS168b AT comcast DOT net wrote in
:

Here is a short list of some program ID's:

[snip]

Source: http://support.microsoft.com/kb/244264

Those are quite easy. It's the ProgIDs for less extensive components
like the scripting host that are harder to come by. You have to
search for the executable in the Registry and then figure out which
of the various classes are the correct ProgID for what you need to
do.

There ought to be a reference somewhere, but I've never come across
it. Too bad the references dialog in the VBE doesn't display the
top-level ProgID for each library listed there.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Thanks all for all the help. Learning tons.

"patti" wrote:

i have written my vba code, tied code to macros, written my script in notepad
& used ms scheduled tasks to run things.

It works!!!

But (always a but) my accessDB is on a server, while access application,
scheduler and scripts are located on one certain pc so that pc has to always
be on. Is there a way to move all this to the server, so that it is
independent? I'm so confused i don't even know if i am asking the rght
questions. And if this is the right place to ask these questions.

thanks for any & all help.

patti