m204prgmr

Greetings all,

It has been a long time since I've asked for help and a confession of long time no hands on work.

My dilema is as follows.

How do I merge mulitple .csv documents to form a master. And with that, how do I add to the master each time a new or updated .csv comes in?

I will be receiving spread sheets from folks who have been asked to look at Column B (Street Names) and add in a name, address, phone number (Columns D,E,F) of someone that they know who lives on that street. There are 207 rows of street names. Soon, spread sheets will be coming in and I will need create a master sheet.

Thanks so much

Robert

I've copied a file containing 41 Macros from hospital GH to hospital BH. All of the Nicknames start with GH.

Is there a mass way to change the nicknames without haveing to open and edit each one?

Thanks,

Robert

OKEY DOKE.....I changed using OR to using AND....and it worked.

Cheers and welcome to all the newbies.

Greeting and HNY to everyone.

I'm trying to use OR in my macro and to NOT print if my %T20% contains BP or OLP.

I've uploaded the necessary parts and any help would be appreciated.

Robert

Using_OR.mex

tt2lp.txt

Copy_of_TT2LP.txt

Bada Bing thanks Joe

Just as you were responding I saw that needed to be done.

Cheers from Brecksville

Robert

%N1% = 61509

%N2% = 1678676

%N3% = %N1% / %N2%

My How can I see the result as .03?

Thanks

Robert

The objective is to create as many .txt files as there are %N1% variables and to FTP them to the Mainframe.

I hope this make sense and I apologize for not stating that earlier

Thanks Kevin

I'll try your suggestion tonight.

How do I save PT2OKX0%N%.txt %N% times once done?

AnnArbor.txt has 63 lines with one word on each line. That's where %T5% is used.

It has been awhile and I'm rusty. I'm trying to save Notepad that I've opened and written to and can't seem to connect the dots. Can someone help? thanks

<BTFBEG:005:000001:000000:C:\Documents and Settings\RGHutchinson\Desktop\AnnArbornames.txt><LAUNCHDEL2:0:01C:\WINDOWS\system32\notepad.exe><IVAR2:01:02:FEnter the numberFFCenter:Center><SPKEY:0100><TEXTTYPE:<ALTD>F<ALTU>><TEXTTYPE:A><TEXTTYPE:C:\PT2OKX0%N%.txt<ENTER>><DELAY:10><DIS:<TVAR2:05:02:FEnter the outfile nameFFCenter:Center><TEXTTYPE://PT2MTX0%N1% JOB ,'PT2MT FTP'<ENTER>><TEXTTYPE://STEPNAME EXEC PGM=FTP<ENTER>><TEXTTYPE://*%OPC SCAN<ENTER>><TEXTTYPE://SYSPRINT DD SYSOUT=*<ENTER>><TEXTTYPE://OUTPUT DD SYSOUT=*<ENTER>><TEXTTYPE://INPUT DD * <ENTER>><TEXTTYPE:XXX.29.XX.64 5565<ENTER>><TEXTTYPE:FTISTSC TISTSC <ENTER>><TEXTTYPE: <ENTER>><TEXTTYPE:put 'PT2MT.OUT.%T5%' PT2MT.OUT.%T5% <ENTER>><TEXTTYPE:quit<ENTER>><TEXTTYPE://*<ENTER>><BTFEND>

Hi gang,

Situation = ME running on a server. Macro starts fine, DOS window opens but then looses focus so ME does not know what to do aborts. Any help would be appreciated. I've gone so far as to move the mouse to the title bar and click on it in the macro and use Window Restore.

Thanks,

Robert

Chris,

I am running ME on a server which is at a remote location. For ME to work for me as the Admin, I disconnect from the server instead of signing off. The problem I am having with one of my macros is using DOS. The window comes up but somehow looses focus. When i return to see why I have not been sent an email, the title bar is greyed out.

Robert

Leo,

I just tried something with Repeat and without repeat and I'm not sure you will be able to achieve what you want unless you're prepared to go in order. Each wait except for the first is dependent on the previous it appears and if you put time on the delay, you'll get a timeout message. Maybe some of the more experienced members can jump in and lend some advice. Good Luck my friend!

Robert

Leo,

Try this

<IFOTH:01:2:C:\write.txt><DOFILE:08:NN:c:\write.txt>><ENDIF><WAITKEY2:000000:000000:27><TVAR2:01:01:drum><TMVAR2:20:01:00:000:000:c:\write.txtT><WAITKEY2:000000:000000:28><TVAR2:02:01:guitar><TMVAR2:20:02:00:000:000:c:\write.txtT><WAITKEY2:000000:000000:29><TVAR2:03:01:banjo><TMVAR2:20:03:00:000:000:c:\write.txtT>

Robert

I found it. Under Debug the Use Test Window option was selected. Mussta been da boogie man that turned that on because I sure didn't...

Robert

Leo,

I use Variable modify string, then select option 2 on the tabs, then append.

<TMVAR2:20:20:00:000:000:C:\ReturnCodes\Jobs%T99%.txtT>

Leo,

Can you be a tad more specific with one or two full examples? I'm a bit confused that you want a macro to run with a keypress and not have a menu? Will the end user know what each keypress represents? If so, set up the macro using if keypress. If they don't press it, nothing happens. Otherwise, you may have to either wait indefinetly or use a timer?

Robert

I have a window named Macro Express Test Window that is opening and I did not code one to open.....hmmmm. Any ideas?

thanks

Leo,

Sounds like a Wait for Text option under Timing?

Hope this helps

Jason,

Thanks

I just got off the phone with my network guy and our discussion was as I expected re: disconnecting. It ties up a connection.

Is or can ME be setup to run as a windows service and still work?

thanks

Situation solved.

I found out that if I signin and then 'Disconnect' instead of logoff, the session remains open and ME works just fine. The twist is that I need to re-connect from the same machine. The server remembers where I disconnected from. What will be interesting to see is if I disconnect from within the network, go home and VPN in and can reconnect.

Stay tuned

Good Evening,

How do I config ME to run on a server? We've installed it and I have 1 macro setup to email me if it finds a .txt file sent from the mainframe. Trouble is it doesn't do anything unless someone logs in. The .txt file is there.

Thanks

DUH!!!!!!

Thanks Joe

Greetings,

I seem to be having a problem with my Save As window and Import Text File window not always being in the exact spot I need them to be in for ME to work with mouse movements and clicks. Does anyone have a sure fire way of positioning these windows before the mouse starts moving? Thanks

Thanks Joe,

Can you explain how I am getting duplicat lines?