Jump to content
Macro Express Forums

nhatto

Members
  • Posts

    10
  • Joined

  • Last visited

Everything posted by nhatto

  1. I would like to setup a macro, that when i run it. it will paste the saved string in one of the variables. so for example.. when i am at a website. and i am filling out a form, i would like to be able to run the marco and the macro will insert my address where-ever my cursor is at. without having to have to open a notepad , copy the text, then paste it where i want. how can i do that in macro pro? thanks
  2. Variable Modify String: Replace "#^3" in %File Contents% with "%Clipboard% that sounds exactly what i was looking for ! thanks!
  3. Hello I'm Trying to create a macro to replace certain predefined text with entries in an excel file for example: I have 10 predefined symbols located in various places in a text file: 1. #^3 2. %f2 3. @4 4. %8 ...etc I would like to add those as fixed variables in the macro but i dont know how? the macro will simply locate the symbol in a text file, and replace it with an entry that I copied from excel macro will be : - go to excel and copy the first entry - go to text file - locate predefined symbol "#^3" in text file - paste the excel entry in the place of the predefined text - go back to excel and move to second row - repeat process with second predefined symbol never used variables before and i read the tutorials but wasnt able to figure out how to work with them, i would appreciate any advice thanks
  4. thanks for the Macro Cory, Everytime i ran it I got the blue Screen of death! :S (maybe it's my computer) I created a macro that does take 6 seconds for each search. (which is not very practical for me) let me re-summarize the problem I have two CSV files File 1: one file has 10 column (one of them is the email column) - size is 1.5 million rows File 2: the other has 1 column ( one column = email column) - size is 5 million rows I am comparing the "email" columns against each other. If an email in File 1 is found in File 2, then delete the whole row in File 1 If not, then go down one row and repeat. ---- is there anyway to do these without having to open the files? or the files have to be open for the macros to work?
  5. when i do this: it only actually types CTRL+F in the cell when i try <CONTROL><F> : it doesnt do anything what am i doing wrong?
  6. Thanks Cory for your response, but Each excel file (or should i say CSV file) contains around 200,000 to 1,000,000 rows. I dont think excel program will allow me to create two sheets each one with that many rows, thats why i thought only a macro will do this job. quick question: do you know how to create a keystroke : CTRL + F ? is it <ctrl><f> ?
  7. I trying to create a macro that will compare two columns in two different excel sheets. If an entry from excel file 1 is found in excel file 2, then delete the whole row in excel file 1 this is what I am doing: copy the cell from excel file 1 into the clip board activate excel file 2 CTRL+F (to open the search box) <---------------------------- how do you do that in MEP?? paste from clipboard and search excel file 2 if loop: ===== if there is a match <-----------------------------------------------how do i do that in MEP??? activate excel file 1 delete row ELSE if there search result returns nothing, then <----------------------how can i make MEP see that?? close search box activate excel file 1 go down one row and copy the cell from excel file 1 Repeat until reach end of rows in excel file 1 <--------------------------how can i do that in MEP? I would appreciate any help in any of the steps please or if you recommend it I do it differently? thanks!
  8. I am working on a macro to choose from a drop down menu in a form in firefox based on an MS Excel cell entry? For example if the excel cell said "MACRO" : it will choose the drop down option "MACRO" and so on.. can someone point me to the right function I should be using for this? Thanks! N.
×
×
  • Create New...