MacroUser1

I am looking to only allow my macro to run for 5 minutes. Occasionally the webpage it is visiting will time out and I just want the macro to close out after 5 minutes. Is that possible?

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)

I was able to check. The issue I run into is that the Day/time function you have to change the date does not work with Macro Express 5 and It is a feature in the pro version that I do not have 😔

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.

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)