cyberchief

I figured it out.. guess I just had to be a bit more creative. thanks!

Cory, There are no CR/LF's... The site here doesn't reflect what I actually see on a notepad... In a notepad... that second quote information I provided in my post is all on 1 line. I will look at the other thread. the problem I have is that I can't find any constants... sometimes there is 82 characters in a line.. sometimes not. Sometimes the line has a "..." in it... sometimes not (when the company name or company address is too long). Just too many circumstances to get my little mind around. uhg.

Here is what I am trying to do. Filling out a form on a webpage... I have to choose a company name with address. I have the name and address in variable T5 and T6. When I get to a webpage, there is a drop down menu where I have to choose that specific company and address. It appears like this: I have macro express copy the page to get this detail... and the clipboard reads it like this: As you can see in the first quote... not every line has the exact same amount of characters.. though almost all of them are 82 characters in length... just not ALL of them. In a list of 100, there are about 5 that are not. Also, not every company or address always has a ... after it. They will not have a ... after it if the company name or address gets towards the end of the 41 character limit per name and per address. I need macro to look at the second file and decide how many times the cursor should arrow down when it gets to that drop down menu. Each arrow down will select a company name and address as in the first quote above. I just can't figure out how to get the second quote box logically broken up to do the search when note every line is 82 characters and not every line has a ... in it. Any ideas?

Pat, putting in my code will not work by itself... I am assuming that this is only a portion of your coding. You need to set the %T1% variable (file name) prior to running the script I provided. if you can post the entire code of your macro, I can look further to see what is missing.

Try this... This will process each folder, and break out every word in the folder name and try and match it to any word in the file name. Caution... if you have common words like "And" or "Or" or "The"... it will process these as if they said "Excel". So you want to be careful with the naming convention of your folders. If File Ready "%T1%*.pdf" Repeat with Folder Variable Modify String: Copy %T2% to %T3% Replace " " with ";" in %T3% Variable Modify String: Append ";" to %T3% Repeat Until %T3% Does not contain ";" Variable Set Integer %N1% from Position of Text in Variable %T3% Variable Modify String: Copy Part of %T3% to %T4% Variable Modify String: Delete Part of %T3% Replace ";" with "" in %T4% If Variable %T1% contains variable %T4% Move File or Files: "%T1%*.pdf" Break End If Repeat End Repeat End End If <IFOTH:19:2:C:\My Cabinets\Mortgage Files\Loans IN Processing\4. Loans In Processing\%T1%*.pdf><REP3:07:000006:000001:0002:0:01:C:\My Cabinets\Mortgage Files\Loans IN Processing\4. Loans In Processing><TMVAR2:09:03:02:000:000:><TMVAR2:21:03:01:000:000: ;><TMVAR2:07:03:00:000:000:;><REP3:08:000008:000001:0003:0:01:;><IVAR2:01:13:3:;><TMVAR2:10:04:03:001:N01:><TMVAR2:11:03:00:001:N01:><TMVAR2:21:04:01:000:000:;><IFVAR2:4:01:7:T4><DOFILE:07:NN:C:\My Cabinets\Mortgage Files\Loans IN Processing\4. Loans In Processing\%T1%*.pdf>C:\My Cabinets\Mortgage Files\Loans IN Processing\4. Loans In Processing\%T2%\%T1%*.pdf><BREAK><ENDIF><ENDREP><ENDREP><ENDIF>

If the folder has multiple words in the name... it will not match "any" of those words of the folder to the name of the file. This will match the entire Folder name to ANY word in the file. So, in your example, your folder had a title of "Excel". If your file is "Excel Tips" or "Excel Functions" or "Excel blah blah"... it will move it. Again, that is if the folder itself is 1 word... If the folder is 2 words, say "Excel Documents"... then the file must contain the words "Excel Documents" somewhere in the name.

Pat, The coding you provided does not do anything within the repeat folder. Try the following code. What this will do is activate if your file (T1) is ready... Once it is, it will repeat getting the "Full name" (T2) of each folder in that directory. Once your file contains the same name as the folder (T2 is found in T1... hence folder is named "Excel" and "Excel" is found in the file name), it will move the file to that folder. If not, it will repeat again until it either finds the folder, or runs out of them. If File Ready "%T1%*.pdf" Repeat with Folder If Variable %T2% contains variable %T1% Move File or Files: "%T1%*.pdf" Break End If Repeat End End If <IFOTH:19:2:C:\My Cabinets\Mortgage Files\Loans IN Processing\4. Loans In Processing\%T1%*.pdf><REP3:07:000006:000001:0002:0:01:C:\My Cabinets\Mortgage Files\Loans IN Processing\4. Loans In Processing><IFVAR2:4:01:7:T2><DOFILE:07:NN:C:\My Cabinets\Mortgage Files\Loans IN Processing\4. Loans In Processing\%T1%*.pdf>C:\My Cabinets\Mortgage Files\Loans IN Processing\4. Loans In Processing\%T2%\%T1%*.pdf><BREAK><ENDIF><ENDREP><ENDIF>

Simple answer is no. I believe windows interprets holding the arrow key down as multiple keystrokes.

Yes, I assume that this is being done in a repeat loop. If it is not, then I cannot think of a way to do this. If it is, and you are wanting to increase the number each loop... here is an example: Variable Set String %T1% "Setake" Variable Set Integer %N1% to 0 Repeat Start (Repeat 10 times) Text Type: %T1% Variable Set String %T1% "Setake" Variable Modify Integer: %N1% = %N1% + 1 Variable Modify String: Append "%N1%" to %T1% Repeat End

I have a solution that I think is a little easier and more secure... Create 1 macro named "Password"... Select "no activation" for this macro. You can also password protect this macro. In the macro, set one command for your password as your variable string: Variable Set String %T1% "Password" In all of your subsequent macros that need this information, use the Macro Run Command: Macro Run: Password Now, when you need to change your password, you only need do this in your macro named "Password".

Variable Set String %T1% from Prompt

Do you have any other scheduled macros? Maybe something that runs around that 7th or 8th hour?

As always, Joe, you are too helpful! Thanks alot!!!

Not really.. my idea didn't work... I was thinking using the text file process... but my information is not in a text file... it is in a variable. Ok, open to ideas again.

Got it figured out... nevermind

I am sure there is a way to do this... maybe Joe or Kevin or Jason can chime in here (or anyone else for that matter)... I need to replace all CR/LF with, say, an * rather than removing them outright. I want all CR/LF removed... but I need something there as a marker to show me there was a CR/LF there. Any ideas?

When you set %T1% to equal "Man"... then set %T1% to equal "Women"... T1 will now only equal "Women". Not quite sure what you are trying to do here... Try this: Macro A Multiple Choice Menu: Choose Variable Modify String: Save %T1% to Environment Variable (type) Macro Run: Macro B Macro B Variable Set String %T1% from Environment Variable (type) If Variable %T1% = "Man" Text box display: Correct Else If Variable %T1% = "Women" Text box display: Wrong End If End If

Joe, That worked perfectly!!! Thanks a ton! Starting to understand these processes a little better...

I am not very versed in the text file processing abilities... so here goes a question. I need Macro to look into a specific folder for a file. We will be having an on-line site generating text file submissions to this folder. The File name will change with every submission... I want macro to look into the folder and find the earliest file created date and process that text file. In the coding, I will have macro copy that file to another folder and rename... so there will be no worries about duplicating that project. But how do I find the earliest created text file and have macro recognize that one to run the text file process? Thanks!

Yes you can add remarks in the coding... When coding, go under "Macro Control". The option is "Remark". To protect your macro, you can password protect it. Right click on your macro, go to "Security", and choose the setting that fits you best.

Welcome sjayzzang, I believe Windows interprets holding down the space key as repeated keystrokes, so I do not know how you would prevent the repeated strokes from being sent to windows using any type of "Space Key Down". As far as I know, this is not possible. Keys such as "Shift" and "Alt" are meant to be held down to use other functions. There are ways to pause macros using a "Pause" key. Go to "Options" on the tool bar, go to "Preferences", go to "Playback" and you can set a certain key to "Pause" the macro. I do not believe there is any way to run another macro while another is running or in "Pause" mode. I believe that a future version of ME will come with the compatibility of running macros at the same time, but I do not know if that will be compatible with pausing a macro (pressing the pause key, how would ME know which macro to pause?). Have you thought about putting in a "Macro Run" command where you want a second macro to run? If this needs to happen in a specific part of the coding, you can run a second macro in the middle of your main macro and that will wait until the second macro is completed running before going on with the rest of the coding. See the "Macro Run" command.

Macro Express will not mouse move directly to text. If you are wanting to cilck on some specific text...then I would think that the text box that the text is contained in may have a control to it that you can capture... and you can move the mouse to that control. If the text is a specific color (different than other text), you can use the get pixel in a loop to find and click. Otherwise, if the text always appears in the same place, you can get the position and always have the mouse to move there.

Speaking of which... I don't know if this is in the works... but I would like to see an enhancement that would change controls to be like window titles... where you can use partial titles (for controls) rather than exactly what they reflect now. Using set control text (may use partial titles) and wait for control... This would help tremendously. I see you can modfiy the top-level window... but as discussed below, what I am currently working with is windows within windows... and "Capture Control" captures the very top level window. On the topic below... Trying things out now... I can get control using "specific coordinates"... but not "Control Focused".

Kevin, I think I know what Greg is talking about... I have the same issue with one of the programs I use. This program opens a window with windows within it. Those windows do not appear on the "activate window" either. There are controls to them... but considering they can open up anywhere within that main window, the "get control" or "capture control" does not work. I have been trying to work with this for a while. These "sub" windows cannot be activated directly. Nor can they be resized. Find Window does not work. I am left with just using mouse movements to try and make it work. My main problem is timing... when pulling information, the sub widows can take anywhere from 30 seconds to 5 minutes to come up. And trying to get the macro to wait for that window when ME cannot recognize it results in problems...

Can you post the actual macro commands (not the text... but the actual macro)? I would like to see the actual commands. Also, what was your work-around?