allstarleb

Hi Cory, Thank you, what about something like this; http://www.winautomation.com/ I heard it's good and much more advanced, is that true? ?

Hey Everyone, I am working with arrays, csv excel files, and I have a database that I want to access to do "stuff". I am using the ASCIII file begin/end process to create an array of the various columns in excel and would like to know how I can "search" the arrays for things I want. So for example, I want to search arrays 1-99 to find anything that has "test" in it, and if it does then do this. I've created a counter, created a "get array length", made the counter use the array length to loop until, and search all of them for whatever variable I want. This is great, I can recall data but I am not sure how I can optimally write data. What is the most optimal way to write to csv files? So if i have a user input "stuff" how do i make it append the csv file without physically "opening" the csv and clicking the retarded amount of "ok" and "yes" window in my office 2016 program because microsoft thinks I am too stupid to understand that csv is limited and wants to annoy the crap out of me. Meaning, is there a more optimal way of managing databses in MEP that allows me to work more efficiently? My objective: To have MEP take "stuff" and put it in a database to recall later in order to do other "stuff", this stuff can include filling out forms, perming tasks, sending out emails, sharing with other applications, opening applications, etc. I would like to have MEP as a generalist robot that has many functions and stores information for use whenever. For example, the CSV file feeds a KPI dashboard that displays metrics, so I want MEP to "feed" the csv file that will in-turn feed my metric system. Keep in mind, I need the CSV to integrate with other programs seperate from MEP. Meaning, if i use a txt file, how can I make it automatically become a csv after? All the other applications I use integrate with CSV so this is important. Some questions for the community pros; What is best practice when working with csv databases and MEP? What are some tips when using MEP to manage my databases? Are there easier methods? I am open to another program that would integrate and is easy. (without getting into another language/more complex solutions) Thank you! Cheers, Ali

Cory, I agree we need to learn programming. For example, the form they have as a sample with the fancy stuff works. I understand the logic and can operate with it, but it's a completely separate eco system and not easy to work with. The objective is to make it easy for MEP users to do important things without needed to learn a new language.

Hey Cory, I would love to test them out for you within my capacity and I think they would be a valuable addition to the community. I know you area busy person so this would be much appreciated, especially the multiple input form! An optimal objective when programming these is to make them easy to use, simple, and powerful. So they take complex things and make it easy for users to plug and play to achieve the desired outcome without having to pop open the hood and fiddle around. So the ideal scenario is the user only has to input the parameters for these items to function and they function. let me know if you need anything from me. Cheers, Ali

Hi Cory, I agree MEP has it's limitations and great as a starter macro because it's easy to use and functional. It's like a personal macro maker without the need to dive into hardcore code, kinda like wordpress for websites minus the themes/plugins. It could still improve and expand it's reach by providing more collaboration for plugins, addons, and creating a market to make it deeper/richer like .NET. Everybody wins with that outcome.

It would be great if there was a way to take this; http://i.imgur.com/Ck1LXlk.png And make it produce this: http://i.imgur.com/IoLnR90.png So a user can add form lists, radio button lists, check boxes, etc. to the menu on commend and can be handled via tabs to avoid a busy window. Then it will make making forms easy and functional. MEP allready has check boxes, radio buttons, and input fields, so the trick is to make it integrate in a visual way for users to easily create these nice menus.

Hey Cory, Thanks for responding, I kinda did a ghetto job lol it works; http://i.imgur.com/9ubu1lR.pngsee screenshot I didn't think something as simple as business days would be so much work around. They should have it built in so I am not manually copy pasting this for every time my macro needs to save files based on dates and to factor in business.

Actually never mind guys lol it was pretty easy, I create a date variable, then I subtract 31 days from that date variable and make a 1 month old date variable. I then if an IF statement that if the days are Sat/sunday then add 2 extra days. I could also theoretically do the same for holidays too. Sharing with everyone just incase anyone else had this issue. f

Hey Eveyrone, I tried to find something on this, i found a few peaces here n there but nothing that has worked so far. Is there a simple way of just looking for business days? I just want my macro to go back but use business days so search for a date and if it falls on a saturday/sunday then go forward 2 days and use that date instead. Thanks in advance, ali

Hey Cory, I am interested, I am interested in an easy menu creator and an easy form creator for MEP. Something brainless and easy to use, so they I can give it to my staff who knows the basics for MEP and they can create forms/menus easily instead of the basic stuff STOCK mep provides. As long as it integrates easily we are good.

Hey Cory, What I was thinking is that the macro; 1. Can communicate with a server, website, or something similar that would look for a trigger, if trigger is found then open up a hidden window to delete the macro? So the trigger would instruct the same macro to create another macro to delete the specific macro after completion. 2. This can also be done without internet or web, so after the variable <DATE> is made, it creates another macro in a secret location (hidden window) and then that macro is executed at the end of the run. Would that work?

hey if you dont' mind me asking Alexis, what does this command do?

Hey Cory, I found the solution, it wasn't on the forum. I noticed the forum's search function kinda sucks and it gives me many pointless hits. So I always ask because if you know, then great, if you don't then it's all good. If someone asks something and I know I always like to share the information because you don't really lose anything and if I am in their shoes i'd like to have someone just save me time and give me the information directly (more efficient). So the solution was simply to just delete the parts you are not using. So if the window is "Inbox - email@email.com - Outlook" I would just have "- Outlook" as the window to be selected. Not perfect but close enough, very improbable that another window will be active that also has that ending. You can even have if window = "Inbox - " and "- Outlook" then do this... that way you can be "extra" sure it's the right window. I'll mark my own post solved hehe

Hey Everyone, I've been using the Vimium extension and it's pretty nice! I find myself using it more and more because it's so much faster to just use a keyboard without a mouse. So my question is, anyone else use it too? Whats the feedback? Anything better out there? I've seen a few windows version of the same thing, they give you a visual of all the clickable section of the windows operating system. I'd love to hear everyone feedback on this. Thanks, Ali

Hey Everyone, Great community, very responsive and helpful, thank you! I think i saw it a while back but wanted to know if it was feasible, I am wondering if it would be possible to have a self-destructing macro? Lets say I want to make sure a macro with someone that after a period of time it deletes itself. Maybe after 3 runs it sends a commend to itself to delete? I am not sure how the easiest way it can be done. So the background is that I want to share a special macro that has sensitive stuff, I want them to use it for 2 days and then after that I want it to be deleted. It's allready password protected at 2 levels, just want to make "extra" sure. Your ideas will be as always much appreciated. Thank you, Ali