-
Posts
5 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Everything posted by cardena
-
-
This window appears when I run a macro. What is the best option to choose? Is it asking me for a text editor?
-
Is purchasing the bundle that includes licenses for Macro Express Pro 6 and Macro Express Pro Portable a worthwhile investment? What benefits come with using the portable version? What is the size of the portable version, and what capacity thumb drive would you suggest? Thank you.
-
The array is too small - error
cardena replied to cardena's topic in Macro Express and Macro Express Pro
The search for %T[2]% works just fine. It is the search for %T[3]% that is giving me issues. -
I made a copy of an existing macro that was working well. I only need to make a small change; instead of searching for %T[2]% on line 18, I needed to search for %T[3]. When I made that change, Macro Express is giving me error "The array is too small "%T%", Line Number 18. I am not sure what is causing it. %T% was left alone, with a default of 99. Any help will be greatly appreciated. <COMMENT Value="Launchpad - Edit users. Delete contents of CC: box as well."/> <COMMENT Value="Searches for Recurring Schedule rather than Report"/> <COMMENT Value=" "/> <COMMENT Value="%T[1]% Users"/> <COMMENT Value="%T[2]% Report"/> <COMMENT Value="%T[3]% Schedule"/> <COMMENT Value=" "/> <COMMENT Value="%T[4]% Clipboard contents"/> <COMMENT Value="%T[5]% Current Date Time"/> <COMMENT Value="%T[6]% Write string to text file"/> <COMMENT Value=" "/> <COMMENT Value="Uses: h:\\rw3\\MacroExpress\\Records Skipped.txt\r\n"/> <COMMENT Value="h:\\RW3\\MacroExpress\\Records Processed.txt\r\n"/> <COMMENT Value="Turn on Keystroke Speed"/> <KEYSTROKE SPEED Delay="45"/> <CAPS LOCK Action="Off"/> <DELAY Flags="\x01" Time="0.2"/> <ASCII FILE BEGIN PROCESS Filename="H:\\A\\Search for Schedule 06-27-2019.csv" Format="CSV" Start_Record="2" Process_All="TRUE" Records="1" Variable="%T%" Start_Index="1" Parse_Blank_Lines="FALSE" Clear_Array="TRUE"/> <COMMENT Value="F5 - Home screen"/> <TEXT TYPE Action="0" Text="<F5>"/> <DELAY Flags="\x01" Time="1"/> <COMMENT Value="Wait for Pixel Color to turn gray"/> <MOUSE MOVE Option="\x02" X="566" Y="172" _PROMPT="0x000A"/> <DELAY Flags="\x01" Time="0.2"/> <REPEAT UNTIL Variable="%N[2]%" Condition="\x00" Value="14338236"/> <GET PIXEL COLOR Option="\x00" Rel_To_Screen="TRUE" Destination="%N[2]%"/> <END REPEAT/> <COMMENT Value="Click Search - bottom left"/> <MOUSE MOVE Option="\x02" X="58" Y="984" _PROMPT="0x000A"/> <DELAY Flags="\x01" Time="0.2"/> <MOUSE LEFT CLICK/> <DELAY Flags="\x01" Time="0.2"/> <COMMENT Value="Search box"/> <MOUSE MOVE Option="\x02" X="61" Y="299" _PROMPT="0x000A"/> <DELAY Flags="\x01" Time="0.2"/> <MOUSE LEFT CLICK/> <DELAY Flags="\x01" Time="0.2"/> <COMMENT Value="Type Report Name"/> <TEXT TYPE Action="0" Text="\"%T[3]%" _COMMENT="First double quote"/> <WAIT FOR TEXT PLAYBACK Indefinite="TRUE" Hours="0" Minutes="0" Seconds="0"/> <DELAY Flags="\x01" Time="0.5"/> <TEXT TYPE Action="0" Text="\"" _COMMENT="Second double quote"/> <DELAY Flags="\x01" Time="0.5"/> <TEXT TYPE Action="0" Text="<ENTER>"/> <DELAY Flags="\x01" Time="0.2"/> <MOUSE MOVE Option="\x02" X="1114" Y="253" _PROMPT="0x000A"/> <DELAY Flags="\x01" Time="0.2"/> <COMMENT Value="Wait for Pixel Color to turn blue"/> <REPEAT UNTIL Variable="%N[2]%" Condition="\x00" Value="13395490"/> <GET PIXEL COLOR Option="\x00" Rel_To_Screen="TRUE" Destination="%N[2]%"/> <END REPEAT/> <COMMENT Value="Was right report picked?"/> <COMMENT Value="Properties"/> <MOUSE RIGHT CLICK/> <DELAY Flags="\x01" Time="0.5"/> <TEXT TYPE Action="0" Text="<ARROW DOWN>"/> <DELAY Flags="\x01" Time="0.1"/> <TEXT TYPE Action="0" Text="<ARROW DOWN>"/> <DELAY Flags="\x01" Time="0.1"/> <TEXT TYPE Action="0" Text="<ENTER>"/> <DELAY Flags="\x01" Time="0.5"/> <COMMENT Value="Title"/> <CLIPBOARD EMPTY/> <DELAY Flags="\x01" Time="1"/> <MOUSE MOVE Option="\x02" X="742" Y="250" _PROMPT="0x000A"/> <DELAY Flags="\x01" Time="0.5"/> <MOUSE LEFT CLICK/> <DELAY Flags="\x01" Time="0.5"/> <TEXT TYPE Action="0" Text="<CONTROL>a"/> <DELAY Flags="\x01" Time="1"/> <CLIPBOARD COPY/> <DELAY Flags="\x01" Time="1"/> <VARIABLE SET STRING Option="\x02" Destination="%T[4]%" NoEmbeddedVars="FALSE"/> <COMMENT Value="If not the right report skip it"/> <IF VARIABLE Variable="%T[2]%" Condition="\x01" Value="%T[4]%" IgnoreCase="FALSE"/> <COMMENT Value="Skipped report Start"/> <DATE/TIME Format="yyyy-mm-dd hh:nn" Flags="\xB0" Date="2/8/2019 12:33:46 PM" Day_Offset="0" Month_Offset="0" Year_Offset="0" Hour_Offset="0" Minute_Offset="0" Second_Offset="0" Left="Center" Top="Center" Monitor="0" Variable="%T[5]%" IsDateVar="FALSE"/> <VARIABLE SET STRING Option="\x00" Destination="%T[6]%" Value="%T[5]%|%T[3]%|%T[1]%" NoEmbeddedVars="FALSE"/> <DELAY Flags="\x01" Time="1"/> <VARIABLE MODIFY STRING Option="\x12" Destination="%T[6]%" Filename="H:\\RW3\\MacroExpress\\Records Skipped.txt" Strip="TRUE" NoEmbeddedVars="FALSE"/> <COMMENT Value="Skipped report End"/> <GOTO Name="Skip" _COMMENT="Skip it"/> <END IF/> <COMMENT Value="Cancel"/> <DELAY Flags="\x01" Time="0.2"/> <MOUSE MOVE Option="\x02" X="1426" Y="914" _PROMPT="0x000A"/> <DELAY Flags="\x01" Time="0.5"/> <MOUSE LEFT CLICK/> <DELAY Flags="\x01" Time="0.5"/> <COMMENT Value="History"/> <MOUSE MOVE Option="\x02" X="742" Y="250" _PROMPT="0x000A"/> <DELAY Flags="\x01" Time="0.5"/> <MOUSE RIGHT CLICK/> <DELAY Flags="\x01" Time="0.5"/> <TEXT TYPE Action="0" Text="<ARROW DOWN>"/> <DELAY Flags="\x01" Time="0.5"/> <TEXT TYPE Action="0" Text="<ARROW DOWN>"/> <DELAY Flags="\x01" Time="0.2"/> <TEXT TYPE Action="0" Text="<ARROW DOWN>"/> <DELAY Flags="\x01" Time="0.2"/> <TEXT TYPE Action="0" Text="<ARROW DOWN>"/> <DELAY Flags="\x01" Time="0.2"/> <TEXT TYPE Action="0" Text="<ENTER>"/> <DELAY Flags="\x01" Time="2"/> <COMMENT Value="Wait for Pixel Color to turn gray"/> <MOUSE MOVE Option="\x02" X="614" Y="269" _PROMPT="0x000A"/> <DELAY Flags="\x01" Time="0.2"/> <REPEAT UNTIL Variable="%N[2]%" Condition="\x00" Value="15788516"/> <GET PIXEL COLOR Option="\x00" Rel_To_Screen="TRUE" Destination="%N[2]%"/> <END REPEAT/> <COMMENT Value="Recurring status"/> <MOUSE MOVE Option="\x02" X="658" Y="296" _PROMPT="0x000A"/> <DELAY Flags="\x01" Time="0.5"/> <MOUSE LEFT CLICK/> <DELAY Flags="\x01" Time="0.5"/> <MOUSE MOVE Option="\x02" X="477" Y="392" _PROMPT="0x000A"/> <DELAY Flags="\x01" Time="0.5"/> <MOUSE LEFT CLICK/> <DELAY Flags="\x01" Time="0.5"/> <TEXT TYPE Action="0" Text="<TAB>"/> <DELAY Flags="\x01" Time="0.5"/> <TEXT TYPE Action="0" Text="<ENTER>"/> <DELAY Flags="\x01" Time="4"/> <COMMENT Value="Filter Title"/> <MOUSE MOVE Option="\x02" X="466" Y="298" _PROMPT="0x000A"/> <DELAY Flags="\x01" Time="0.5"/> <MOUSE LEFT CLICK/> <DELAY Flags="\x01" Time="0.5"/> <TEXT TYPE Action="0" Text="<TAB>"/> <DELAY Flags="\x01" Time="0.5"/> <TEXT TYPE Action="0" Text="%T[3]%"/> <WAIT FOR TEXT PLAYBACK Indefinite="TRUE" Hours="0" Minutes="0" Seconds="0"/> <DELAY Flags="\x01" Time="0.5"/> <TEXT TYPE Action="0" Text="<TAB>"/> <DELAY Flags="\x01" Time="0.5"/> <TEXT TYPE Action="0" Text="<ENTER>"/> <DELAY Flags="\x01" Time="2"/> <COMMENT Value="Check to see if more than 1 schedule was found by clicking on the 2nd row"/> <MOUSE MOVE Option="\x02" X="643" Y="342" _PROMPT="0x000A"/> <DELAY Flags="\x01" Time="1"/> <MOUSE LEFT CLICK/> <DELAY Flags="\x01" Time="1"/> <GET PIXEL COLOR Option="\x00" Rel_To_Screen="TRUE" Destination="%N[2]%"/> <DELAY Flags="\x01" Time="0.5"/> <IF VARIABLE Variable="%N[2]%" Condition="\x00" Value="13395490" IgnoreCase="FALSE" _COMMENT="If there is more than 1 schedule with the same name"/> <COMMENT Value="Skipped report Start"/> <DATE/TIME Format="yyyy-mm-dd hh:nn" Flags="\xB0" Date="2/8/2019 12:33:46 PM" Day_Offset="0" Month_Offset="0" Year_Offset="0" Hour_Offset="0" Minute_Offset="0" Second_Offset="0" Left="Center" Top="Center" Monitor="0" Variable="%T[5]%" IsDateVar="FALSE"/> <VARIABLE SET STRING Option="\x00" Destination="%T[6]%" Value="%T[5]% - %T[3]% Duplicate" NoEmbeddedVars="FALSE"/> <DELAY Flags="\x01" Time="1"/> <VARIABLE MODIFY STRING Option="\x12" Destination="%T[6]%" Filename="H:\\RW3\\MacroExpress\\Records Skipped.txt" Strip="TRUE" NoEmbeddedVars="FALSE"/> <COMMENT Value="Skipped report End"/> <GOTO Name="Skip" _COMMENT="Skip it"/> <END IF/> <COMMENT Value="Highlight 1st recurring schedule"/> <MOUSE MOVE Option="\x02" X="636" Y="320" _PROMPT="0x000A"/> <DELAY Flags="\x01" Time="1"/> <MOUSE LEFT CLICK/> <DELAY Flags="\x01" Time="2" _COMMENT="Wait for hovering window to go away"/> <COMMENT Value="Wait for Pixel Color to turn blue"/> <REPEAT UNTIL Variable="%N[2]%" Condition="\x00" Value="13395490"/> <GET PIXEL COLOR Option="\x00" Rel_To_Screen="TRUE" Destination="%N[2]%"/> <END REPEAT/> <COMMENT Value="Edit Users"/> <MOUSE RIGHT CLICK/> <DELAY Flags="\x01" Time="1"/> <TEXT TYPE Action="0" Text="<ARROW UP>"/> <DELAY Flags="\x01" Time="0.5"/> <TEXT TYPE Action="0" Text="<ENTER>" _COMMENT="Reschedule"/> <DELAY Flags="\x01" Time="1"/> <TEXT TYPE Action="0" Text="<ARROW DOWN>"/> <DELAY Flags="\x01" Time="0.5"/> <TEXT TYPE Action="0" Text="<ENTER>" _COMMENT="Replace"/> <DELAY Flags="\x01" Time="0.5"/> <TEXT TYPE Action="0" Text="<TAB>"/> <DELAY Flags="\x01" Time="0.5"/> <TEXT TYPE Action="0" Text="<TAB>"/> <DELAY Flags="\x01" Time="0.5"/> <TEXT TYPE Action="0" Text="<ARROW UP>" _COMMENT="Replace existing schedule"/> <DELAY Flags="\x01" Time="0.5"/> <MOUSE MOVE Option="\x02" X="116" Y="430" _PROMPT="0x000A" _COMMENT="Destinations"/> <DELAY Flags="\x01" Time="0.5"/> <MOUSE LEFT CLICK/> <DELAY Flags="\x01" Time="1"/> <MOUSE MOVE Option="\x02" X="354" Y="379" _PROMPT="0x000A" _COMMENT="CC:"/> <DELAY Flags="\x01" Time="1"/> <MOUSE LEFT CLICK/> <DELAY Flags="\x01" Time="1"/> <TEXT TYPE Action="0" Text="<CONTROL>a"/> <DELAY Flags="\x01" Time="1"/> <TEXT TYPE Action="0" Text="<DELETE>"/> <DELAY Flags="\x01" Time="1"/> <MOUSE MOVE Option="\x02" X="355" Y="358" _PROMPT="0x000A" _COMMENT="To:"/> <DELAY Flags="\x01" Time="1"/> <MOUSE LEFT CLICK/> <DELAY Flags="\x01" Time="1"/> <TEXT TYPE Action="0" Text="<CONTROL>a"/> <DELAY Flags="\x01" Time="1"/> <TEXT TYPE Action="0" Text="<DELETE>"/> <DELAY Flags="\x01" Time="1"/> <TEXT TYPE Action="0" Text="%T[1]%"/> <DELAY Flags="\x01" Time="1"/> <COMMENT Value="Capture From:"/> <MOUSE MOVE Option="\x02" X="528" Y="341" _PROMPT="0x000A" _COMMENT="From:"/> <DELAY Flags="\x01" Time="1"/> <MOUSE LEFT CLICK/> <DELAY Flags="\x01" Time="1"/> <TEXT TYPE Action="0" Text="<CONTROL>a"/> <DELAY Flags="\x01" Time="1"/> <CLIPBOARD COPY/> <VARIABLE SET STRING Option="\x02" Destination="%T[7]%" NoEmbeddedVars="FALSE"/> <DELAY Flags="\x01" Time="0.5"/> <MOUSE MOVE Option="\x02" X="532" Y="343" _PROMPT="0x000A" _COMMENT="Remove highlighting of From:"/> <DELAY Flags="\x01" Time="1"/> <MOUSE LEFT CLICK/> <DELAY Flags="\x01" Time="1"/> <MOUSE MOVE Option="\x02" X="1360" Y="901" _PROMPT="0x000A" _COMMENT="Schedule"/> <DELAY Flags="\x01" Time="0.5"/> <MOUSE LEFT CLICK/> <DELAY Flags="\x01" Time="0.5"/> <COMMENT Value="Processed report Start"/> <DATE/TIME Format="yyyy-mm-dd hh:nn" Flags="\xB0" Date="2/8/2019 12:33:46 PM" Day_Offset="0" Month_Offset="0" Year_Offset="0" Hour_Offset="0" Minute_Offset="0" Second_Offset="0" Left="Center" Top="Center" Monitor="0" Variable="%T[5]%" IsDateVar="FALSE"/> <VARIABLE SET STRING Option="\x00" Destination="%T[6]%" Value="%T[5]%|%T[3]%|%T[1]%|%T[7]%" NoEmbeddedVars="FALSE"/> <VARIABLE MODIFY STRING Option="\x12" Destination="%T[6]%" Filename="H:\\RW3\\MacroExpress\\Records Processed.txt" Strip="TRUE" NoEmbeddedVars="FALSE"/> <COMMENT Value="Processed report End"/> <LABEL Name="Skip"/> <VARIABLE SET STRING Option="\x01" Destination="%T[99]%" Prompt="Stop macro at the bottom" Mask="FALSE" OnTop="FALSE" Left="Center" Top="Center" Monitor="0" _ENABLED="FALSE" _COMMENT="* * * * * * * * * * * * Prompt to pause macro * * * * * * * * * * * *"/> <ASCII FILE END PROCESS/> <COMMENT Value="Turn off Keystroke Speed"/> <KEYSTROKE SPEED Delay="0"/> <BEEP/> <DELAY Flags="\x01" Time="0.5"/> <BEEP/> <DELAY Flags="\x01" Time="0.5"/> <BEEP/> <DELAY Flags="\x01" Time="0.5"/> <TEXT BOX DISPLAY Title="End of Macro" Content="{\\rtf1\\ansi\\ansicpg1252\\deff0\\deflang1033{\\fonttbl{\\f0\\fnil\\fcharset0 Tahoma;}{\\f1\\fnil Tahoma;}}\r\n{\\colortbl ;\\red0\\green0\\blue255;}\r\n\\viewkind4\\uc1\\pard\\cf1\\b\\f0\\fs16 \r\n\\par \r\n\\par \\fs24 End of Macro\\cf0\\b0\\f1\\fs16 \r\n\\par }\r\n" Left="Center" Top="Center" Width="278" Height="200" Monitor="0" OnTop="FALSE" Keep_Focus="TRUE" Mode="\x00" Delay="0"/> Data: SandersC1 Provider Suspensions for Chart Deficiency CVMM - Provider Suspensions for Chart Deficiency (Daily) ChurchMA Provider Suspensions for Chart Deficiency SADV - Provider Suspensions for Chart Deficiency - Monthly SusoefJS Provider Suspensions for Chart Deficiency SAMC - Provider Suspensions for Chart Deficiency (Daily) guinnn Surgical Site Infections Extract for Midas (NHSN) EHAA - Surgical Site Infections Extract for Midas - Monthly guinnn Surgical Site Infections Extract for Midas (NHSN) EHAA - Surgical Site Infections Extract for Midas - Weekly navak Surgical Site Infections Extract for Midas (NHSN) EHEM - SSI Extract for Midas All Procedures - Monthly CabanC Referral Log WBDE OCCHEALTH Referral Log - Incoming Department (Monthly) BornstJX Distress Screening CPMC - Distress Screening - Monthly christkd Appointments by Status and Visit Type EHHC Onc Appts by Status and Visit Type Monthly