-
Posts
5 -
Joined
-
Last visited
Content Type
Profiles
Forums
Events
Posts 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 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
Increase font size
in Macro Express and Macro Express Pro
Posted
How can I increase the font size when there is only font size 8 to choose from? Thank you.