Jump to content
Macro Express Forums


  • Content Count

  • Joined

  • Last visited

  • Days Won


Everything posted by amonaghan

  1. Slightly off topic, but just to prove the point about proof reading:- Olny srmat poelpe can raed this. I cdnuolt blveiee that I cluod aulaclty uesdnatnrd what I was rdanieg. The phaonmneal pweor of the hmuan mnid, aoccdrnig to a rscheearch at Cmabrigde Uinervtisy, it deosn't mttaer in what oredr the ltteers in a word are, the olny iprmoatnt tihng is that the first and last ltteer be in the rgh it pclae. The rset can be a taotl mses and you can still raed it wouthit a porbelm. This is bcuseae the huamn mnid deos not raed ervey lteter by istlef, but the word as a wlohe. Amzanig huh? Yaeh and I awlyas tghuhot slpeling was ipmorantt! If you can raed this psas it on !!
  2. Terry, You could try this. I haven't tried it yet myself yet. http://www.mrexcel.com/forum/excel-questions/285128-st-nd-rd-th-format-date.html#post1400910 OR THIS http://www.cpearson.com/excel/Ordinal.aspx Good luck. Alan Monaghan
  3. Terry, an easier way would be to just change the format in Excel from 'dddd dd mmmm' to 'dddd d mmmm'. I use 2007, but assume this will work in 2000 too. Alan
  4. Caveat: I haven't supplied a bug report for this yet as I have some more testing to do before confirming that this is being caused by MEP. Having received a shiny new Windows 8.1 PC, I transferred my copy of Macro Express Pro over to it. After a little while I began to notice that the PC was hanging and unresponsive after opening File Explorer (formerly windows explorer NOT internet explorer). I first noticed this while doing some music file editing using Windows Media Player 12. I would right click a track and select 'open file location' and after 2 or 3 times, I would be presented with a completely blank File Explorer with no left or right panes or ribbon along the top. Worse still, I was unable to access any other running program or taskbar items. The only course of action was to Ctrl-Alt-Del to reboot PC. After a few frustrating times, I decided to try selective start ups to isolate the program causing the problem. Unfortunately, it looks like it is MEP. When the issue happens now, opening Task Manager and forcing MEP to close returns the PC to its working state. Has anyone else encountered this issue before I send in a bug report? PS. I have uninstalled MEP for now to do more repeat testing, but so far, all is working correctly. Subject Header is missing 'unresponsive'. Sorry!
  5. I think you need to change the following line:- Window Activate: Access* with Window Activate: *Access or Window Activate: Microsoft Access* Likewise with your 'Wait for Window Title' line. Regards Alan
  6. I did something similar to that Cory several years ago for lengthy work projects, but can't seem to be able to find it anymore, sadly.
  7. That's odd. I haven't used Office 2010, but below comes straight from Excel 2007 help pages. Can I customize the Ribbon? The Ribbon, which is part of the Microsoft Office Fluent user interface, is designed to help you quickly find the commands that you need to complete a task. Commands are organized in logical groups that are collected together under tabs. Because each tab relates to a type of activity, such as writing or laying out a page, it is not possible to customize the Ribbon without using XML and programming code. Things you can't do Add to or rearrange the commands on the Ribbon Change or remove a command or group on the Ribbon Add tabs to the Ribbon, unless you use XML and programming code Switch to the toolbars and menus from earlier versions of Microsoft Office Things you can do Minimize the Ribbon to make more space available on your screen Move the Quick Access Toolbar to position it below or above the Ribbon Customize the Quick Access Toolbar to add buttons that represent the commands that you frequently use Use XML and programming code to extend the Fluent user interface by adding custom tabs, buttons, check boxes, or Dialog Box Launchers. For more information, go to the Microsoft Developer Network (MSDN).
  8. A quick search threw this up:- http://www.winhelponline.com/blog/run-bat-files-invisibly-without-displaying-command-prompt/
  9. I recently had to do a clean re-install of my Vista system and now have an issue. Previously I had a macro open up my online banking site using the 'Web Site' command, which would open up Internet Explorer then fill my details in to logon. After the clean install, when I run the macro, Intenet Explorer remains flashing in the taskbar rather than taking focus and allowing text entry. I doubt if this is a bug, so I thought I would try here to see if others have come across this issue and know of a workaround. I know I could use 'Launch ...' etc, but why has this stopped working?
  10. You could try puting the following line before the Text Type commands - <KEYSTROKE SPEED Delay="10"/>
  11. This looks like another possibility Terry. The problem is it is the login page to my personal banking, so capturing the URL and trying to download the HTML using Cory's method (VBScript) doesn't work. This is when issuing the URL the page returned is different from the original page (security reasons I'm sure). This used to be easy in earlier versions of IE by using Search for text then a TAB would take you to where you wanted to be on that page. Then you could select text from that point on the page. Later versions don't seem to allow this sadly. So now I have to capture the whole source code and drill it down or do a CTRL+C of the page then drill that down. Oh well, I'm getting there.
  12. Hello everyone! I've been racking my brains and am all Googled out trying to find what should be very simple. How do you get the full current URL from the address bar and store it as a string variable? I know you can do an <ALT>+<D> followed by COPY but I don't want to navigate away from my current position in the page. I assume this can be done using HTML / VB Script / JScript (I don't have Autoit installed)? I've found some code examples on the net, but don't know how to impliment these into MEP. I have tried using Extenal Script, but so far it keeps coming up with syntax errors or hangs the macro. Does anyone have a simple way of doing this and if so, how do I interface it with the External Script command? Thanks in advance!
  13. I think you are being a bit unfair on Windows Scheduler there though. If you read the following link it explains how chkdsk is fired up on startup. Microsoft Support
  14. Move Mouse to Tray Icon command works for me. I think it only works if the icon is visible though. It is found under the Mouse commands. Don't have Win7 here, but works on XP.
  15. amonaghan


    This may answer your question:- See Here
  16. Thanks for the welcome back Terry. I have been back for ages, only I was made redundant back in December, so have had other issues to deal with. Still not in work, but I am hopeful of something very soon. It’s just a pity I couldn’t convince my former employer of the value of the job I did, including massive time (cost) savings due to the use of ME3 then MEP. Maybe I should have asked my local MP (Gordon Brown) to step in and stop the redundancies. - Oh well perhaps not then Oh well! 'Onwards and Upwards', as they say. Alan Monaghan Kirkcaldy, Scotland
  17. Terry, Well I know I had several of my early posts deleted after having my account closed. This was after being wrongly mistaken for a spammer after posting to alert people of a spammed message. This may explain it. Alan Monaghan Kirkcaldy, Scotland
  18. What I got to work was to resize the ME Pro Explorer window prior to File/Import operation. It still popped up the window beneath the Explorer window, but I was able to navigate to it and import my macros. Alan, KDY
  19. Sorry, about the double post but the forum software has changed a lot since my last reply post and I made a bit of a mess of things!! How do you delete a mistaken post? Anyway, George. I have experienced a similar problem in v3.7a. When I import from a csv file into a databse using TYPE var it inexplicably changes the case of a random letter within one of the fields. This only appears to happen with data which is all UPPER case and it only seems to do it for one character in the field and it doesn't do it for every record (a handfull in every few thounsand). I have also checked the integrity of the original data and it is definitely being changed. Given time, I will attempt to test to see if this is happening when reading from the file or when it is TYPEing it out. Alan Monaghan
  20. Lars, One way would be as follows:- Go to Options / Preferences / Passwords / Password on Edit Click on [Change] If you haven't previously set this password, skip 'Old Password' field and enter your chosen password in 'New Password' field then confirm it, then click on [OK] Click on [Apply] then [OK] You should now end this session of ME by going to File / Terminate Macro Express Editor and Player When you next start ME it will prompt for a password. Alan, Kirkcaldy, UK
  21. Could you post the URL you are trying to access? Alan
  • Create New...