Jump to content
Macro Express Forums

MacroUser1

Members
  • Posts

    5
  • Joined

  • Last visited

Posts posted by MacroUser1

  1. Hello,

     

    I have two dates in am looking to change in a URL. Id like the macro to change the dates dynamically so that when it loads website it adjusts the first date to two days ago and adjusts the second date to 4 days ago in the mm/dd/yyyy format.  I would like it to always base this off of the current date. No user Input is needed. 

     

    How can I use the variables in Macro Express to accomplish this? I do not have the Pro Version.

     

    An example of the URL www.example.com/12341/2fjj/StartDate=12/25/2023&EndDate=12/23/2023/(Remainder of URL)


  2. Thank you all for the replies!  The date, I am looking to have go X amount of days backwards is going backwards from whatever the day is that the link is clicked on. 

     

    So to answer Cory’s question, it would be offset from today. 

     

    Reberq, I was using a dynamically updating link in googlesheets, but I want to reduce the amount of steps as possible as I was relying on mouse clicks to pull this off. This was just linking to a cell that was concating the date into the URL. So I am looking to use some sort of variable. 

     

    Ancator, thank you for the code! I will take a look at that further when I am back in the office. 


  3. Hello,

     

    I have two dates in am looking to change in a URL. Id like the macro to change the dates dynamically so that when it loads website it adjusts the first date to two days ago and adjusts the second date to 4 days ago in the mm/dd/yyyy format. 

     

    Is this possible in macro express? Would this use a variable? 

     

    An example of the URL www.example.com/12341/2fjj/StartDate=12/25/2023&EndDate=12/23/2023/(Remainder of URL)

×
×
  • Create New...