Jump to content
Macro Express Forums

terrypin

Members
  • Content count

    1,710
  • Joined

  • Last visited

  • Days Won

    11

terrypin last won the day on May 15

terrypin had the most liked content!

Community Reputation

2 Neutral

1 Follower

About terrypin

  • Rank
    Master

Contact Methods

  • ICQ
    0

Recent Profile Visitors

248 profile views
  1. Sub with parameters

    Another alternative is to use the command Run Macro in Variable. It's rather complex, but it would enable you to do it. Terry, East Grinstead, UK
  2. Integer seconds to yyyymmdd-hhmmss ?

    Thanks for the helpful follow-up. Now reproduced your output (happily in UK dd/mm format, presumably via Win 10 international settings). And 'Learn VB Scripting' added to my long To Do list!
  3. Integer seconds to yyyymmdd-hhmmss ?

    Thanks, VBS looks a fascinating alternative approach. It will mean using any suitable scripts I can find in "copy/paste and don't try to understand the detail" mode, painful for me. But the potential advantages outweigh that. Wish I'd thought of exploring it before I wrote my 114 liner yesterday! Did you mean to include a sample script in your post? Long time since I played with VBS and it's not immediately obvious to me how you got that date into an ME or MEP MsgBox?
  4. Integer seconds to yyyymmdd-hhmmss ?

    By 'the problem" do you mean my original objective: "...to add or subtract a time in say the text form hh:mm:ss to an existing text string yyyymmdd-hhmmss to get the resultant text string YYYYMMDD-HHMMSS"? If so I'd be very impressed to see a two line macro that does it! I'm just putting the finishing touches to mine now: 114 lines. It includes a Repeat for applying it to a set of successive filenames which include a prefix in that form and has future scope (with variables set up) for 'adding' years, months, days, hours, minutes and seconds. It edits the originals in situ, in their File Explorer folder. It uses Run Macro in Variable, as I wanted to learn how to do that with Date/Time. I'm sure a more direct approach along the lines of my first post (working in seconds with conversions from and to text) would be shorter ... but not that short! Note that I gave up on trying to use existing macros for this exercise. The PGM macros looked promising but I could get none working, and as I mentioned in that thread I now hear it's a known issue, encountered by others. And the many others I tried are either buggy or 'empty' or corrupted, with no macro displayed once the MEX is opened in MEP. So I got stuck in and wrote my own. BTW, could you use Quote in your replies please Cory, to minimise ambiguity in long threads like this.
  5. Integer seconds to yyyymmdd-hhmmss ?

    Simulation within a Firefox Private window worked fine. Reassured me that my Dropbox links will work for non-Dropbox users.
  6. Cannot run any PGM macros

    It's apparently a recognised issue. i did run Malawarebytes which found nothing of relevance.
  7. Integer seconds to yyyymmdd-hhmmss ?

    Thanks Cory. Hoping for feedback from a non-DB user now! But I'll investigate your suggestions about simulating it.
  8. Integer seconds to yyyymmdd-hhmmss ?

    Thanks Cory. As you saw in my Saturday post, that was my first suspect. But it's odd. The macro uses proper variable names, introduced in ME Pro. Can't see how it can ever have worked if zero is not allowed? I just tried changing all five [0] strings to [1]. That got to the TBD at line 161, giving an incorrect warning: "Date entered is not in correct format mm/dd/yyyy or is invalid, Macro will Terminate" for any date entry! Anyway, this tempers my enthusiasm for using this to help with the macro I described, if significant debugging is likely,
  9. Integer seconds to yyyymmdd-hhmmss ?

    Thanks Sam. My bad! I gave the wrong link. That gives the result you and Cory found. (I'll aim to test the many others I have that I think were downloaded at the same time.) The correct macro that gives the problem I described is called Date String to Date Variable and hopefully it's attached! Keen to get it working if possible. I''ll correct the original post too. -------------------- Apologies for going OT, but I'm still trying to establish what happens to my new Dropbox links in forums that I use for those who do not have Dropbox accounts. (Do you?) Anyway, here are four different links to that same valid file, and I'd much appreciate feedback on them please. #1 https://www.dropbox.com/s/2xetvq1ie0a7bau/Date String to Date Variable.mex?dl=0 Here, this opens in my browser (Firefox), tells me it cannot be previewed, and - after a couple of seconds when it's presumably checking whether I have a DB account- it offers a Download button. #2 https://www.dropbox.com/s/2xetvq1ie0a7bau/Date String to Date Variable.mex?dl=1 Here, this automatically downloads it to my Downloads folder, with no user intervention. #3 https://www.dropbox.com/s/2xetvq1ie0a7bau/Date String to Date Variable.mex?raw=1 Here, this does exactly the same as #1 #4 https://dl.dropboxusercontent.com/s/2xetvq1ie0a7bau/Date String to Date Variable.mex?dl=0 Here, this opens the content of the MEX in Firefox. If I select it, copy/paste to a text editor and save as an MEX, it runs OK. Date String to Date Variable.mex
  10. Cannot run any PGM macros

    The PGM setup creates the keys. So, you don't have the PGM library?
  11. Cannot run any PGM macros

    I'm trying to use macros from the full PGM library downloaded from the Insight page. Mainly with the objective about date/time arithmetic I described in my parallel forum post: http://pgmacros.invisionzone.com/topic/8052-integer-seconds-to-yyyymmdd-hhmmss/ But when I activate any of them and accept this request to allow registry values to be created https://www.dropbox.com/s/xdcrypvawynjhha/PGM-Setup-1.jpg?raw=1 I get the message "Line 81 ({ PGM Setup }): Debug Error: Could not access the specified registry value" I followed the instructions here to the letter as far as I know: https://www.macros.com/pgmfdownload.htm That line 81 is: Read Registry Value "HKEY_CURRENT_USER\Software\Professional Grade Macros\Folders\Home" into %T[1]% As you see (if my attachment works!), I have no folder here called 'Folders' in registry key "HKEY_CURRENT_USER\Software\Professional Grade Macros\" Are others successfully using the PGM macros under Win 10? Last June in discussion here with Sam I appeared to be doing so too. Although that may possibly have been on my XP PC.
  12. Integer seconds to yyyymmdd-hhmmss ?

    That's what I did! But as you see it displayed the link because it can't be opened directly. How about this screenshot below, which I've again attached using the normal drag method. Looks fine here. Can non-Dropbox use see it?
  13. Integer seconds to yyyymmdd-hhmmss ?

    Not sure what steps you're taking but works fine here. This is what I see. https://www.dropbox.com/s/7y1hamlarrxdlm1/CoryDownloadProblem.jpg?dl=0 Also sent to my wife in an email and she sees similar. Maybe this is a consequence of the radical Dropbox Public folder change I mentioned. Could you screenshot what you see please? Also try this third alternative and see if it appears in you downloads folder. Failing that I'll email it until I discover what's going wrong. https://dl.dropboxusercontent.com/s/3g6qzxahnfx5t00/Date_String_to_Date_Variable_and_Decimal_Time.mex?dl=1 in her different browser. Did you look in your Downloads folder?
  14. Integer seconds to yyyymmdd-hhmmss ?

    Sorry. Dropbox made drastic changes to Public folder links recently causing problems like this for tens of thousands of users. I've now edited the post and seems OK. Hopy you (or anyone) can identify the problem. I expect it will prove embarrassingly obvious! From its style, it looks like an Insight macro I've downloaded. So you may find you already have it.
  15. Integer seconds to yyyymmdd-hhmmss ?

    @Cory: Thanks for emailing me your macro Text to Serial Time which should be very useful.
×