nhatto
-
Posts
10 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Posts posted by nhatto
-
-
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.
Save predefined string in variable
in Macro Express and Macro Express Pro
Posted
That did the trick! thanks!