Seabass

Next question !!! Like this forum... I have a power point i want to use as a daily screensaver... Basically i use excel data and formulas that update daily counter... things like how many days since last safety incident .... to do this, i createda powerpoint and embedded an excel object into it that contain my graph, data and other little text formatted the way i want. The update part is run by ME 3 at night, i basically delete the existing jpeg from the slides in a specific folder, then open the powerpoint. ME has a few line to click on update link (if you know how to disable that in MS Powerpoint, hit me on here !!!) once i clikc ok... there is a delay that is never the same... i tried the wait for file ready and the wait for mouse curosr type deal...with no success... The only option that seems to work is with a time delay... let's say 30 seconds.... was just wondering is there is anything else i could try... Here is the macro i created..... <DOFILE:04:NN:R:\plantscreen\slides\screensaver>><DELAY:5><LAUNCHDEL2:0:01R:\plantscreen\slides\screensaver.pptx2><WAITWIN2:000010:000000:Microsoft Office PowerPoint Security Notice><DELAY:10><TEXTTYPE:<TAB>><DELAY:1><TEXTTYPE:<TAB>><DELAY:1><TEXTTYPE:<ENTER>><DIS:<DELAY:30><WFREADY:000010:000000:000000R:\plantscreen\slides\screensaver.pptx><TEXTTYPE:<F12>><TEXTTYPE:<TAB>><DELAY:1><TEXTTYPE:j><DELAY:1><TEXTTYPE:<ENTER>><DELAY:1><TEXTTYPE:<ENTER>><DELAY:1><TEXTTYPE:<ENTER> ><WCLS:Microsoft PowerPoint - [screensaver]><TEXTTYPE:<ENTER>> Any suggestion would be greatly appreciated !!! Seabass

thank you !!! i will try thta strategy, seems like this may work.

Anybody using ME to schedule Crystal Report to run and export report automatically ??? if you do, how do you manage the "wait for" the report to be populated with the data from the database ???? i have a macro setup, but somethimes the delay is just longer than what it takes to get the data in so it crashes my macro and do not finish the job.... also, every time i run the macro to test or design, it takes forever.. could i run step by step instead of waiting ???

Hi everyone.... I am trying ot get ME to run some Crystal Report for me and export to a file folders as a pdf... Right now i am running the =macro at night but ideally, i will like ot run multiple times a day... is there a way to run the macro while i am working on the same desktop without interfering....??? any help would be appreciated... Sebastien

This is quite a few years back, is ME running as a Windows Services yet ??? Regards, Sebastien

Good morning all, I am trying to generate a bunch of report every night. The report originate in a MS Access database. We publish the report in a pdf format on a folder. Each filename is refer to on an intranet web page where users can click on the desired reprot and it open up in pdf. To get the report in pdf, i created a button on the database switchboard called " Publish Report" I then wrote (with some assistance from my IT Dept. ) a little code as an event procedure when you click the button. it look like this for each report: DoCmd.OpenReport "rpt WCC DAILY MORNING REPORT SS REPORT", acViewPreview, "", "", acNormal DoCmd.PrintOut acPrintAll, , , acHigh, 1, True DoCmd.Close acReport, "rpt WCC DAILY MORNING REPORT SS REPORT" So to automate this, i create a macro in Macro Express that : Open the database file. (Autoexec macro within the database open up the switchboard form) Delay 15 seconds (to make sure it all load up properly) Text type "Enter" (The button has focus as it is the first selection in the tab order in Access) Once this run, the code "print" each report using the pdf printer to get the pdf report where we want it. So my question to you all is what is the best way to get the macro to select the button and execute it.... A few nights it did not ran as planned even though the schedule time nad macro express were all set properly. Should i use a Get focus or other function versus the text type ???? or can i run a MS Access macro directly from Macro Express, bypassing the text type and all.... FYI, we had the "publish macro" in Access setup in the autoexec macro before, but as we add report, the execution time was too long every time we open up the database... Thanks for any input.... Seabass

allright, so here is my challenge.... (it is for me anyway ! ) We developed a MS Access database and we are now looking at publishing report in a pdf format overnight every day. At this point, we have a switchboard witha button named "Publish Report". The macro, launch Access, wait for the windows and then text type "Enter" as the button has focus once the switchboard is loaded. Is there a way for me to run the MS Access report and print directly from Macro Express instead ??? We are using a Scansoft to generate the pdf file using the Printing functions. This create the pdf report we want and store in folder where we overwrite previous report.... Thanks

What is the difference between, visible, focused or enabled ??? hope this is not a stupid questions....

I build a few macros and i am running into some issues where i wan tthe thing to wait until a program is loaded to type something.... I tried the wait for ... with couple options, but it seems that it just run the macros script without waiting therefore messing up my stuff..... Yup, i am a newbie to this !!! Any help or trick will be appreciated ...!