svallie

Thank you for the assistance. This helps tremendously. I can calculate this function very easily in like 3 lines of Excel VB Code, but I am not sure how the new Pro External Script feature works. If anyone would like to contribute, let me know. In the meantime, I will incorporate this in my Macro Express code. Thanks for your time.

I was wondering if anyone could give me any insight on how to return a specific date (MM/DD/YYYY) in time from a time caculation of say 100 days forward or backward from a chosen date (MM/DD/YYYY) For Example: User Selects Date from prompt = 1/25/2007 Count how many days back prompt = 100 User chooses "Calendar Days" or "Weekdays" = Weekdays Macro returns the answer of a date that is 100 Weekdays back from 1/25/2007 which would be 9/7/2006 The code below was posted (and pretty helpful) by someone that is doing something similar, but only based on the current date in time. I would like more flexibility in choosing any date from any date: <VARIABLE SET DECIMAL Option="\x01" Destination="%D[1]%" Mask="FALSE" OnTop="FALSE" Left="Center" Top="Center" Monitor="0"/> <VARIABLE MODIFY DECIMAL Option="\x03" Destination="%D[2]%" Value1="%D[1]%" Value2="5"/> <VARIABLE MODIFY DECIMAL Option="\x02" Destination="%D[3]%" Value1="%D[2]%" Value2="2"/> <VARIABLE MODIFY DECIMAL Option="\x00" Destination="%D[4]%" Value1="%D[3]%" Value2="%D[1]%"/> <VARIABLE MODIFY DECIMAL Option="\x05" Destination="%D[4]%" Text_Variable="%T[3]%" Places="10"/> <VARIABLE MODIFY STRING Option="\x04" Destination="%T[3]%" Variable="%N[1]%"/> <DATE/TIME Format="ddd" Flags="\x82" Date="12/30/1899" Day_Offset="%N[1]%" Month_Offset="-0" Year_Offset="0" Hour_Offset="-0" Minute_Offset="-0" Second_Offset="0" Left="Center" Top="Center" Monitor="0" Variable="%T[2]%" IsDateVar="FALSE" _IGNORE="0x0002"/> <TEXT BOX DISPLAY Title="T2" Content="%T[2]%" Left="Center" Top="Center" Width="278" Height="200" Monitor="0" OnTop="FALSE" Keep_Focus="TRUE" Mode="\x00" Delay="0"/>

Very clever guys. That works well for me. You saved me hundreds of lines of code, literally. Thank you very much.

I have a tab delimited text file something like this: ============ John 5 Tim 6 Sally 3 Fred 9 Bill 2 Bob 11 Robert 10 Tom 7 Elliott 1 ============ I have a macro that grabs a string variable (%T1%) from another file. For example [Variable set String %T1% = "Sally"]. I am trying to find a way to have the macro look in this .txt file and find %T1% (Sally) and use the reference number for the "Sally" (3) and set 3 to integer %N1%. Basically I am trying to find an easier way to loop through a text file and find the assigned integer that corresponds with the string instead of my current macro that looks like: If %T1% = "John" Then %N1% = 5 Else If %T1% = "Tim" Then %N1% = 6 Else If %T1% = "Sally" Then %N1% = 3 Else If %T1% = "Fred" Then %N1% = 9 Else If %T1% = "Bill" Then %N1% = 2 Else If %T1% = "Bob" Then %N1% = 11 Else If %T1% = "Robert" Then %N1% = 10 Else If %T1% = "Tom" Then %N1% = 7 Else If %T1% = "Elliott" Then %N1% = 1 Else End If Mind you, the text file is actually much longer. Bottom line, the reference number is the number of times I need to tab. GOAL: If %T1% = "Sally" Text Type: <TAB> 3 Times Your cooperation to assist me in this matter is very much appreciated

Some of the applications/programs I use play a sound "beep" when a certain part of the process is finished. I can't find a command for Macro Express to "Wait for Sound" before continuing with macro. I have tried long time delays, wait for window to gain focus, etc., but that doesn't work very well. The only thing consistant about my process is when it plays a sound, it is finished. If anyone has any suggestions, it would be greatly appreciated.