Jump to content
Macro Express Forums


  • Posts

  • Joined

  • Last visited

Profile Information

  • Gender
  • Location
    West Byfleet, UK.

Pete's Achievements


Newbie (1/14)



  1. With reference to the original problem of printing multiple .PDF files. You should be able to launch acrobat from the command line with parameters for the specific file, and to print to a specific printer. This might reduce the amount of window manipulation that needs to be done by MEx? https://stackoverflow.com/questions/619158/adobe-reader-command-line-reference There is also a utility which may help you here - http://www.columbia.edu/~em36/pdftoprinter.html I haven't looked at these options in any depth, but you may want to explore further.
  2. Solved. The issue was investigated by Kevin at Insight:- ME3 does not have an "Hour" option for scheduling a macro, but you could have a "minute" value of over 59. I had one ME3 macro with a value of 120 minutes, which after conversion, tripped up the ME6Pro scheduler. I changed the schedule to every 2 hours 0 Minutes and the problem was solved. Insight will update the conversion routine to correct this. Thanks Kevin.
  3. Update. It is restricted to one large macro file converted from ME3 The same file causes the same issue on 2 PCs The problem does not occur when the offending file is closed. The file has been sent to Insight for analysis.
  4. Thanks everyone, Cory. 1. Frequency is 2 secs, but behaviour doesn't alter with any frequency. 2. Synchronising is on but deactivating it makes no difference. 3. Backing up when the Editor closes. 4. ME runs at startup.The account logged in is an administrator, but I am not specifically running ME as administrator. terrypin There is no macro running, it is logged every time the scheduler checks (every 2 seconds if that is the setting) I will report to Insight.
  5. I have just upgraded from ME3 to Pro Preferences are set to Log Unusual Events. Every time the scheduler checks for Scheduled Macros (whatever frequency is set) I get the following event logged 13 February 2020 09:15:48:206: Datafile.GetActMacros error: Invalid argument to time encode fname: F:\xxxxx\xxxxx\xxxxxxx.mex I doesn't seem to affect macro execution as far as I can tell, but it makes for a large log file, and means I have to have notifications of unusual events turned off. Anyone come across this? Thanks, Pete
  6. I know this topic is 6 months old but I thought I'd add something.... The following registry key can be accessed from and written to by VBA code. HKEY_CURRENT_USER\Software\VB and VBA Program Settings\ I have many ME macros which open an Excel Workbook and run a specific Excel macro utilising this registry key to pass data. To run a specific Excel Macro when a workbook is opened:- 1. Add the following code to the Excel Workbook Private Sub Workbook_Open() Dim sMacroName As String 'Run the Macro in Registry RunExcelMacro, Clear Registry value sMacroName = GetSetting("MyProject", "RunExcelMacro") SaveSetting "MyProject", "RunExcelMacro", "" If sMacroName <> "" Then Application.Run sMacroName End If End Sub 2. Write a registry string containing the name of the Excel Macro, E.G. HKEY_CURRENT_USER\Software\VB and VBA Program Settings\MyProject\RunExcelMacro 3. Launch your Excel workbook and the Excel Macro will run. Hope this helps someone, Pete
  7. Hi Strathos, thanks for the reply. That would be better if they were in static positions on the web page, unfortunately they're not! I've now got a working solution which parses the main page source code and writes the pdf file addresses to a file; I then open each pdf document in turn and save it to my PC. So I know the web addresses of the files, but not where they are physically on the web page. It would be nice to be able to just use a file copy command for the "http\\: directory", then I wouldn't have to wait for all the pdf files to load. I may resort to buying some software which downloads entire web sites, that would do the trick.
  8. Hi, I'm struggling to find a neat way to save a bunch of pdf files from the net to a local folder without loading the file in a browser and then interacting with the browser controls. Does anyone know a better way ? Thanks.
  9. Hi, I can't think of an easy solution, so here's a tricky one, which may or may not work..... Firstly the usual caveat - do not alter any registry entries unless you really know what you're doing, and even then take a back up first! How about setting the default device in the registry to what you want before entering the print dialog? I just had a quick look in my registry and this might be it.... HKEY_CURRENT_USER\SOFTWARE\MICROSOFT\WINDOWS NT\CURRENTVERSION\WINDOWS, Device read what it is store it set it to what you want print dialog set it back to what it was. You will probably have to re-enter the printer dialog each time after setting it for it to be selected. I haven't tried this and I don't know that it will work, but it's worth a try if there's no other solution - good luck. Pete.
  10. A few thoughts-- 1. Check under Options > Preferences > Playback that you are trying the correct key sequence to abort. 2. As this macro is running does the mouse cursor change state ? If so you could test that the mouse is as expected before any clicks, else abort. 3. Validate in other ways that the expected state of photoshop is correct at certain times - if necessary by pixel colour. 4. If you are clicking on controls maybe you could capture those instead of screen locations - it may be more reliable Pete.
  11. I just got a new pc and installed 3.5e. I have noticed a new unwelcome behaviour in macros which have worked peacefully many millions of times for years in 3.4b.... When trying to delete a file which doesn't exist I now get a message "Error Deleting File or Folder" - most annoying. Do I need to try and identify the error window and clear the message? (I'm not sure if I can as the macro seems to be waiting for the window to clear before proceeding.) The only (messy) way round this I can think of is running a .bat file with a dos command in it, as that won't complain about not finding the file? Any ideas ? Thanks, Pete.
  12. Hi Floyd. No its not close. The strange thing is, it works fine 29 times out of 30.
  13. I have an Excel application which spawns a msgbox when it is complete. My ME application has a "Wait For Window Title" command (waiting for the Excel Msgbox), it has a 15 sec timeout. Occasionally, it seems that the Excel app stops running UNTIL the wait for window command times out, and ME Macro is aborted - the Excel app then continues, and gives the msgbox. To me is seems that Macro Express is somehow stopping the Excel VBA from running - is this possible? I've tried using an "If window title is on top" command in a loop instead of the Wait for Window command, but the same thing happens.
  14. MIchele, if you post the code you are using and the web page URL, I'm sure someone will have a look at it. Pete.
  15. Hi Doreen, I think you need to use the command.... Variable Set to ASCII Char (I think TAB is ASCII decimal 9) Good Luck Pete
  • Create New...