If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
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/ |
#12
|
|||
|
|||
scheduling access
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/ |
#13
|
|||
|
|||
scheduling access
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 |
|
Thread Tools | |
Display Modes | |
|
|