Jump to content
Macro Express Forums

Pete

Members
  • Content Count

    22
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Pete

  • Rank
    Newbie

Profile Information

  • Gender
    Male
  • Location
    West Byfleet, UK.
  1. 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.
  2. I have just upgraded from ME3 to Pro 6.1.3.1 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
  3. 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
  4. 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.
  5. 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.
  6. 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.
  7. 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.
  8. 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.
  9. Hi Floyd. No its not close. The strange thing is, it works fine 29 times out of 30.
  10. 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.
  11. 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.
  12. 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
  13. Hi Ashley, attached is a playable macro which will do what you want Set String T1 = Peter Modify String Copy Char 1 of T1 to T2 Modify String Copy T2 to T3 Modify String Uppercase T3 Modify String Rplace T2 with T3 in T1 (NOT all instances) There are probably several other ways to do it too. Pete. capitalise.mxe
  14. Hi ffortino, I don't believe so. One way to get round this would be to append all the T variables to a file (CRLF after each one), then process the file using TEXT FILE BEGIN PROCESS. This would process one value at a time in a loop. Maybe you could populate the file instead of the T variables initially ? Pete.
  15. Hi. I have an application which does just this many thousands of times a day. ME passes control to Excel and waits for a dialog box before it continues. It works like this... ME focuses excel workbook. ME sends keystrokes [alt+z] to run Excel macro (VBA). ME waits for CLIPBOARD READY window. Excel Macro does some stuff, then goes to cell and copies to clipboard. Excel Macro spawns CLIPBOARD READY dialog box. ME sends keystroke [ENTER] to close CLIPBOARD READY dialog box. ME populates variable from clipboard. --------- Hope this helps Pete.
×
×
  • Create New...