Jump to content
Macro Express Forums


  • Content count

  • Joined

  • Last visited

Community Reputation

0 Neutral

About amonaghan

  • Rank

Profile Information

  • Gender
  • Location
    Kirkcaldy, Scotland

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

  1. amonaghan

    win key not working

    <TEXT TYPE Action="0" Text="<RIGHTWIN>"/> The above works for me, if it's of any help. <RIGHTWIN> is in Misc Keys in the Text Type command.
  2. amonaghan

    Using <Ctrl>G in Excel to Goto Label

    Oddly, when I try <Control>g from a Popup Menu, it doesn't work. That is, a menu item which simply has the command - Text Type (Simulate Keystrokes): <CONTROL>g
  3. amonaghan

    Simple one-off alarm fails

    I'll give it a further look when I get home from work. I did try a simple shut down macro I use very rarely which definitely used to work in Win10, but failed last night. I'll try again creating it from scratch to see if that makes a difference.
  4. amonaghan

    Simple one-off alarm fails

    I can't get Scheduled macros to run either Terry. I've tried all the compatibility options and also tried in safe mode, but they won't fire in Windows 10 Home. I'm almost sure that they did before, so don't know if it's connected to recent Windows Update or not. Windows 10 Home Version 1709 Build 16299.371
  5. amonaghan

    Cool file downloader

    That's what I'm working towards, possibly doing it all from within Excel. I'm going to use MEP to tie all bits together in the meantime until I suss more out. You've given me a really good start though, so thanks again Cory. Having to leave it until the weekend as I am currently job hunting and have an appointment tomorrow to prepare for. (Not an interview yet).
  6. amonaghan

    Cool file downloader

    That's excellent Cory. I can work with this now. I looked at that GET too, but didn't expand it enough to see the pricing information. A lot of work still for me to do, but I think I can manage it from here. I've even got some sort of working data in Excel now. Definitely bedtime now. Thanks again, Alan
  7. amonaghan

    Cool file downloader

    Cory, I've searched high and low through the URL I posted and can't find any reference to the link you posted. Where did you find that from? How did you know to use the bold part, as I can't find any reference to it in the rest of the code? https://www.premierinn.com/whitbread-services-unsecured/hotels/search/54.97814/-1.61622/40. Incidentally, great work so far, I still need date/price info, but don't know where (other than trawling through all the code) where or what link to use. I found several JSON->CSV/XLSX converters online for later as I tried loading as JSON data file in Excel 2016 but not yet experienced enough in handling the Data module (formally Power Pivot). Alan
  8. amonaghan

    Cool file downloader

    Cory, here's a couple of images:- Alan
  9. amonaghan

    Cool file downloader

    Cory, I know this is an old thread, but I can use the above External Script to grab a hotel website code, but this doesn't seem to include the data elements as displayed when using Chrome. I know I can fudge it and do the following:- 1) Go to Elements tab 2) Select Top most element 3) Edit as HTML 4) Select All 5) Copy etc. but this kind of defeats the purpose of using VBscript. Do you know what lines in the above code that I need to change so that I can download the actual 'Elements' script rather than just the surrounding HTML code? I've looked at the code above and can't see how to do this. Regards, Alan
  10. Is the drop-down list on a web page? If so, you might be better viewing the HTML code and parsing that instead.
  11. amonaghan

    Problem pasting to PaintShop Pro

    Terry, I'm on Windows 10 Home Version 1709 build 16299.214 if it helps.
  12. amonaghan

    Problem pasting to PaintShop Pro

    Terry, I found a copy of PSP 9 lying around and the following works for me. Running man goes shortly after PSP starts up. <ACTIVATE OR LAUNCH Title="Jasc Paint Shop Pro" Exact_Match="FALSE" Wildcards="FALSE" Path="C:\\Users\\Alan\\AppData\\Roaming\\Microsoft\\Windows\\Start Menu\\Programs\\Jasc Software\\Jasc Paint Shop Pro 9.lnk" Mode="\x00" Default_Path="TRUE" Wait="1" Wait_For_Program="12"/> Not sure if it matters, but I used a Shortkey (PSP). Alan
  13. amonaghan

    Problem pasting to PaintShop Pro

    Terry, there have been 11 newer versions of PSP since ver 8. Maybe it is just a compatibility issue with Win10. Have you tried running it in compatibility mode?
  14. amonaghan

    Retrieve Sheetname from Excel

    They both look identical to me.
  15. amonaghan

    Append Macro Data to Shared Google Sheet

    You might want to have a look at this:- https://www.pcworld.com/article/3223136/data-center-cloud/google-drive-is-being-replaced-by-backup-and-sync-what-to-expect.html