Jump to content
Macro Express Forums


  • Posts

  • Joined

  • Last visited

Everything posted by NeVeR

  1. I have a windows VPS running ME3 - I have a macro designed to run once per day. At the moment it's not working.. If I trigger the macro and watch it it works, but if I close my connection to the VPS it doesn't work. Even though the VPS is still working/running. When i launch the remote connection to it again I can see Macro express still sitting there exactly how I left it. I even tested this with a repeat and delay. I set up a repeat and a 200 second delay - I ran the 1st time i triggered it as I was watching it.. but when I closed the connection and waited for the results nothing happened .. I opened remote connect to VPS again and the same thing.. The macro said it was still running ( black man icon in tray ) .. but didn't trigger and didn't work. I can check the if the macro worked by checking a shared Google Sheets page - if it worked there will be some data visible. So i don't have to launch the remote desktop to see if it works. So is there a reason why it's not working on VPS ?
  2. I've many large files over 20000 lines each In each file there is about 5000 names i need to copy out - names could be different lengths etc. All the names start with @ So I could tell ME3 to look for that - but I don't know how to tell it to only copy the name and then repeat.
  3. cool thanks guys.. didn't know there was a print screen command.. i even looked for it !! thanks i'll start building.
  4. At the title says, can you take screen shots and save them ? Trying to build a QA type of macro for webpages.
  5. ah i see. I didn't know that. Thanks I'll give that a go.
  6. I've moved away from this idea. I had 2 more vaiables being set in the URL which where not working I had 2 prompts at the start to enter start and end dates T1 and T2 then it would go to a spreadsheet and copy the main URL something like http://mainurl.com/date=%T1%-%T2% and anytime it pasted this into the browser is would just paste T1 and T2 and not the actual dates. In the end I just set Excel to change the dates based on a cell value and copied the whole URL into the browser and that worked.
  7. I'm trying to store a URL in %T15% for example and use "Web Site: %T15% [Default Browser] to launch that URL. but it's not working. Is this possible ?
  8. How do I know what to trim if I can't see it ?
  9. I have a macro that collects data from google analytics. There are about 10 different bits of data and I wanted to open a spread sheet at the end and paste is all. Which it does do.. However the data is not all in a line. the macro must copy space / line breaks etc from Google analytics that I can't see. So what I want is my data to be %T1%<tab>%T2%<tab>%T3%<tab> etc and when excel opens and it's typed out it's all in a line side by site. what is happening is it appears on many times so T1 will be 1st then t2 will be on the second line and t3 beside it.. then t456 will be on the next line etc. Is there a way to remove all line breaks / hidden spaces before it gets to the text type part ?
  10. cool.. didn't know excel had this.. this will work. thanks.
  11. I'm building a macro to gather data for a report and place it into a template in excel. Getting the data is fine, but is it possible to have the macro find a cell in excel to paste bits of copied data ? I know how to get it to open excel etc and I could probably find the right location by building the macro to tab / arrow into certain cells in excel.. but if it could find sell C4 with ease then it would be a quicker / easier time for me. Any tips welcomed thanks.
  12. I figured it out.. it's just AC or ACD no space and using the = condition.
  13. I'm building a macro where you have a multiple choice at the start. You can select A B C D E and based on what you pick you get different text option copied into notepad. People can select 1 letter if they want. but most people will be selecting many i.e. A and C or A and C and D etc. I'e set up the "If" variable to control what is disabled based on the pick. So if A is select show this. But what i can't figure out is if someone select A and C how do i tell the macro to show something based on that. I've attached a screen shot. in the Value area what do I put in there if people select more then 1 option ? I've tried A C A,C A+C A and C nothing is working so far. Any help would be great. Thanks.
  14. Can ME 3 select an pixel color ? Or can is find a pixel color and then I could issue a mouse click command.
  15. Also if I don't need T1 and T2 thing.. So can i tell my macro to type what I want.. when i want it ? The ideal thing would be something like this. Random name made. stored in T1 and T2 - ( I use these names to test sign up on our sites ) I have the macro programed to follow a set of steps.. and one of those steps is entering a username -- ( should is what the randomer makes )- -- and then at the end it would store these data in an excel sheet and then clear clipboard and start over.. and repeat. So I think i need it to store into in T1 and T2
  16. not sure how that is done. I normally use ME3.. but the job just got my Pro.. and i'm still learning it.
  17. I'm testing out something new and wanted to make random names. I have a list of 200 1st names and 200 surnames. I would want ME to randomly select a 1st name and sure name and store them in T1 and T2 -- and when repeated it would do the same but select 2 different ( random ) names from the list. There will be others parts to the macro.. but i can do them.
  18. I'm testing out something new and wanted to make random names. I have a list of 200 1st names and 200 surnames. I would want ME to randomly select a 1st name and sure name and store them in T1 and T2 -- and when repeated it would do the same but select 2 different ( random ) names from the list.
  19. i downloaded it and it doesn't make any sense to me.
  20. Here is an example of the what i mean Macro starts and asked for project name ( I can do this part ) Marco prompts for Project start date and stores in T1 ( and anything ) --- Macro logic will run and return the following in text type. Project Name ( from prompt ) Copy & SEO Details complete ( this will be the date i selected from the prompt ) : Ready for Review: + 1 day from selected date Review complete: +2 days from selected date Send to translation +3 days from selected date translation complete:+8 days from selected date Graphics complete: etc Load translation /Graphics to CMS: etc translation Review complete:etc QA Complete: etc The macro needs to know weekends don't count as working days.
  21. Hi, This says "What it does: This sample macro shows how to change a date from MM-DD-YY to DD-MMM-YYYY format using the 'Run Macro in Variable' command." Thats not what i'm asking for. I need to be able to set dates into the future from a given start date. So lets say today it's the 1st of the month. I run this macro and i'm promoted to select the start date of my project. Lets say the start date of my project is 15th. This Macro will then know that the 15th is the 1st day.. and will know the 2nd day is the 16th / 3rd day the 17th etc.. I need it to set these new days into %T% tags so I can use the dates in a text type script.
  22. Also i can't just do " Adjust date +1 to the future " as I might be running this macro on the 1st of the month for a project that wouldn't start until the 15th ( for example ) so the + 1/2/3/4 etc days would need to run from the date I set when prompted.
  23. I'm making a macro for a planing system we use in work. When we get an project on .. lets say Monday 1st - We know what the next 8 steps of that project is .. as it's the same every time.. We keep all this data in a wiki.. and each time we have to type it out by hand. What i want is to make a macro that will do the hard work. I have the macro promote me for the data i need to start.. Like Project number is stored in T1 and persons name in T2.. then i promote for the date and add it to T3. This is where i'm stuck. If i set Monday 1st as my date I need the macro to be able to know what dates the other steps should be done. So example 1: Project start - Monday 1st Oct 2: Project sent to review - Tuesday 2nd Oct 3: Review complete Send to be built - Wednesday 3rd Oct etc.. idealy I want to be able to store the dates in T tags so i could use the text type tool to pre-write what i wanted. and add the dates. This should work off a normal calender. So if i set my start date to 30th of Oct if would know to do the macro into Nov. So in brief.. I want to be able to add plus one or plus two days etc to my start date.. and have them store in T tags. Can this be done ? thanks.
  24. thanks lads.. the shift+tab worked perfectly
  • Create New...