Jump to content
Macro Express Forums

NeVeR

Members
  • Posts

    89
  • Joined

  • Last visited

Posts posted by NeVeR

  1. I've many many macros.. and sometimes I trigger one in error.. and some of them are long macros with many mouse movements/key presses etc..  so I can't get to the task bar and stop them. 

     

    I've tried many times to use the pre-built terminate macro express key presses CTRL+ALT+SHIFT+V but nothing works.. never works. ( I've tried Suspend / Resume etc .. none of them work) 


    I also made my own Win+ALT+F1 - to see if it would work.. but again.. doesn't work.. 

     

    Would the fact that the macro is running and moving fast be the issue ? 

     

    Does anything know why it wont work? 

  2. 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 ?

  3. 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.

  4. 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 ?

  5. 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.

  6. 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.

    ifv.PNG

  7. 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

  8. 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.

  9. 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.

×
×
  • Create New...