theSteve

Cory... this is so awesome. I didn't even know you could run command line processes hidden. This is a huge deal for me. hahaha. Thanks, theSteve

Oops! Sorry. I'm a little embarassed that I didn't think of that myself... Another great suggestion but I made a date comparison macro... oh well, at least it was good for practice. Thanks a lot for your help, Cory. TheSteve

I think you're right. I'm just not seeing something. Let me put this into an example. I have a macro that performs an action on a series of items, all with serial numbers. When the action is complete, a folder is named after that serial number. Inside that folder, a text file is also named after the serial number. Inside the text file, I am placing a date/time stamp. For example: Serial number 10001 folder created: 10001 file created: 10001.txt contents of file: 05/10/2010 11:20:45 AM My macro then goes through all the serial numbers and a large series of these folders/files exist. The NEXT time the macro processes the SAME serial number, 10001, another time stamp is appended, and the contents of the file 10001.txt are as follows: 05/10/2010 11:20:45 AM, 05/11/2010 11:01:20 AM My processing macro will act differently if the CURRENT date is less than 30 days later than the LAST PROCESSED date in the text file. So basically, I always want to compare my current date against the FINAL value of the text file.

Oh I've played with it a LOT. And I love it. Just seems weird it NEEDS an array. My problem was that I only want ONE value ... the LAST one. So an array is useless to me. Because in my situation, I don't know how many delimited values are in the text file. I changed my macro to use CR after the value when building the text file (instead of commas) and now use TEXT FILE PROCESS instead of ASCII to process the built text file. Problem solved.

Really? Am I incorrect in my belief that ASCII File processing needs to be fed an ARRAY variable? Under the understanding that an array IS mandatory here: If I process to %T%, it stores the FIRST value of the file in %T[1]%, second to %T[2]%, and so on... ... but I have no way of knowing how many values are in the text file... so how would I get the FINAL value?

Hm, that makes sense. I was trying to use CSV files and ASCII Text File Process command, which ONLY accepts an ARRAY instead of a single string variable. But I suppose I can change the text file to a line-by-line format instead of csv. Thanks Paul, theSteve

Does anyone know a way to get just the LAST record from a CSV text file? (The CSV file is generated when the DATE/TIME is appended to a text file at the time of another macro's execution.) So my CSV will look like this: 04/28/2010 4:22:15 PM, 04/30/2010 1:15:02 PM, 05/01/2010 7:45:50 AM, I want to store the last entry to a variable.

That works for me, Kevin. Thanks a million. theSteve

Here's what I'm trying to do: I have an Excel cell with this content, which I'm copying to clipboard: "I like to eat %T[1]%." (Assume %T[1]% is set to "Apples") I'm setting string variable %cellContent% to the clipboard contents, then appending %cellContent% to a text file, named Fruit.txt. I want Fruit.txt to read: "I like to eat %T[1]%." I DO NOT want Fruit.txt to read: "I like to eat Apples." Is this possible?

Thanks for the idea... but ping response is recorded in milliseconds... i dont think the date/time command will provide that specific or precise a record. It really just seems that PRO has taken a step backwards from ME3 in this case. edit>correct me if i'm wrong here, though. your solution could be completely valid and here i am just dismissing it

In Macro Express 3, the Ping Site command returns a detailed string of text (including the response time). It looks like in Macro Express Pro, the PING SITE command only returns whether or not the ping was successful. So basically, it has the same functionality as the "IF PING SUCCESSFUL" command. Am I missing something? Is there a way to get the detailed string (my concern is response time) from a ping in MEpro?

Hey, I'm having troubles with the PING SITE command. I'm using Windows 7, and am behind a router... and normally consider myself an "advanced" pc user. The PING SITE command is ALWAYS returning "Unknown Host" to the selected string variable. Internet works fine. From command prompt, the "ping" command works fine. The same macro, run from an XP machine at my work, works fine. I tried disabling the Windows 7 - Windows Firewall, and that didn't help either. Any ideas?