nhatto

That did the trick! thanks!

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

Variable Set String set %File Contents% to the contents of c:\somefile.txt
Variable Set String %Clipboard% from the clipboard contents
Variable Modify String: Replace "#^3" in %File Contents% with "%Clipboard%"
Variable Modify String: Save %File Contents% to "c:\somefile.txt"

However the more I think on it I believe you might be going about this all wrong depending on what exactly you are trying to do. If you tell me in general what the task at hand is I might be able to point you in a better direction. One you haven’t thought of yet.

Variable Modify String: Replace "#^3" in %File Contents% with "%Clipboard%

that sounds exactly what i was looking for !

thanks!

any ideas?

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

take the attached macro file and see if this works for you.

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?

[*]To open the find box use the Text Type command and type CTRL+F. Wait for the window, type the search string and text type Enter.

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?

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

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!

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.