m204prgmr

Thanks Joe, I had a situation on Saturday where my Macro aborted because a web page did not load, the system lost connectivity. It made me go back and look at the code and determine I did not need a Internet page to load but rather a Intranet page. I was loading an Internet to load the Intranet....DOH! Robert

Randall, You amaze me...this looks pretty slick, thank you. My format on an HTML page that I am copying is 2/7/2005 8:41:40 AM for the start time and 2/7/2005 8:44:53 AM for the ending time. I assume I should modify MY format to fit your format and formula of yyyymmddhhmmsszzz? My information is from a SQL Server. I ran a script and created a View in SQL then through Access I was able to create an HTML page showing me some basic information. SQL is not a strong point of mine..... Robert..

Thanks Kevin, I'll see what I can try and let you know. R

Greetings, I gain access to another PC through LanDesk via MacroExpress. The macro used is a simple Window Title and a text input of <TAB><ENTER>. This works great when ME is not running a script. My problem is how do I tell ME that when my access request window is visiable but not active to make it active? I'm also concerned that what ever would make it active and do the 2 functions it might disrupt the current running macro. My only thought is to have this IF statement wrapped around the entire job and when it needs to do its thing, pause whatever is currently running. Does this make sense? If I cannot do this, can I send a stop command that would be placed in a shared folder on the machine? Bottom line is I need access to this machine if something goes wrong and cannot gain access to the desktop with ME running. Thanks. Robert.....

Wow... Have you tried Files/Folders - If File Ready / If File Not Ready. These commands test to see if the file you specify is or is not ready to accept input. It tests to see if the file is still busy or not. Robert hope this helps just a little

Randall, My apologies for not getting back to you sooner. Thank you. Your suggestions are working. What would I need to do to do a time difference and if necessary, do a date and time difference? I'd like to calculate the minutes before putting this into Excel. Unless someone knows a trick. I've tried appending comma delimitted to Excel from ME where there is a formula in place in Excel. The append jumps to the next free line instead of the next line in succession. Robert

Bon, What OS are you using? Robert

Gerry, Have you tried Start/Run and then type in the server name, //servername/share Also, if you have Remote Connection turned on you can get to the server that way. It's a one box input html page that you enter the server name in and press enter. The next screen will be the sever logon where you'll enter your username and pswd. Hope this helped. Robert

Freebie!..I like Freebie's...Just like on Monster Garage. Jessie says...Just Do It! Jow, Thanks for the tip. I too like to see what was monkey'd with, in a curious sense. Robert

Sounds like the same problem/opportunity I encountered with a local HTML on my desk top. Use Internet/Web Site and paste in your address. It loads everytime. Robert hope this helped

Real simple and it seems almost too good to be true. Is the following analysis correct? Is ME looking at both Date and Time in each varialbe? I have two examples. One ending date that is the current date and one ending date that is the next day. <TVAR2:01:01:1/23/2005 7:52:40 AM><TVAR2:02:01:1/22/2005 7:48:07 PM><IFVAR2:4:01:4:T2><TBOX4:T:1:CenterCenter000278000200:000:Tell me that the ending date is greater than the starting date><ENDIF><TVAR2:01:01:1/22/2005 7:52:40 PM><TVAR2:02:01:1/22/2005 7:48:07 PM><IFVAR2:4:01:4:T2><TBOX4:T:1:CenterCenter000278000200:000:Tell me that the ending date is greater than the starting date><ENDIF> Paul, Regarding your reply (Jan 10 2005, 06:12 PM ) to my SQL post, I created a view on the server then through Access created a Data Access Page and mess with OSQL. This is so much faster for me by not having to go to the server with ME. The HTML page resides on the PC with everything else. I did enjoy learning a little about OSQL, thanks. Regards Robert

Now that's what I'm talkin bout!....HAAAAHAAAAA

Did I hear someone say there was going to be one in the Fall 2005?..<hint> I'd be willing to help/and/or get this going. Robert

Randall, Slick...that's what I could not think of...duh me. We're adopting a constant file name and appending to it and I have a new scenerio. Columns A and B are start and end date for the import. Keep in mind end date can be the next day. Columns C and D are the times in this format, 12:35:22.690. I'm not worried about the format but am on how Excel is handleing the append, or is it ME. Column J is the elapsed time calculated D3-C3+IF(D3>C3,1). A simple way too is just D3-C3 but this does not take into account ending on the next day as the other does. The problem is having the formula in place before the data gets there. It appends to the next free line and not to the line directly below one that is already populated (because I have a formula in place). What I have not done so far is tried to calc here in ME prior to appending, searched Excel for an auto calc on load. I have Pupv5(Excel) addon that may be able to help too. This tool is pretty nifty. Any thoughts ...always appreciated Regards, Robert

Hi everyone, Here's what I'm starting with, a file creation. <LAUNCHDEL2:0:01C:\WINNT\system32\notepad.exe><TEXTTYPE:<ALTD>fa<ALTU>><TEXTTYPE:C:\AutoImports\><DT:MMMM dd yyyy(hh-mmAMPM)F:00:1:><TEXTTYPE:<END>><TEXTTYPE:.csv<SHIFTD><HOME><SHIFTU><CONTROL>c><CLIPC><TVAR2:80:03:><DIS:<TEXTTYPE:<ENTER>><TBOX4:T:1:CenterCenter000278000200:000:%T80%> It's a csv file that has a title of the current date and time and the file will be used later in the run. Specifically about 3 MacroRun calls later. I want to append text to it. If I'm setting up my code now for the append and don't know the name, what do I do? Thanks Does this make any sense? Robert

Nevermind...I got it...phew I added a trailing CR to my last value on the first line then added an <ENTER> robert

I'm trying to build a file. Four lines comma delimited from 1 line. My incoming line is T1,T2,T3,T4,T5,T6,T7,T8 I'm looking for the final to be T2,T3,T7,T8 T2,T4,T7,T8 T2,T5,T7,T8 T2,T6,T7,T8 I built the first as such. <TMVAR2:20:02:00:000:000:C:\Import4.txtF><TMVAR2:20:03:00:000:000:C:\Import4.txtF><TMVAR2:20:07:00:000:000:C:\Import4.txtF><TMVAR2:20:08:00:000:000:C:\Import4.txtF> Is there a carriage return or something I need to insert before I duplicate the above and change T values? Thanks Robert

Joe, everyone, Is there a way to change the Prompt window and Font size a user sees when prompted for input (SET TEXT STRING VARIABLE - PROMPT FOR VALUE)? I've looked all over and maybe missed it? thanks Robert don't mean to be a P-n-A but it's been awhile since I've used ME (my bad)

Thanks so much! I exported it earlier as a playable.

Sorry, I need to clarify "button". I meant a link. Thanks Robert

Can I create a button for my desktop to run a specific macro? Can that button be shared with another user for use on their machine and have the properties of the button point back to my machine? I would like to create a macro for a user that asks for inputs, saves the text document and then FTP's the document into the mainframe. Thanks, Robert

Hi Joe, When I print T1 it is empty.

I'm running a macro that has an ASCII process which acquires T10-T15. In the middle of this macro another macro is called to run and in that macro I am saving T1. When this is all done, I'm emailing information using all variables, (T1, T10-T15). My problem is that I am not returning T1 in my text. T1 is a Set Text String Variable and obviously wrong choice. Suggestions? Thanks Robert

Thanks Paul, I just learned about OSQL which I'll most likely use. This allows me to stay away from setting up Jobs and DTS or Stored Procedures to get the info I need. I'll simply set up a macro to pull my one line of info from the .txt. Robert

Thanks Joe, That's what I thought. Robert